Opleiding: Dimensional Modeling
Implement Dimensional Models for Business Intelligence
The course Dimensional Modeling, based on Ralph Kimball's ideas and guidelines, provides you with the skills necessary to effectively apply dimensional modeling techniques for Business Intelligence solutions.
You learn to design dimension and fact tables and to track history in order to meet the reporting, analysis, flexibility and performance requirements of the Business Intelligence environment.
- Introduction to Data Warehousing & Data Platforms
- Principles of Dimensional Modeling
- Time, Product and Customer Dimensions
- Fact Tables
- Multiple Fact Tables and Aggregate Tables
- History Tracking (Slowly Changing Dimensions)
- Recursive Relationships
- Data Population, Data Quality and Tools
- Trends in Data Modeling & Data Platforms
