Part three of this three-part series addresses some of the additional benefits realized by our example client along with the reasons that decision-makers in the company found the Power BI system to be such a valuable solution. (Part 3 of 3)
Search, Filtering, Sorting, and Grouping - Part 1 of 4
In part two of this three-part series, we review the factors that prompted us to deploy a BI solution. We then detail some of the factors that caused us to select Microsoft’s Power BI platform… as well as the tools provided by Microsoft to facilitate development and deployment of the solution. (Part 2 of 3)
In part one of this three-part series, we review some circumstances that would lead an organization to decide to implement a BI (Business Intelligence) solution. In particular, we look at a manufacturing business that was tracking production data outside of their primary business application. (Part 1of 3)
Upgrading old technology to new technology is typically a challenge. The need for enhancements to get additional results and feedback often drives the need to make it happen, regardless.
Technology used: Crystal Reports, SQL Server 2008, T-SQL Selects, SQL Views, Stored Procedures, Triggers, Export to Excel and .CSV for further manipulation, and VB.NET
Using powerful 3rd party Excel library and Microsoft Excel itself, we've build and provided a dynamic web-based fee calculator hosting in the current website using role based and page based security and more. Technology used: Microsoft Excel, Spreadsheet Gear (spreadsheetgear.com), IIS, and ASP.Net.
Several Microsoft Access schema, forms, and reports changes force a Microsoft Access version upgrade and data migration with the final step being a Microsoft SQL upsizing project. The technology used: Microsoft Access, FMS tools (www.fmsinc.com), Microsoft VBA, Microsoft SQL Server.
Automation reduces a two-day, two-person, labor-intensive process (that wasn't enjoyed by anyone) to a 5-10 minute process. At the end of the day, the professionals who used to gather, organize, and build the presentation were freed up to do other things. The technology used: Microsoft SQL Server, Microsoft Task Scheduler, Microsoft SSIS, Datawatch Data Pump, Microsoft VBA, and Microsoft Excel.