{"id":191,"date":"2017-09-06T00:00:00","date_gmt":"2017-09-06T00:00:00","guid":{"rendered":"https:\/\/sii.ua\/?case-study=etl-reporting"},"modified":"2017-09-06T00:00:00","modified_gmt":"2017-09-06T00:00:00","slug":"etl-reporting","status":"publish","type":"case-study","link":"https:\/\/sii.ua\/en\/case-study\/etl-reporting\/","title":{"rendered":"ETL &#038; Reporting"},"content":{"rendered":"<h2>The challenge<\/h2>\n<p>Work in the ETL, reporting, data mining, servicing and defect reporting areas.<\/p>\n<h2>What we did<\/h2>\n<ul>\n<li>ETL \u2013 the whole process of supplying the data warehouse, from source files to OLAP wholesale tables (cubes)<\/li>\n<li>Managing the business reports platform<\/li>\n<li>Wholesale and reporting platform maintenance<\/li>\n<li>Managing cubes and sizes (in most cases excluding the creation of cube projects, but creating database structures with fact and size tables)<\/li>\n<li>After sales truck service and the maintenance of existing solutions<\/li>\n<\/ul>\n<h2>Effects<\/h2>\n<ul>\n<li>ASE \u2013 after-sales service, vehicle mileage analysis.<\/li>\n<li>Parcaref \u2013 analysis of trucks by parts.<\/li>\n<li>Hubble \u2013 defining parts wear, moment of change, resources of elements in the warehouses and at dealers\u2019, based on probability schedule for particular parts and vehicle mileage.<\/li>\n<\/ul>\n<p>Each of these projects is a continuation of a previous one. They are conducted in order to optimize car parts sales.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The challenge Work in the ETL, reporting, data mining, servicing and defect reporting areas. What we did ETL \u2013 the &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.ua\/en\/case-study\/etl-reporting\/\">Continued<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[229],"industry":[1108],"client":[45],"technologies":[],"country":[],"class_list":["post-191","case-study","type-case-study","status-publish","hentry","offering-data-analytics","industry-automotive","client-volvo-it-en"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/case-study\/191"}],"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=191"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/offering?post=191"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/industry?post=191"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/client?post=191"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/technologies?post=191"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/country?post=191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}