Data warehouse overview—part 2

  • What are the three data warehouse models?

    From the architecture point of view, there are three data warehouse models: the enterprise warehouse, the data mart, and the virtual warehouse..

  • What are the three main types of data warehouses?

    Once in the data warehouse, the data is ingested, transformed, processed, and made accessible for use in decision-making.
    The three main types of data warehouses are enterprise data warehouse (EDW), operational data store (ODS), and data mart..

  • What do you mean by data warehouse?

    A data warehouse is an enterprise system used for the analysis and reporting of structured and semi-structured data from multiple sources, such as point-of-sale transactions, marketing automation, customer relationship management, and more..

  • What is the overview of data warehousing?

    A data warehouse is a centralized storage system that allows for the storing, analyzing, and interpreting of data in order to facilitate better decision-making.
    Transactional systems, relational databases, and other sources provide data into data warehouses on a regular basis.Aug 10, 2023.

  • What is the purpose of the data warehouse?

    The primary purpose of a data warehouse is to provide a central repository of information that can be quickly analyzed and queried to generate relevant insights.
    The specific types of insights generated from a data warehouse can vary..

This problem has been solved! You'll get a detailed solution from a subject matter expert that helps you learn core concepts.

Introduction

There are a lot of things to consider when modelling a cloud data warehouse: cost, performance, understandability, warehouse build time

Combining Data from Different Sources

A common request is making business-wide analysis from multiple data sources with different column structures and definitions

Kimball

One of the most common solutions to the mentioned problems is following Ralph Kimball’s ideas with some alteration

Wide Tables Or One Big Table

Is Kimball’s model still valid? Going back to Dave's talk from Coalesce 2020

Conclusion

The topic of warehouse modelling is a very deep one and lots of great engineers do not make bold statements about it for this reason

Categories

Data warehouse overview—part 1
Data warehouse overview and concepts
Data warehouse overview ppt
Data storage over the years
Data storage overview
Data storage past present
Data warehousing person
Data warehouse performance
Data warehouse performance tuning
Data warehouse performance metrics
Data warehouse persistent staging
Data warehouse performance testing
Data warehouse personas
Data warehouse periodic snapshot fact table
Data warehouse persistent staging area
Data warehouse performance indicators
Data warehouse personal
Data storage per user salesforce
Data storage per object salesforce
Intune data warehouse permissions