{"id":252,"date":"2019-09-27T00:00:00","date_gmt":"2019-09-27T00:00:00","guid":{"rendered":"https:\/\/sii.ua\/?case-study=reports-and-data-warehouse"},"modified":"2019-09-27T00:00:00","modified_gmt":"2019-09-27T00:00:00","slug":"reports-and-data-warehouse","status":"publish","type":"case-study","link":"https:\/\/sii.ua\/en\/case-study\/reports-and-data-warehouse\/","title":{"rendered":"Reports and data warehouse"},"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>Work on many projects, among others in the area of creating reports, maintaining the wholesaler\u2019s and the reporting platform as well as data cleaning.<\/p>\n<\/div>\n<h2>What we did<\/h2>\n<p>Sii\u2019s tasks included:<\/p>\n<ul>\n<li>SSRS \u2013 creating and modifying reports.<\/li>\n<li>Maintaining the wholesaler\u2019s and the reporting platform.<\/li>\n<li>SSIS \u2013 supplying the wholesaler\u2019s, (a transaction base which is stores data using the star and snowflake model), through staging bases and ODS including profiling and data cleaning, data aggregation from the ASE and Parcaref application.<\/li>\n<li>Business report platform development.<\/li>\n<li>SQL Server \u2013 procedures collecting data for the application.<\/li>\n<li>Maintaining a transactional base for the Hubble application.<\/li>\n<\/ul>\n<h2>Effects<\/h2>\n<p>Projects:<\/p>\n<ul>\n<li>Monitoring Data Ware House \u2013 monitoring of IT notifications as well as breakdowns and defects in trucks.<\/li>\n<li>Post-sales expenses \u2013 analysis and optimization of post-sales costs including mileages, services, repairs and truck damages.<\/li>\n<li>An analysis of technical drawings of the truck models in order to analyze the parts used in the vehicles (original, replacement, regenerated part).<\/li>\n<li>Defining the wear of the parts, the moment of replacement, the supply of given elements in the warehouses and at dealers\u2019, based on a probability schedule for particular parts and the vehicle mileage.<\/li>\n<li>Analysis of truck orders with the purpose of detecting weight and measurement anomalies between the systems of the dealers and the internal systems.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The challenge Work on many projects, among others in the area of creating reports, maintaining the wholesaler\u2019s and the reporting &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.ua\/en\/case-study\/reports-and-data-warehouse\/\">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":[268],"country":[],"class_list":["post-252","case-study","type-case-study","status-publish","hentry","offering-data-analytics","industry-automotive","client-volvo-it-en","technologies-microsoft-sql-server-2008"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/case-study\/252"}],"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=252"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/offering?post=252"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/industry?post=252"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/client?post=252"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/technologies?post=252"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/country?post=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}