{"id":7094,"date":"2019-08-27T00:00:00","date_gmt":"2019-08-27T00:00:00","guid":{"rendered":"https:\/\/new-www.sii.pl\/case\/cloud-data-warehouse-etl-development\/"},"modified":"2022-07-22T10:52:41","modified_gmt":"2022-07-22T10:52:41","slug":"cloud-data-warehouse-etl-development","status":"publish","type":"case-study","link":"https:\/\/sii.pl\/en\/case-study\/cloud-data-warehouse-etl-development\/","title":{"rendered":"Improvement of data capabilities by implementing cloud 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<div class=\"sii-rl-content-item sii-rl-businessNeed\">\n<div class=\"sii-rl-content-item-value sii-rl-businessNeed-value sii-rl-content-item-value-display\">\n<div>\n<div class=\"ng-scope\">\n<div class=\"ng-binding\">The client needed support in building a fully autonomous cloud data warehouse, encompassing ERP, fishing, and production data, enabling automatic and frequent data refreshing.<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\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>Acknowledged the client&#8217;s operations, processes, and problems through fieldwork in Oslo and Houston.<\/li>\n<li>Collected, managed and visualized AKBM data to support accurate business decisions.<\/li>\n<li>Extracted data from multiple sources: the ERP system, specialized company applications and websites.<\/li>\n<li>Designed a reliable automated data warehouse powered by data from numerous systems.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>Benefits for the client<\/h2>\n<ul>\n<li>Improving data and analytics capabilities for the entire organization<\/li>\n<li>Increase in productivity and yield through the use of predictive models<\/li>\n<li>Optimization of transport costs<\/li>\n<li>User-friendly dashboards and real-time reporting tools<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The challenge The client needed support in building a fully autonomous cloud data warehouse, encompassing ERP, fishing, and production data, &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.pl\/en\/case-study\/cloud-data-warehouse-etl-development\/\">Continued<\/a><\/p>\n","protected":false},"author":16,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[4152],"industry":[1660],"client":[1626],"technologies":[2237,2238,2239,2240,2241,1806,2242],"country":[],"class_list":["post-7094","case-study","type-case-study","status-publish","hentry","offering-data-analytics","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.pl\/en\/wp-json\/wp\/v2\/case-study\/7094"}],"collection":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/users\/16"}],"wp:attachment":[{"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/media?parent=7094"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/offering?post=7094"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/industry?post=7094"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/client?post=7094"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/technologies?post=7094"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.pl\/en\/wp-json\/wp\/v2\/country?post=7094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}