Data Warehouse Modeling - Star Schema Design Fundamentals
Udemy
Course Summary
Learn about Data Modeling, Data Warehouse, and ETL concepts from scratch using a real life Microsoft based dataset.
-
+
Course Description
In this course, you will learn all the concepts, terminologies, and history related to data warehousing, data modeling, and especially star schema design. We will start off with the basics and talk about the ETL process and how it fits into big data picture. Then, we will dive deep into the star schema design and talk about the following concepts:
- ecosystem architecture
- data warehouse architecture
- front-end architecture
- dimensional modeling
- joining facts and dimensions
- the Kimball method
- object action model
- subject area mapping
- finding a grain
- identifying facts and dimensions
- and much more!Â
You will have the opportunity to work with a Microsoft based data set throughout this course so you can apply the knowledge directly to your work!Â
Here's everything you will get out of this course.
- You will learn the fundamentals of the popular star schema design to add this skill/technology to your resume
- You will work on a real life data set so you directly relate to your work
- You will receive a BONUS audio copy of this course so you can listen on the go at your own time
- You will receive a FREE copy of the Kimball's Data Warehouse Toolkit bookÂ
- You will receive access to monthly office hours hosted by the instructor so you can ask questions and stay engaged
- NO QUESTIONS ASKEDÂ 30-day money back guarantee
- ecosystem architecture