Client
One of the ministries of Poland, a Common Courts portal, and a chief body of state administration responsible for the Justice government administration department. The ministry is responsible for the maintenance of many key state registers, e.g. the National Court Register (KRS) or the National Criminal Register (KRK).
The challenge
The client needed to create a reporting environment based on Power BI technology and a tabular model as a data source. The project also included the creation of several dozen defined reports.
What we did
- Designed the architecture: in-memory analytic layer (analytical model) and data layer - Data Mart.
- Provided extraction, transformation, and data loading (ETL) built on Microsoft SQL Server Integration Services.
- Applied the Power BI reporting tool
- Built an analytical model
- Implemented Data Mart
- Executed 102 reports
Benefits for the client
- Improvement of the reporting system
- Enabling exporting reports to selected formats
- Training of the users in the operation of the PowerBI tool and the use of the prepared analytical model
- Possibility for the KRK employees to build analyzes on their own