{"id":16498,"date":"2021-06-22T12:15:19","date_gmt":"2021-06-22T06:45:19","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=16498"},"modified":"2021-06-22T12:15:19","modified_gmt":"2021-06-22T06:45:19","slug":"introduction-to-modern-data-warehouse","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/","title":{"rendered":"Introduction To Modern Data Warehouse"},"content":{"rendered":"<p>\u26a1 A <em><strong>data warehous<\/strong><\/em>e gathers data from many different sources within an organization. This data is then used as the source for analysis, reporting, and online analytical processing (OLAP). The focus of a data warehouse is to provide answers to complex queries, unlike a traditional relational database, which is focused on transactional performance.<\/p>\n<p>\u26a1 Organizations collect data from a variety of data sources. It can be structured data like data in relational databases or it can be unstructured data like data available in CSV JSON and log files, data from NoSQL databases, or audio and video files.<\/p>\n<p>\u26a1 A modern data warehouse typically consists of 4 layers: Injection, Storage, Transform and Enrich and Model &amp; Serve<\/p>\n<p>For more information, check out this blog at <a href=\"https:\/\/k21academy.com\/microsoft-azure\/data-engineer\/introduction-to-modern-data-warehouse\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp20318_june21\" target=\"_blank\" rel=\"noopener noreferrer\"><em><strong>https:\/\/k21academy.com\/dp20318<\/strong><\/em><\/a> will get an overview of the Modern Data warehouse.<\/p>\n<p>If you are planning to become a Microsoft Azure Data Engineer then register for the FREE Class at <a href=\"https:\/\/k21academy.com\/free-class-azure-data-engineer-certification\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp20302_june21\" target=\"_blank\" rel=\"noopener noreferrer\"><em><strong>https:\/\/k21academy.com\/dp20302<\/strong><\/em><\/a><\/p>\n<p><a href=\"https:\/\/k21academy.com\/free-class-azure-data-engineer-certification\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp20302_june21\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-51077 size-full\" src=\"https:\/\/k21academy.com\/wp-content\/uploads\/2020\/10\/DP.200.201_CU.gif\" alt=\" [DP.200.201]_CU\" width=\"1338\" height=\"201\" \/><\/a><\/p>\n<p>FREE Telegram group <a href=\"https:\/\/t.me\/k21microsoftazure\"><em><strong>https:\/\/t.me\/k21microsoftazure<\/strong><\/em><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u26a1 A data warehouse gathers data from many different sources within an organization. This data is then used as the [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":16502,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[570,540],"tags":[],"class_list":["post-16498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-engineer","category-microsoft-azure"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Introduction to Modern Data Warehouse [DP-203] Data Engineer Associate<\/title>\n<meta name=\"description\" content=\"Modern data warehouse helps you to compile all of your data at any scale simply and suggests that you&#039;ll get insights through analytical dashboards for user\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introduction to Modern Data Warehouse [DP-203] Data Engineer Associate\" \/>\n<meta property=\"og:description\" content=\"Modern data warehouse helps you to compile all of your data at any scale simply and suggests that you&#039;ll get insights through analytical dashboards for user\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-22T06:45:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/06\/ModernData_BlogImage.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1125\" \/>\n\t<meta property=\"og:image:height\" content=\"629\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/\",\"name\":\"Introduction to Modern Data Warehouse [DP-203] Data Engineer Associate\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/06\/ModernData_BlogImage.png\",\"datePublished\":\"2021-06-22T06:45:19+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"description\":\"Modern data warehouse helps you to compile all of your data at any scale simply and suggests that you'll get insights through analytical dashboards for user\",\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/06\/ModernData_BlogImage.png\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/06\/ModernData_BlogImage.png\",\"width\":1125,\"height\":629,\"caption\":\"Modern Data Warehouse\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introduction To Modern Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introduction to Modern Data Warehouse [DP-203] Data Engineer Associate","description":"Modern data warehouse helps you to compile all of your data at any scale simply and suggests that you'll get insights through analytical dashboards for user","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:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Introduction to Modern Data Warehouse [DP-203] Data Engineer Associate","og_description":"Modern data warehouse helps you to compile all of your data at any scale simply and suggests that you'll get insights through analytical dashboards for user","og_url":"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/","article_published_time":"2021-06-22T06:45:19+00:00","og_image":[{"width":1125,"height":629,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/06\/ModernData_BlogImage.png","type":"image\/png"}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/","url":"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/","name":"Introduction to Modern Data Warehouse [DP-203] Data Engineer Associate","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/06\/ModernData_BlogImage.png","datePublished":"2021-06-22T06:45:19+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"description":"Modern data warehouse helps you to compile all of your data at any scale simply and suggests that you'll get insights through analytical dashboards for user","breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/06\/ModernData_BlogImage.png","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/06\/ModernData_BlogImage.png","width":1125,"height":629,"caption":"Modern Data Warehouse"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/06\/22\/introduction-to-modern-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Introduction To Modern Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/16498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=16498"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/16498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/16502"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=16498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=16498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=16498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}