{"id":28580,"date":"2021-01-20T15:31:05","date_gmt":"2021-01-20T23:31:05","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=28580"},"modified":"2021-01-20T15:31:11","modified_gmt":"2021-01-20T23:31:11","slug":"data-warehousing","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/data-warehousing\/","title":{"rendered":"How to Learn Data Warehousing"},"content":{"rendered":"\n

There are several methods to learn data warehousing, including self paced and classroom oriented. This article covers the books and training programs you need to independently learn data warehousing.<\/p>\n\n\n\n

What is Data Warehousing?<\/h2>\n\n\n\n

A data warehouse is a central location where consolidated information from various databases are held. It is maintained separately from a company\u2019s operational database, and often used as a backup so end users can access the data whenever they need.
<\/p>\n\n\n\n

The difference between operational data and a data warehouse is that operational data comes from multiple sources, and it is where the original, legacy, and real time data is held, before sending it out to the data warehouse. End users do not have access to operational data, only data sent to the warehouse.
<\/p>\n\n\n\n

Data warehouses are not products that companies can purchase. They are something that needs to be designed to meet company needs, and typically contain four properties:
<\/p>\n\n\n\n

  1. Subject-oriented.<\/strong> Data is categorized and held by subject instead of application.<\/li>
  2. Integrated.<\/strong> Data is collected from multiple sources (multiple databases) and held in a single place.<\/li>
  3. Time-variant.<\/strong> Data is stored as a series of snapshots of time.<\/li>
  4. Non-volatile.<\/strong> Data updates or deletions are not recommended. <\/li><\/ol>\n\n\n\n

    What is Data Warehousing Used for?<\/h3>\n\n\n\n

    Data Warehousing is one of the most important activities and subsets of business intelligence, which is the activity that contributes to the growth of any company, and essentially consists of four steps:
    <\/p>\n\n\n\n

    1. Planning<\/li>
    2. Data gathering <\/li>
    3. Data analysis <\/li>
    4. Business action<\/li><\/ol>\n\n\n\n

      Imagine a company having multiple data sources like Oracle, SQL, or SAP. The company would not initially be able to visualize the data collected since it is all separated. The data collected in the three different sources would have to be integrated and processed into a data warehouse first to be able to make visualizations.<\/p>\n\n\n\n

      Types of Data Warehousing<\/h3>\n\n\n\n

      There are three different types of data warehousing, data mart, operational, and enterprise. Below we will briefly go over these types and describe how they function.<\/p>\n\n\n\n

      Enterprise Data Warehousing<\/h4>\n\n\n\n

      This type of data warehouse encompasses everything we have discussed about them so far in the article, such as data classification by subjects and the bringing of data together from all sources of an enterprise or organization.
      <\/p>\n\n\n\n

      The goal of this type of data warehouse is to provide a complete overview of any object in the data model. This means that after all information is gathered by the enterprise data warehouse, people from within the organization can help identify patterns to focus on to help the business grow.<\/p>\n\n\n\n

      Operational Data Store Warehousing<\/h4>\n\n\n\n

      Operational data stores are sometimes subject oriented and time variant, helping in the storing of transactional data that comes from one or multiple production systems and loosely integrating it.
      <\/p>\n\n\n\n

      This form of data warehousing achieves integration by making use of the structures and contents found in enterprise data warehouses. This integration process involves checking business rules for integrity and redundancy.<\/p>\n\n\n\n

      Data Mart<\/h4>\n\n\n\n

      A data mart is a subset of a data warehouse. It is easy to implement and very cost effective when compared with a complete data warehouse because data is divided into parts and it can also be more easily controlled.
      <\/p>\n\n\n\n

      This type of data warehouse has three different types: dependent, independent, and hybrid. A dependent data mart requires the ability to fetch data from an operational data store. An independent data mart does not require this or any central data warehouse. And hybrid data marts are used when inputs from different sources are a part of a data warehouse.<\/p>\n\n\n\n

      How Long Does It Take to Learn Data Warehousing Techniques?<\/h3>\n\n\n\n

      Learning data warehousing can take as little as one week for those with a background in IT development, while those with little to no background in tech can take up to seven months to learn data warehousing.<\/p>\n\n\n\n

      The Best Data Warehousing Courses and Trainings<\/h2>\n\n\n\n

      The three data warehousing courses below require no prerequisites. The Coursera and Edureka options mentioned below are also flexible in terms of self paced learning. 
      <\/p>\n\n\n\n

      However, please be sure to visit your local college or university to inquire about in-person classes to see if they\u2019re affected by the COVID-19 pandemic.<\/p>\n\n\n\n

      Online Data Warehousing Courses<\/h3>\n\n\n\n

      Attending an online course is ideal at the moment due to the pandemic. Below are the recommended courses for you to take to learn data warehousing.<\/p>\n\n\n\n

      Data Warehousing for Business Intelligence Specialization<\/a><\/h4>\n\n\n\n