{"id":190,"date":"2017-09-05T00:00:00","date_gmt":"2017-09-05T00:00:00","guid":{"rendered":"https:\/\/sii.ua\/?case-study=quickstart-data-warehouse"},"modified":"2017-09-05T00:00:00","modified_gmt":"2017-09-05T00:00:00","slug":"quickstart-data-warehouse","status":"publish","type":"case-study","link":"https:\/\/sii.ua\/en\/case-study\/quickstart-data-warehouse\/","title":{"rendered":"Quickstart! data warehouse"},"content":{"rendered":"<h2>The challenge<\/h2>\n<p>The implementation of an analytical tool supporting marketing campaigns<\/p>\n<h2>What we did<\/h2>\n<ul>\n<li>Implementation of a complete ETL process for QuickStart! marketing data warehouse in Turkey, United Arab Emirates and Oman<\/li>\n<li>Rework of a global customer deduplication mechanism<\/li>\n<li>Privileges scheme re-work<\/li>\n<li>Data anonymization tool implementation<\/li>\n<li>Implementation of rule-based data quality assurance<\/li>\n<li>Database tuning<\/li>\n<\/ul>\n<h2>Effects<\/h2>\n<ul>\n<li>Single Customer View implemented<\/li>\n<li>Direct marketing campaign management tools made available<\/li>\n<li>Generation of leads for Call Centers under control<\/li>\n<li>Global, standarized reporting made available<\/li>\n<li>New reporting platform created to exchange cooperation actuals between AIG and HSBC<\/li>\n<li>New analytical opportunities created thanks to data anonymization<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The challenge The implementation of an analytical tool supporting marketing campaigns What we did Implementation of a complete ETL process &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.ua\/en\/case-study\/quickstart-data-warehouse\/\">Continued<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[229],"industry":[1104],"client":[85],"technologies":[770,604,769],"country":[],"class_list":["post-190","case-study","type-case-study","status-publish","hentry","offering-data-analytics","industry-retail-banking","client-aig-en","technologies-mssql-integration-services-and-aig-inhouse-etl-tools","technologies-oracle-10-2","technologies-sql-server-2008-r2"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/case-study\/190"}],"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=190"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/offering?post=190"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/industry?post=190"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/client?post=190"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/technologies?post=190"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/country?post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}