We got to work. We began by building out a SQL Server-based data warehouse to combine data from across the enterprise. SQL Server Integration Services was used to extract data from our client’s ERP system, timekeeping system, accounting system and assorted flat files. The data was then combined into a coherent picture of the enterprise operation within the data warehouse. Next, we implemented several tabular data models on top of the data warehouse using Analysis Services. These data models present data in a manner that is familiar, offering user-friendly naming while hiding data complexity. The data models also capture intricate business calculations such as efficiency and utilization as well as rework and scrap percentages. This ensures metrics are consistent enterprise-wide.
We utilized Power BI for data visualizations, dashboards, and self-service reporting. Power BI paginated reports were used for larger, multi-page reports. A secure internal portal now manages all reports and dashboards for a seamless user experience.
As their data analytics usage matured, Power BI began to be utilized by several power users within the company. This self-service data exploration allows for quick answers to ad-hoc data questions. The self-service exploration utilizes the same tabular data models as the rest of the reporting within the organization. This ensures information is consistent across all data visualizations.
