{"id":239,"date":"2019-08-27T00:00:00","date_gmt":"2019-08-27T00:00:00","guid":{"rendered":"https:\/\/sii.ua\/?case-study=cloud-data-warehouse-etl-development"},"modified":"2019-08-27T00:00:00","modified_gmt":"2019-08-27T00:00:00","slug":"cloud-data-warehouse-etl-development","status":"publish","type":"case-study","link":"https:\/\/sii.ua\/en\/case-study\/cloud-data-warehouse-etl-development\/","title":{"rendered":"Cloud data warehouse &#038; ETL development"},"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>Complete buildup of a fully autonomous cloud data warehouse, encompassing ERP, fishing and production data; including automatic and frequent data refresh.<\/p>\n<\/div>\n<h2>What we did<\/h2>\n<div class=\"sii-rl-content-item sii-rl-whatWeDid\">\n<div class=\"sii-rl-content-item-value sii-rl-whatWeDid-value sii-rl-content-item-value-display\">\n<div class=\"ng-scope\">\n<div class=\"tw-swapa\">\n<ul>\n<li>Sii has been selected as a strategic IT partner in the area of data warehouse construction,<\/li>\n<li>The project involved extracting the data from a variety of sources, most of all the client\u2019s ERP system and some specialized company-wide systems, as well as third party tools, and building a big, autonomous and coherent data warehouse,<\/li>\n<li>A team of consultants\/developers has been working both on the customer\u2019s location and remotely to ensure the full understanding of the client\u2019s business processes, operations and data,<\/li>\n<li>Sii has also performed a thorough description, classification and filtering of the generated data, to make the outcome easily understood and used by the business.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>Effects<\/h2>\n<p>Sii specialists have built a central warehouse for client\u2019s key data and third party information, enabling the company to perform a cross-sectional, company wide analysis of their operations, as well as build predictive models for optimizing their catch and production, thus highly contributing to the increase of productivity and yield.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The challenge Complete buildup of a fully autonomous cloud data warehouse, encompassing ERP, fishing and production data; including automatic and &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.ua\/en\/case-study\/cloud-data-warehouse-etl-development\/\">Continued<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[229,207],"industry":[1112],"client":[103],"technologies":[404,405,406,407,408,274,409],"country":[],"class_list":["post-239","case-study","type-case-study","status-publish","hentry","offering-data-analytics","offering-testing-qa","industry-retail-e-commerce","client-aker-biomarine-en","technologies-cloud-storage","technologies-composer-apache-airflow","technologies-google-cloud-platforms-big-query","technologies-integration-services","technologies-mysql","technologies-python","technologies-sql-server"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/case-study\/239"}],"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=239"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/offering?post=239"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/industry?post=239"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/client?post=239"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/technologies?post=239"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/country?post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}