Data warehouse schema design - dimensional modeling and star schema
Snir David
Posted on August 25, 2020
Original post for Data warehouse schema design - dimensional modeling and star schema in my blog
Introduction to data warehouse schema design: In this talk, I walk through the basics of dimensional design using the kimball group approach.
Amongst other things, I cover:
- OLAP systems vs OLTP systems
- Third normal form of operational DB
- What is a dimension
- What is a fact
- Star schema
- Dimension grain
- Surrogate keys
- Slowly changing dimensions
💖 💪 🙅 🚩
Snir David
Posted on August 25, 2020
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.
Related