{"id":60991,"date":"2022-06-13T16:09:14","date_gmt":"2022-06-13T16:09:14","guid":{"rendered":"https:\/\/sii.pl\/?post_type=case-study&#038;p=60991"},"modified":"2022-07-04T15:34:43","modified_gmt":"2022-07-04T15:34:43","slug":"power-bi-and-azure-dwh-implementation-2","status":"publish","type":"case-study","link":"https:\/\/sii.pl\/en\/case-study\/power-bi-and-azure-dwh-implementation-2\/","title":{"rendered":"Improving report collection with Power BI and Azure DWH implementation"},"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 class=\"ng-scope\">\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 class=\"ng-scope\">\n<p>The client&#8217;s reporting system was based entirely on the transaction database of the ERP system REKORD, and the extracted data was processed manually, often using MS Excel. Due to the development of the company the current method of creating reports became ineffective, so the client needed a change of approach and tools.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>What we did<\/h2>\n<ul>\n<li>Created a data warehouse based on the Azure SQL database<\/li>\n<li>Used Azure Data Factory pipelines to ingest the data<\/li>\n<li>Introduced the Power BI cloud solution acting as an analytical model, and a tool that creates reports for end-users<\/li>\n<li>Managed the tasks in the project using Azure DevOps<\/li>\n<\/ul>\n<h2>Benefits for the client<\/h2>\n<div class=\"sii-rl-reference-lang-background ng-scope\" data-ng-repeat=\"item in ViewModel.ReferenceModel.ReferenceLanguages\" data-ng-show=\"ViewModel.SelectedLanguage.Value==item.LangName\">\n<div class=\"sii-rl-content-item sii-rl-effects\">\n<div class=\"sii-rl-content-item-value sii-rl-effects-value sii-rl-content-item-value-display\">\n<div class=\"ng-scope\">\n<div class=\"sii-rl-reference-lang-background ng-scope\" data-ng-repeat=\"item in ViewModel.ReferenceModel.ReferenceLanguages\" data-ng-show=\"ViewModel.SelectedLanguage.Value==item.LangName\">\n<div class=\"sii-rl-content-item sii-rl-effects\">\n<div class=\"sii-rl-content-item-value sii-rl-effects-value sii-rl-content-item-value-display\">\n<div class=\"ng-scope\">\n<ul>\n<li>Facilitation of the work of the Controlling, Sales, and Supply Chain Department<\/li>\n<li>Speeding the report creation, thanks to the reduction of data manual processing<\/li>\n<li>Data warehouse organizes and defines the KPIs and acts as the main source of\u00a0truthful data<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Due to the development of the company the current method of creating reports was ineffective. A change of approach and tools was required.<\/p>\n","protected":false},"author":39,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[4152],"industry":[1660],"client":[5454],"technologies":[5210,3219,2260],"country":[],"class_list":["post-60991","case-study","type-case-study","status-publish","hentry","offering-data-analytics","industry-retail-e-commerce","client-anwis","technologies-azure-data-factory-en","technologies-azure-sql","technologies-power-bi"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/case-study\/60991"}],"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=60991"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/offering?post=60991"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/industry?post=60991"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/client?post=60991"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/technologies?post=60991"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/country?post=60991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}