- Course
- Data
Dimensional Data Modeling for Analytics
Dimensional models make analytics fast and intuitive. This course will teach you to design analytical data models that turn transactional data into insight-ready structures.
What you'll learn
Analytics teams often struggle to query normalized operational databases efficiently. In this course, Dimensional Data Modeling for Analytics, you’ll gain the ability to design analytical models that make data exploration easier and faster. First, you’ll explore the core concepts and structure of dimensional modeling. Next, you’ll discover how to design fact and dimension tables that bring analytical context to transactional data. Finally, you’ll learn to handle complex analytical scenarios, including slowly changing dimensions and conformed dimensions. When you’re finished with this course, you’ll have the skills and knowledge of dimensional modeling needed to create scalable, analytical-ready data models for reporting and BI.
Table of contents
About the author
Warner is a SQL Server Certified Master, MVP, and Principal Consultant at Pythian. He manages clients in many industries and leads a talented team that maintains and innovates with their data solutions. When he's not working in Ottawa, Ontario, he can be found in his home country of Costa Rica.