{"id":123,"date":"2015-02-12T00:00:00","date_gmt":"2015-02-12T00:00:00","guid":{"rendered":"https:\/\/sii.ua\/?case-study=bi-for-diagnostics-system"},"modified":"2015-02-12T00:00:00","modified_gmt":"2015-02-12T00:00:00","slug":"bi-for-diagnostics-system","status":"publish","type":"case-study","link":"https:\/\/sii.ua\/en\/case-study\/bi-for-diagnostics-system\/","title":{"rendered":"BI for diagnostics system"},"content":{"rendered":"<h2>The challenge<\/h2>\n<p>Building a scalable BI solution for\u00a0the Client&#8217;s diagnostics system deployed for one of customers.<\/p>\n<h2>What we did<\/h2>\n<ul>\n<li>ETL \u2013 the whole process of data mart loading with data extracted from OLTP PostgreSQL and MSSQL servers.<\/li>\n<li>Data analysis tier built with Tabular Mode of SSAS.<\/li>\n<li>Advanced SSRS reporting scheduler.<\/li>\n<li>Flexible managers\u2019 and analysts\u2019 dashboards built with PowerView.<\/li>\n<\/ul>\n<h2>Effects<\/h2>\n<ul>\n<li>Built custom reports conforming with the client\u2019s templates.<\/li>\n<li>SSRS reporting processes configured.<\/li>\n<li>SSRS reporting user interface seamlessly integrated with the diagnostics system application.<\/li>\n<li>Client\u2019s analysts\u2019 team trained to build further reports.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The challenge Building a scalable BI solution for\u00a0the Client&#8217;s diagnostics system deployed for one of customers. What we did ETL &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.ua\/en\/case-study\/bi-for-diagnostics-system\/\">Continued<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[],"industry":[1108],"client":[14],"technologies":[255,356,606,803,486,637,830,766,765],"country":[],"class_list":["post-123","case-study","type-case-study","status-publish","hentry","industry-automotive","client-bombardier-en","technologies-it-application-en","technologies-ms-sql-server-2","technologies-postgresql-2","technologies-powerview-2","technologies-sql-reporting-services-2","technologies-sql-server-2012-2","technologies-sql-server-analysis-services-2","technologies-ssas-analysis-service","technologies-ssrs-reporting-services"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/case-study\/123"}],"collection":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/offering?post=123"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/industry?post=123"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/client?post=123"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/technologies?post=123"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/country?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}