{"id":83803,"date":"2024-12-06T15:20:23","date_gmt":"2024-12-06T13:20:23","guid":{"rendered":"https:\/\/intellias.com\/?p=83803"},"modified":"2025-04-01T11:32:25","modified_gmt":"2025-04-01T08:32:25","slug":"harnessing-the-power-of-the-cloud-data-warehouse-migration-for-a-b2b-retailer","status":"publish","type":"post","link":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/","title":{"rendered":"Harnessing the Power of the Cloud: Data Warehouse Migration for a B2B Retailer"},"content":{"rendered":"<h2 id=\"project-snapshot\">Project snapshot<\/h2>\n<p>In just two months, Intellias cloud engineers and architects designed, planned, and deployed cloud infrastructure to unlock Microsoft Azure\u2019s advanced <a href=\"https:\/\/intellias.com\/data-warehousing-ebook\/\">data warehousing<\/a> capabilities. With a team of three, we helped our client achieve next-level performance of their data management resources and enhance data accessibility.<\/p>\n<p>Our client is a European B2B provider of specialized medical and beauty products. Established more than 50 years ago, the company has grown to become a vendor of products and services for thousands of customers, managing 2,000+ orders daily. The retail business handles large volumes of diverse data coming from its vast network of subsidiaries and partners.<\/p>\n<h2 id=\"business-challenge\">Business challenge<\/h2>\n<p>The client faced issues in gathering and consolidating data received from multiple branches and subsidiaries operating different hardware and software platforms. Existing on-premises infrastructure could not ensure effective unification of data and its preprocessing for further use in generating business insights.<\/p>\n<p>The non-cohesive data processing system resulted in suboptimal analytics and a lack of strategic decision-making, causing issues in other areas such as marketing and inventory management. With fragmented data flows, the company could not derive insights for personalized campaigns, which led to reduced customer engagement and loyalty. At the same time, the legacy system was difficult to maintain and support.<\/p>\n<div><a href=\"https:\/\/intellias.com\/data-science-and-big-data\/\" class=\"cta-wrap \">\n                    <div class=\"left-col\">\n                        <p class=\"cta-title\">Discover the potential of your data. <\/p>\n                        <div class=\"cta-block__content\">\n                            <div class=\"description\"><\/div>\n                        <\/div>\n                    <\/div>\n                     <span class=\"btn-filled\">Learn more<\/span>\n\t\t        <\/a><\/div>\n<h2 id=\"solution-delivered\">Solution delivered<\/h2>\n<p>Our client\u2019s on-premises infrastructure was built using Microsoft components; therefore, the logical solution was to choose Microsoft Azure as the cloud service for hosting migrated resources. This strategy was selected to preserve the client\u2019s infrastructure and minimize the need for reconfiguration.<\/p>\n<p>Leveraging our expertise in the design and implementation of Microsoft Azure cloud solutions, we built an actionable strategy for migrating the client\u2019s infrastructure to the Azure cloud. To ensure continuous operation of the client\u2019s environment, we used the lift and shift approach for moving on-premises resources to the cloud. With lift and shift, we enhanced project predictability, assured project completion within the planned time frame, and reduced the probability of errors.<\/p>\n<p>To improve productivity of the client\u2019s database and ensure effective data ingestion and availability, we migrated five on-premises databases with a total data volume of approximately 1 TB from Microsoft SQL Server to an Azure SQL Managed Instance. To accelerate the migration process, we used the lift and shift approach enabled by the Microsoft Azure platform for on-premises SQL Server Integration Services (SSIS) solutions.<\/p>\n<p>Data integrations enabled by SSIS were migrated to Azure SSIS Runtime, taking advantage of Azure Data Factory as the orchestration service. In total, we migrated 55 ETL pipelines to the cloud.<\/p>\n<p>In the new configuration, the retail business now benefits from using consolidated cloud storage for multiple data files received from diverse sources. Preprocessed data is transformed into actionable business intelligence by Microsoft Power BI, an AI-assisted platform that generates insights and represents them as rich visualizations.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-83805\" src=\"https:\/\/d17ocfn2f5o4rl.cloudfront.net\/wp-content\/uploads\/2024\/12\/body-im-1-Harnessing-the-Power-of-the-Cloud.jpg\" alt=\"Solution delivered\" width=\"770\" height=\"550\" srcset=\"https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/body-im-1-Harnessing-the-Power-of-the-Cloud.jpg 770w, https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/body-im-1-Harnessing-the-Power-of-the-Cloud-300x214.jpg 300w, https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/body-im-1-Harnessing-the-Power-of-the-Cloud-768x549.jpg 768w\" sizes=\"auto, (max-width: 770px) 100vw, 770px\" \/><\/p>\n<h2 id=\"business-outcomes\">Business outcomes<\/h2>\n<p>Migrating data warehousing infrastructure to the cloud unlocked new data management opportunities for our client. In addition to the flexibility, scalability, and high performance that are signature characteristics of Microsoft Azure cloud environments, the client noted overall improvements in enterprise data flows:<\/p>\n<ul>\n<li><strong>Higher operational efficiency<\/strong> as a result of improved data availability and accessibility and high responsiveness of cloud storage solutions<\/li>\n<li><strong>Accelerated reporting<\/strong> achieved by improving data infrastructure throughput and reducing latency<\/li>\n<li><strong>Flexible resource provisioning<\/strong> enabled by dynamic scalability of cloud services, allowing the company to use only the capacity required at a particular moment<\/li>\n<li><strong>Infrastructure cost optimization<\/strong> ensured by the cloud provider\u2019s pay-as-you-go pricing model<\/li>\n<li><strong>Simplified support and maintenance<\/strong> through clear infrastructure management enabled by Microsoft Azure cloud components<\/li>\n<li><strong>Easier implementation of new features<\/strong> based on effective component integrations and smooth connectivity<\/li>\n<li><strong>Low migration risk<\/strong> ensured by the lift and shift approach, with minimal changes to the original configuration<\/li>\n<li><strong>System stability<\/strong> as a result of high cloud infrastructure performance guaranteed by Microsoft Azure cloud services<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Harnessing the Power of the Cloud: Data Warehouse Migration for a B2B Retailer <\/p>\n","protected":false},"author":15,"featured_media":84276,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[37,75,79],"class_list":["post-83803","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-case-study","tag-cloud-devops","tag-data-analytics","tag-retail"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.5 (Yoast SEO v26.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Warehouse Migration - Intellias<\/title>\n<meta name=\"description\" content=\"Improved insight quality as a result of implementation of an efficient Microsoft Azure-based data management infrastructure.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Harnessing the Power of the Cloud: Data Warehouse Migration for a B2B Retailer\" \/>\n<meta property=\"og:description\" content=\"Improved insight quality as a result of implementation of an efficient Microsoft Azure-based data management infrastructure.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/\" \/>\n<meta property=\"og:site_name\" content=\"Intellias\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Intellias.GlobalPage\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-06T13:20:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-01T08:32:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/d17ocfn2f5o4rl.cloudfront.net\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"770\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dmytro\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@intellias\" \/>\n<meta name=\"twitter:site\" content=\"@intellias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dmytro\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/\"},\"author\":{\"name\":\"Dmytro\",\"@id\":\"https:\/\/intellias.com\/#\/schema\/person\/340e93af638d45b994549b7b14544b8b\"},\"headline\":\"Harnessing the Power of the Cloud: Data Warehouse Migration for a B2B Retailer\",\"datePublished\":\"2024-12-06T13:20:23+00:00\",\"dateModified\":\"2025-04-01T08:32:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/\"},\"wordCount\":671,\"publisher\":{\"@id\":\"https:\/\/intellias.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png\",\"keywords\":[\"Cloud &amp; DevOps\",\"Data &amp; Analytics\",\"Retail\"],\"articleSection\":[\"Case study\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/\",\"url\":\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/\",\"name\":\"Data Warehouse Migration - Intellias\",\"isPartOf\":{\"@id\":\"https:\/\/intellias.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png\",\"datePublished\":\"2024-12-06T13:20:23+00:00\",\"dateModified\":\"2025-04-01T08:32:25+00:00\",\"description\":\"Improved insight quality as a result of implementation of an efficient Microsoft Azure-based data management infrastructure.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#primaryimage\",\"url\":\"https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png\",\"contentUrl\":\"https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png\",\"width\":770,\"height\":500},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/intellias.com\/#website\",\"url\":\"https:\/\/intellias.com\/\",\"name\":\"Intellias\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/intellias.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/intellias.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/intellias.com\/#organization\",\"name\":\"Intellias\",\"url\":\"https:\/\/intellias.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/intellias.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/intellias.com\/wp-content\/uploads\/2023\/07\/logo-intellias.svg\",\"contentUrl\":\"https:\/\/intellias.com\/wp-content\/uploads\/2023\/07\/logo-intellias.svg\",\"width\":300,\"height\":51,\"caption\":\"Intellias\"},\"image\":{\"@id\":\"https:\/\/intellias.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Intellias.GlobalPage\",\"https:\/\/x.com\/intellias\",\"https:\/\/www.linkedin.com\/company\/intellias\/\"],\"email\":\"info@intellias.com\",\"telephone\":\"+18574440442\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1001\",\"maxValue\":\"5000\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/intellias.com\/#\/schema\/person\/340e93af638d45b994549b7b14544b8b\",\"name\":\"Dmytro\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Warehouse Migration - Intellias","description":"Improved insight quality as a result of implementation of an efficient Microsoft Azure-based data management infrastructure.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/","og_locale":"en_US","og_type":"article","og_title":"Harnessing the Power of the Cloud: Data Warehouse Migration for a B2B Retailer","og_description":"Improved insight quality as a result of implementation of an efficient Microsoft Azure-based data management infrastructure.","og_url":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/","og_site_name":"Intellias","article_publisher":"https:\/\/www.facebook.com\/Intellias.GlobalPage","article_published_time":"2024-12-06T13:20:23+00:00","article_modified_time":"2025-04-01T08:32:25+00:00","og_image":[{"width":770,"height":500,"url":"https:\/\/d17ocfn2f5o4rl.cloudfront.net\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png","type":"image\/png"}],"author":"Dmytro","twitter_card":"summary_large_image","twitter_creator":"@intellias","twitter_site":"@intellias","twitter_misc":{"Written by":"Dmytro","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#article","isPartOf":{"@id":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/"},"author":{"name":"Dmytro","@id":"https:\/\/intellias.com\/#\/schema\/person\/340e93af638d45b994549b7b14544b8b"},"headline":"Harnessing the Power of the Cloud: Data Warehouse Migration for a B2B Retailer","datePublished":"2024-12-06T13:20:23+00:00","dateModified":"2025-04-01T08:32:25+00:00","mainEntityOfPage":{"@id":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/"},"wordCount":671,"publisher":{"@id":"https:\/\/intellias.com\/#organization"},"image":{"@id":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#primaryimage"},"thumbnailUrl":"https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png","keywords":["Cloud &amp; DevOps","Data &amp; Analytics","Retail"],"articleSection":["Case study"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/","url":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/","name":"Data Warehouse Migration - Intellias","isPartOf":{"@id":"https:\/\/intellias.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#primaryimage"},"image":{"@id":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#primaryimage"},"thumbnailUrl":"https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png","datePublished":"2024-12-06T13:20:23+00:00","dateModified":"2025-04-01T08:32:25+00:00","description":"Improved insight quality as a result of implementation of an efficient Microsoft Azure-based data management infrastructure.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/intellias.com\/cloud-data-warehouse-migration-b2b-retailer\/#primaryimage","url":"https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png","contentUrl":"https:\/\/intellias.com\/wp-content\/uploads\/2024\/12\/header-Harnessing-the-Power-of-the-Cloud-1.png","width":770,"height":500},{"@type":"WebSite","@id":"https:\/\/intellias.com\/#website","url":"https:\/\/intellias.com\/","name":"Intellias","description":"","publisher":{"@id":"https:\/\/intellias.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/intellias.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/intellias.com\/#organization","name":"Intellias","url":"https:\/\/intellias.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/intellias.com\/#\/schema\/logo\/image\/","url":"https:\/\/intellias.com\/wp-content\/uploads\/2023\/07\/logo-intellias.svg","contentUrl":"https:\/\/intellias.com\/wp-content\/uploads\/2023\/07\/logo-intellias.svg","width":300,"height":51,"caption":"Intellias"},"image":{"@id":"https:\/\/intellias.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Intellias.GlobalPage","https:\/\/x.com\/intellias","https:\/\/www.linkedin.com\/company\/intellias\/"],"email":"info@intellias.com","telephone":"+18574440442","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1001","maxValue":"5000"}},{"@type":"Person","@id":"https:\/\/intellias.com\/#\/schema\/person\/340e93af638d45b994549b7b14544b8b","name":"Dmytro"}]}},"_links":{"self":[{"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/posts\/83803","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/comments?post=83803"}],"version-history":[{"count":6,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/posts\/83803\/revisions"}],"predecessor-version":[{"id":87779,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/posts\/83803\/revisions\/87779"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/media\/84276"}],"wp:attachment":[{"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/media?parent=83803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/categories?post=83803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/tags?post=83803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}