{"id":20903,"date":"2020-02-28T11:38:22","date_gmt":"2020-02-28T11:38:22","guid":{"rendered":"https:\/\/new-www.sii.pl\/?post_type=case-study&#038;p=20903"},"modified":"2025-07-17T10:40:48","modified_gmt":"2025-07-17T10:40:48","slug":"power-bi-for-ministry-of-justice-national-criminal-register","status":"publish","type":"case-study","link":"https:\/\/sii.pl\/en\/case-study\/power-bi-for-ministry-of-justice-national-criminal-register\/","title":{"rendered":"Implementation of Power BI reports for National Criminal Register"},"content":{"rendered":"<h2>The challenge<\/h2>\n<div class=\"sii-rl-content-item-value sii-rl-businessNeed-value sii-rl-content-item-value-display\">\n<div class=\"sii-rl-content-item sii-rl-businessNeed\">\n<div class=\"sii-rl-content-item-value sii-rl-businessNeed-value sii-rl-content-item-value-display\">\n<div>\n<div class=\"ng-scope\">\n<div class=\"ng-binding\">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.<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>What we did<\/h2>\n<ul>\n<li>Designed the architecture: in-memory analytic layer (analytical model) and data layer &#8211; Data Mart.<\/li>\n<li>Provided extraction, transformation, and data loading (ETL) built on Microsoft SQL Server Integration Services.<\/li>\n<li>Applied\u00a0the Power BI reporting tool<\/li>\n<li>Built an analytical model<\/li>\n<li>Implemented Data Mart<\/li>\n<li>Executed\u00a0102 reports<\/li>\n<\/ul>\n<h2>Benefits for the client<\/h2>\n<ul>\n<li>Improvement of the reporting system<\/li>\n<li>Enabling exporting reports to selected formats<\/li>\n<li>Training of the users in the operation of the PowerBI tool and the use of the prepared analytical model<\/li>\n<li>Possibility for the KRK employees to build analyzes on their own<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The challenge The client needed to create a reporting environment based on Power BI technology and a tabular model as &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.pl\/en\/case-study\/power-bi-for-ministry-of-justice-national-criminal-register\/\">Continued<\/a><\/p>\n","protected":false},"author":33,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[4152,1474],"industry":[1659],"client":[1494],"technologies":[2078,2260,3346],"country":[6076],"class_list":["post-20903","case-study","type-case-study","status-publish","hentry","offering-data-analytics","offering-digital","industry-public","client-ministerstwo-sprawiedliwosci-en","technologies-ms-sql-server-2","technologies-power-bi","technologies-ssas-analysis-service","country-poland"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/case-study\/20903"}],"collection":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/users\/33"}],"wp:attachment":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/media?parent=20903"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/offering?post=20903"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/industry?post=20903"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/client?post=20903"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/technologies?post=20903"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/country?post=20903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}