Dimensional Modeling Design Patterns: Beyond Basics
Duration: 60 minutes
Track: BI Platform Architecture, Development & Administration
Dimensional modeling is arguably one of the most important
fundamentals of business intelligence. It is still relevant even as
new technologies like PowerPivot and SSAS Tabular Models are becoming
more popular. Correctly modeling your organization's data not only
protects the most important asset your company has but ensures that
your data mart or data warehouse will be responsive and capable of
accommodating emerging requirements.
This session provides a deeper dive into
the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.