Data Warehouse Modeling and Design
Data Warehouse Modeling and Design
Course Introduction
Data Warehouse is a critical component in any organization today, as the center and a core component of the business KPIs (Key performance indicators), which decision-making process totally depends on the insights and quality of data available in it.
Learning Data Warehouse concepts and modeling techniques is a crucial skill for any data engineer or data scientist, and to learn how to interpret the information inside Data Warehouse tables.
What you will learn
- Understand the use of a Data Warehouse
- Understand the core concepts of a Data Warehouse
- Understand the Dimensional Modeling
- Understand different types of Facts
- Understand different types of Dimensions
- Understand different types of measures
Who should take this course
Any data science, data engineer, data analyst, and anyone interested to learn about the Data Warehouse and its components.
Introduction
1
Why do we need Data Warehouse – Part 1
2
Why do we need Data Warehouse – Part 2
3
Data Warehouse Charactersitics
4
Data Warehouse – Conclusion
5
Data Warehouse Introduction Quiz
Dimensional Modeling Introduction
1
Dimensional Modeling Introduction
2
ER vs Dimensional
Dimension Keys
1
Natural Key
2
Surrogate Keys
3
Durable Keys
Dimensions
1
Conformed Dimension
2
Role-Playing Dimension
3
Junk Dimension
4
SCD- Type 0 – Type 1
5
SCD Type 0 – Conclusion
6
SCD Type 1 – Conclusion and Use Cases
7
SCD Type 2
8
SCD Type 2 – Conclusion and Use Cases
9
SCD Type 3
10
SCD Type 3 – Conclusion and Use Cases
11
SCD Type 6
12
Dimensions Best Practice Tip
13
Dimensions Knowledge Check
Facts
1
Facts Introduction – Grain
2
Transactional Fact
3
Transactional Fact Table – Conclusion and Use Cases
4
Periodic Snapshot Facts
5
Periodic Snapshot Facts – Conclusion and Use Cases
6
Accumulating Facts
7
Accumulating Facts – Conclusion and Use Cases
8
Factless Fact
9
Factless Fact Table – Conclusion and Use Cases
10
Handle Null Value
11
Different Fact Types in the same Model
12
Facts Knowledge Check
Measures
1
Additive
2
Non-Additive
3
Semi-Additive
4
Measures Knowledge Check
Any data science, data engineer, data analyst, and anyone interested to learn about the Data Warehouse and its components.
- Understand the use of a Data Warehouse
- Understand the core concepts of a Data Warehouse
- Understand the Dimensional Modeling
- Understand different types of Facts
- Understand different types of Dimensions
- Understand different types of measures
You have to finish the course To review it
Related Courses
Arabic
Pandas is one of the most important libraries in data engineering and data science with its powerful features and capabilities, you can see that al...
Add to Wishlist
Free
Arabic
Course Objective Applying ETL Concepts is one of the major skills for any data integration developer or any data engineer in general, and also it i...
Add to Wishlist
Free