{"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":"2020-03-25T10:26:53","modified_gmt":"2020-03-25T10:26:53","slug":"power-bi-for-ministry-of-justice-national-criminal-register","status":"publish","type":"case-study","link":"https:\/\/siisweden.se\/en\/case-study\/power-bi-for-ministry-of-justice-national-criminal-register\/","title":{"rendered":"Power BI for Ministry of Justice &#8211; 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<p>The main goal of the project was to create a reporting environment based on Power BI technology and a tabular model as a data source. The implementation of the order also included the creation of several dozen defined reports.<\/p>\n<\/div>\n<h2>What we did<\/h2>\n<p>The architecture of the solution was based on the construction of the in-memory analytic layer (analytical model) and data layer &#8211; Data Mart. The process of extraction, transformation and data loading (ETL) was built through programmatically generated Microsoft SQL Server Integration Services (SSIS) packages and scheduled using SQL Server Agent tasks. The source of data is the KRK database. Reporting is provided by the Power BI Report Server service. The scope of work included:<\/p>\n<ul>\n<li>Implementation of the Power BI reporting tool along with the creation of defined reports<\/li>\n<li>Building an analytical model<\/li>\n<li>Implementation of the database constituting the Mart Data System of the KRK<\/li>\n<li>Starting the power supply process<\/li>\n<li>Execution of 102 dedicated reports<\/li>\n<li>Users&#8217; training in building reports in Power BI<\/li>\n<\/ul>\n<h2>Effects<\/h2>\n<p>Prepared reports have improved reporting and provide export capabilities to selected formats. The users were also trained both from the operation of the PowerBI tool itself, as well as from the use of the prepared analytical model. This gives the opportunity to build analyzes by the KRK employees themselves.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The challenge The main goal of the project was to create a reporting environment based on Power BI technology and &hellip; <a class=\"continued-btn\" href=\"https:\/\/siisweden.se\/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],"industry":[1659],"client":[1494],"technologies":[2078,2260,3346],"country":[],"class_list":["post-20903","case-study","type-case-study","status-publish","hentry","offering-data-analytics","industry-public","client-ministerstwo-sprawiedliwosci-en","technologies-ms-sql-server-2","technologies-power-bi","technologies-ssas-analysis-service"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/case-study\/20903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/users\/33"}],"wp:attachment":[{"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/media?parent=20903"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/offering?post=20903"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/industry?post=20903"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/client?post=20903"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/technologies?post=20903"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/siisweden.se\/en\/wp-json\/wp\/v2\/country?post=20903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}