22-25 April 2026 
SQLBits 2018
Dimensional Modeling: Beyond the Basics
In this session, we will dive deeper into the art of dimensional modeling. We will identify the different types of fact tables and dimension tables and also review approaches to
creating rich hierarchies that simplify complex reporting.
In this session, we will dive deeper into the art of dimensional modeling.
We will identify the different types of fact tables and dimension tables and
discuss how and when to use each type. We will also review approaches to
creating rich hierarchies that simplify complex reporting. This session will
be very interactive--bring your toughest dimensional modeling quandaries!
We will identify the different types of fact tables and dimension tables and
discuss how and when to use each type. We will also review approaches to
creating rich hierarchies that simplify complex reporting. This session will
be very interactive--bring your toughest dimensional modeling quandaries!
Speakers
Jason Horner's previous sessions
Data Lake Design Patterns
Data lakes have been around for several years and there is still much hype and hyperbole surrounding their use. This session covers the basic design patterns and architectural principles.
Dimensional Modeling: Beyond the Basics
In this session, we will dive deeper into the art of dimensional modeling. We will identify the different types of fact tables and dimension tables and also review approaches to
creating rich hierarchies that simplify complex reporting.