{"id":5286,"date":"2020-12-30T12:07:24","date_gmt":"2020-12-30T06:37:24","guid":{"rendered":"https:\/\/ziniosedge.com\/?p=5286"},"modified":"2026-02-09T10:14:12","modified_gmt":"2026-02-09T10:14:12","slug":"azure-big-data","status":"publish","type":"case-studies","link":"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/","title":{"rendered":"Azure Big Data"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5286\" class=\"elementor elementor-5286\" data-elementor-post-type=\"case-studies\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d737344 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d737344\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4dc70ec\" data-id=\"4dc70ec\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c9ba28a elementor-widget elementor-widget-heading\" data-id=\"c9ba28a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">About the Customer<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-a6af5aa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a6af5aa\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-572e350\" data-id=\"572e350\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-16e65fc elementor-widget elementor-widget-image\" data-id=\"16e65fc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/ziniosedge.com\/wp-content\/uploads\/2020\/07\/engineering-01.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-c097930\" data-id=\"c097930\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5cb1b51 elementor-widget elementor-widget-text-editor\" data-id=\"5cb1b51\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Our Customer, an American Corporation, is a leading, integrated provider of construction, repair and engineering services for distribution and transmission powerlines and substations, with a growing portfolio of turnkey and renewable projects. In addition, they are a leader in storm restoration and offer gas distribution services. \u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a569b34 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a569b34\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-2a9753a\" data-id=\"2a9753a\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-383c116 elementor-widget elementor-widget-heading\" data-id=\"383c116\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Problem Statement<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-742896c\" data-id=\"742896c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d358353 elementor-widget elementor-widget-text-editor\" data-id=\"d358353\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Customer wanted to build Big Data solution on MS Azure.<\/li><li>The client wanted to move analytical data to Azure SQL DW from data residing in SQL Server and Oracle HCM.<\/li><li>They had Heterogeneous data coming from different applications which were to be integrated.<\/li><li>Integrating their systems was a challenge for deriving analytics.<\/li><li>End-users were making multiple copies of the same information for their ad-hoc reporting and dashboarding requirements which was a major concern for them.<\/li><li>Customer wanted to follow an approach where the data can be centralized and use it for an integrated model for their ad-hoc reporting\/analysis.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-413814a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"413814a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-ba5b6c7\" data-id=\"ba5b6c7\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-15002bd elementor-widget elementor-widget-heading\" data-id=\"15002bd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Solutions Delivered<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-4a5c63c\" data-id=\"4a5c63c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-56125c1 elementor-widget elementor-widget-text-editor\" data-id=\"56125c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Microsoft Azure platform was used to develop the architecture for handling requirements of data consolidation and reporting.<\/li><li>Leveraging the capabilities of Azure services and storage as part of this project. Data Lake Storage (gen2) was used for storage, analysis service was used for integration of data models and Azure SQL Server Data Warehouse database was used as the database.<\/li><li>Analytical services were built trough Power BI.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"featured_media":11430,"template":"","case_study_category":[264],"class_list":["post-5286","case-studies","type-case-studies","status-publish","has-post-thumbnail","hentry","case_study_category-cloud-and-devops"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Azure Platform Big Data - Zinios<\/title>\n<meta name=\"description\" content=\"Microsoft Azure platform was used to develop the architecture for handling requirements of data consolidation and reporting.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Azure Platform Big Data - Zinios\" \/>\n<meta property=\"og:description\" content=\"Microsoft Azure platform was used to develop the architecture for handling requirements of data consolidation and reporting.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Zinios\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-09T10:14:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2020\/12\/Azure-Big-Data1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/\",\"url\":\"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/\",\"name\":\"Microsoft Azure Platform Big Data - Zinios\",\"isPartOf\":{\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2020\/12\/Azure-Big-Data1.jpg\",\"datePublished\":\"2020-12-30T06:37:24+00:00\",\"dateModified\":\"2026-02-09T10:14:12+00:00\",\"description\":\"Microsoft Azure platform was used to develop the architecture for handling requirements of data consolidation and reporting.\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#primaryimage\",\"url\":\"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2020\/12\/Azure-Big-Data1.jpg\",\"contentUrl\":\"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2020\/12\/Azure-Big-Data1.jpg\",\"width\":1920,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dev.theblufig.com\/zinios\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure Big Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/#website\",\"url\":\"https:\/\/dev.theblufig.com\/zinios\/\",\"name\":\"Zinios\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dev.theblufig.com\/zinios\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/#organization\",\"name\":\"Zinios\",\"url\":\"https:\/\/dev.theblufig.com\/zinios\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2026\/02\/cropped-1v2.png\",\"contentUrl\":\"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2026\/02\/cropped-1v2.png\",\"width\":1200,\"height\":229,\"caption\":\"Zinios\"},\"image\":{\"@id\":\"https:\/\/dev.theblufig.com\/zinios\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Azure Platform Big Data - Zinios","description":"Microsoft Azure platform was used to develop the architecture for handling requirements of data consolidation and reporting.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Microsoft Azure Platform Big Data - Zinios","og_description":"Microsoft Azure platform was used to develop the architecture for handling requirements of data consolidation and reporting.","og_url":"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/","og_site_name":"Zinios","article_modified_time":"2026-02-09T10:14:12+00:00","og_image":[{"width":1920,"height":600,"url":"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2020\/12\/Azure-Big-Data1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/","url":"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/","name":"Microsoft Azure Platform Big Data - Zinios","isPartOf":{"@id":"https:\/\/dev.theblufig.com\/zinios\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#primaryimage"},"image":{"@id":"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#primaryimage"},"thumbnailUrl":"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2020\/12\/Azure-Big-Data1.jpg","datePublished":"2020-12-30T06:37:24+00:00","dateModified":"2026-02-09T10:14:12+00:00","description":"Microsoft Azure platform was used to develop the architecture for handling requirements of data consolidation and reporting.","breadcrumb":{"@id":"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#primaryimage","url":"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2020\/12\/Azure-Big-Data1.jpg","contentUrl":"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2020\/12\/Azure-Big-Data1.jpg","width":1920,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/dev.theblufig.com\/zinios\/case-studies\/azure-big-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.theblufig.com\/zinios\/"},{"@type":"ListItem","position":2,"name":"Azure Big Data"}]},{"@type":"WebSite","@id":"https:\/\/dev.theblufig.com\/zinios\/#website","url":"https:\/\/dev.theblufig.com\/zinios\/","name":"Zinios","description":"","publisher":{"@id":"https:\/\/dev.theblufig.com\/zinios\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.theblufig.com\/zinios\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dev.theblufig.com\/zinios\/#organization","name":"Zinios","url":"https:\/\/dev.theblufig.com\/zinios\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.theblufig.com\/zinios\/#\/schema\/logo\/image\/","url":"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2026\/02\/cropped-1v2.png","contentUrl":"https:\/\/dev.theblufig.com\/zinios\/wp-content\/uploads\/2026\/02\/cropped-1v2.png","width":1200,"height":229,"caption":"Zinios"},"image":{"@id":"https:\/\/dev.theblufig.com\/zinios\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/dev.theblufig.com\/zinios\/wp-json\/wp\/v2\/case-studies\/5286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.theblufig.com\/zinios\/wp-json\/wp\/v2\/case-studies"}],"about":[{"href":"https:\/\/dev.theblufig.com\/zinios\/wp-json\/wp\/v2\/types\/case-studies"}],"version-history":[{"count":0,"href":"https:\/\/dev.theblufig.com\/zinios\/wp-json\/wp\/v2\/case-studies\/5286\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.theblufig.com\/zinios\/wp-json\/wp\/v2\/media\/11430"}],"wp:attachment":[{"href":"https:\/\/dev.theblufig.com\/zinios\/wp-json\/wp\/v2\/media?parent=5286"}],"wp:term":[{"taxonomy":"case_study_category","embeddable":true,"href":"https:\/\/dev.theblufig.com\/zinios\/wp-json\/wp\/v2\/case_study_category?post=5286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}