{"id":130,"date":"2015-02-17T00:00:00","date_gmt":"2015-02-17T00:00:00","guid":{"rendered":"https:\/\/sii.ua\/?case-study=etl-processes-development"},"modified":"2015-02-17T00:00:00","modified_gmt":"2015-02-17T00:00:00","slug":"etl-processes-development","status":"publish","type":"case-study","link":"https:\/\/sii.ua\/en\/case-study\/etl-processes-development\/","title":{"rendered":"ETL processes development"},"content":{"rendered":"<h2>The challenge<\/h2>\n<p>A need for one global data warehouse storing data from all the Client&#8217;s branches around the world. In addition, a lot of regions or independent units need data for reports, which must be collected from different systems.<\/p>\n<h2>What we did<\/h2>\n<ul>\n<li>We created a global data warehouse from scratch, integrating data from different CRM systems from the whole world.<\/li>\n<li>We created ETL processes for supplying the data warehouse and separate applications supporting sellers, and also scientific-technical workers.<\/li>\n<li>We created processes, aggregating data for report systems.<\/li>\n<\/ul>\n<h2>Effects<\/h2>\n<ul>\n<li>Data warehouse, serving the most of the European, Asian and American countries.<\/li>\n<li>Reports with data prepared by us are used by the main management staff in the head office in Basel and San Francisco.<\/li>\n<li>Scientists use the data prepared by us for further research work.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The challenge A need for one global data warehouse storing data from all the Client&#8217;s branches around the world. In &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.ua\/en\/case-study\/etl-processes-development\/\">Continued<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[],"industry":[1110],"client":[16],"technologies":[655,656,501],"country":[],"class_list":["post-130","case-study","type-case-study","status-publish","hentry","industry-healthcare","client-roche-en","technologies-etl-2","technologies-informatica-powercenter-2","technologies-oracle-11g-2"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/case-study\/130"}],"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=130"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/offering?post=130"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/industry?post=130"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/client?post=130"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/technologies?post=130"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/country?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}