{"id":13348,"date":"2015-08-28T10:13:54","date_gmt":"2015-08-28T10:13:54","guid":{"rendered":"https:\/\/www.whizlabs.com\/?p=13348"},"modified":"2024-05-17T17:20:40","modified_gmt":"2024-05-17T11:50:40","slug":"data-warehouses","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/data-warehouses\/","title":{"rendered":"Data Warehouses"},"content":{"rendered":"

Data warehousing was a powerful field of study in the 1990s as the business requirements changed from transaction processing to analyzing the data. This post seeks to discuss the concepts behind Data warehousing along with the purpose of Data warehousing.<\/p>\n

From the days of data bases to Big Data analytics \u2013 we have come a long way. The very concept of storing data and querying it was refreshingly new in the 90\u2019s. Times changed and Data warehousing necessities and concepts pierced the IT landscape.<\/p>\n

What is a Data warehouse?<\/h3>\n

\u201cData\u201d that is stored on different systems like CRM, ERP, flat files and operational systems for a particular organization are in different formats and not much can be understood from this data.\u00a0 In order to get a grasp of this data and understand the meaning it conveys, the data is extracted from the different sources, cleaned and loaded (ETL) onto the data warehouse. Once the data is loaded onto the DW, it can be used for generating different reports for making informed business decisions.<\/p>\n

\"DataWarehouse\"<\/a><\/p>\n

This represents a broad overview of Data warehousing. Wikipedia further defines DW as \u201ccentral repositories of integrated data from one or more disparate sources. They store current and historical data and are used for creating analytical reports for knowledge workers throughout the enterprise\u201d (Data Warehouse)<\/p>\n

Reasons for creating Data warehouses:<\/h3>\n

Having seen a brief overview of Data warehouses, let us see the reason behind creating Data warehouses.<\/p>\n

    \n
  1. Improves Data quality :
    \nDatabase redesign, Database consolidation, manual entry to enter database values all cause poor data quality. When a data warehouse is created, data quality improves as the data from different sources is merged and standardized. Errors are also rectified during the transformation.<\/li>\n<\/ol>\n
      \n
    1. Provides historical data :
      \nData warehouses can be used to store huge amounts of data and hence can store data from an earlier point of time. This can be compared and contrasted to the current period of time. This comparing and contrasting will especially be useful if we would like to target goals relating to sales and marketing.<\/li>\n<\/ol>\n
        \n
      1. Improves integration :
        \nData warehouses improve integration as the data from different sources is merged and a clear picture emerges from all the data.<\/li>\n<\/ol>\n
          \n
        1. Better reporting :
          \nDW solutions enable better reporting as it is much more easy and flexible to generate reports all the by the click of a mouse.<\/li>\n<\/ol>\n
            \n
          1. Generates better ROI :
            \nOrganizations that implement DW solutions experience a better \u2018Return on investment\u2019 which is a huge motivating factor.\u00a0(NINE REASONS TO BUILD A DATA WAREHOUSE)\u00a0(Top Five Benefits of a Data Warehouse)<\/li>\n<\/ol>\n

            The above are some of the reasons for creating a Data warehouse.<\/p>\n

            Data warehousing in the age of Data Analytics:<\/h3>\n

            In this age of Data Analytics, Big Data and Hadoop it is interesting to think about the future of Data warehouses. Are they necessary? Will they be replaced?<\/p>\n

            Data warehouses are implemented as single relational databases while Hadoop\u2019s implementation span multiple machines and deal with massive amounts of data. Some organizations do try and move certain workloads of a DW (like ETL) to Hadoop but so far data warehouse migrations to Hadoop are not frequent. The future might see certain concepts move from DW to Hadoop but DWs may not be replaced entirely.<\/p>\n

            Bibliography\r\nData Warehouse<\/em>. (n.d.). Retrieved from Wikipedia.org: https:\/\/en.wikipedia.org\/wiki\/Data_warehouse\r\nNINE REASONS TO BUILD A DATA WAREHOUSE<\/em>. (n.d.). Retrieved from PASSIONNED GROUP: https:\/\/www.passionned.com\/nine-reasons-to-build-a-data-warehouse\/\r\nTop Five Benefits of a Data Warehouse<\/em>. (n.d.). Retrieved from TIBCO Spotfire: http:\/\/spotfire.tibco.com\/blog\/?p=7597<\/pre>\n","protected":false},"excerpt":{"rendered":"
            Data warehousing was a powerful field of study in the 1990s as the business requirements changed from transaction processing to analyzing the data. This post seeks to discuss the concepts behind Data warehousing along with the purpose of Data warehousing. From the days of data bases to Big Data analytics \u2013 we have come a long way. The very concept of storing data and querying it was refreshingly new in the 90\u2019s. Times changed and Data warehousing necessities and concepts pierced the IT landscape. What is a Data warehouse? \u201cData\u201d that is stored on different systems like CRM, ERP, flat […]<\/p>\n","protected":false},"author":220,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","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":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-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":"","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-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":"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":""},"mobile":{"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":""}},"footnotes":""},"categories":[13],"tags":[700],"class_list":["post-13348","post","type-post","status-publish","format-standard","hentry","category-java","tag-data-warehhouse"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"profile_24":false,"profile_48":false,"profile_96":false,"profile_150":false,"profile_300":false,"tptn_thumbnail":false,"web-stories-poster-portrait":false,"web-stories-publisher-logo":false,"web-stories-thumbnail":false},"uagb_author_info":{"display_name":"Aditi Malhotra","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/aditi\/"},"uagb_comment_info":7,"uagb_excerpt":"Data warehousing was a powerful field of study in the 1990s as the business requirements changed from transaction processing to analyzing the data. This post seeks to discuss the concepts behind Data warehousing along with the purpose of Data warehousing. From the days of data bases to Big Data analytics \u2013 we have come a…","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/13348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/220"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=13348"}],"version-history":[{"count":5,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/13348\/revisions"}],"predecessor-version":[{"id":96160,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/13348\/revisions\/96160"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=13348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=13348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=13348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}