PRM – Reporting Transformation for Nilfisk
**Scope:** Modernization of the Data Warehouse & Development of Tabular Cubes
**Technologies:** Microsoft SQL Server, SSIS, Analysis Services (Tabular Model), Excel
**Overview:** GritBI Kft. collaborated with Nilfisk A/S to upgrade their reporting infrastructure by replacing an outdated reporting system with a scalable Microsoft-based solution. The initiative, referred to as PRM (Performance Reporting Model), aimed to convert disjointed legacy reports into a unified, high-performance reporting framework.
**Key Deliverables:**
- Developed a robust ETL process utilizing SQL Server Integration Services (SSIS) to extract and load data from various legacy sources.
- Created a Tabular Cube with SQL Server Analysis Services (SSAS) to facilitate rapid, interactive data analysis.
- Produced a final solution that easily integrates with Excel Pivot Tables, enabling business users to access and analyze data without needing specialized BI tools.
**Outcome:** The PRM solution greatly enhanced reporting efficiency, minimized manual tasks, and provided Nilfisk's teams with precise, real-time insights through familiar tools like Excel.