{"id":53892,"date":"2022-01-19T16:01:56","date_gmt":"2022-01-19T16:01:56","guid":{"rendered":"https:\/\/sii.pl\/?post_type=case-study&#038;p=53892"},"modified":"2022-07-22T11:29:01","modified_gmt":"2022-07-22T11:29:01","slug":"power-bi-and-azure-dwh-implementation","status":"publish","type":"case-study","link":"https:\/\/sii.pl\/en\/case-study\/power-bi-and-azure-dwh-implementation\/","title":{"rendered":"Improvement of data analysis with Power BI reports"},"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 client decided to replace Excel and manual reporting with a modern analytical platform, data warehouse and Power BI reports.<\/p>\n<\/div>\n<h2>What we did<\/h2>\n<ul>\n<li>Designed and implemented a solution based entirely on the Microsoft Azure cloud and the Power BI platform.<\/li>\n<li>Used several Azure services to integrate data from 6 different source systems.<\/li>\n<li>Implemented Azure Analysis Services to ensure flexibility and performance of the solution.<\/li>\n<li>Complemented the solution with reports built on the Power BI platform.<\/li>\n<\/ul>\n<h2>Benefits for the client<\/h2>\n<ul>\n<li>Improved data analysis thanks to real-time access to up-to-date information<\/li>\n<li>Ability to create reports based on an analytical model<\/li>\n<li>Management workload and cost of reporting reduced by 80%<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The challenge The client decided to replace Excel and manual reporting with a modern analytical platform, data warehouse and Power &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.pl\/en\/case-study\/power-bi-and-azure-dwh-implementation\/\">Continued<\/a><\/p>\n","protected":false},"author":39,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[4152,5275],"industry":[1660],"client":[5205],"technologies":[5207,5210,3219,5212],"country":[],"class_list":["post-53892","case-study","type-case-study","status-publish","hentry","offering-data-analytics","offering-dynamics-365-d365","industry-retail-e-commerce","client-canpack-en","technologies-azure-analysis-services-en","technologies-azure-data-factory-en","technologies-azure-sql","technologies-ms-power-bi-en"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/case-study\/53892"}],"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\/39"}],"wp:attachment":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/media?parent=53892"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/offering?post=53892"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/industry?post=53892"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/client?post=53892"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/technologies?post=53892"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/country?post=53892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}