Intermediate Data Modeling in Power BI
Build Power BI data models with date dimensions, hierarchies, bi-directional cross-filtering and role-playing dimensions, then tune report performance.
A Power BI data model that grows beyond a few tables raises harder questions: how tables relate, which way filters should flow, and why reports slow down. Here you add date and year dimensions, set relationship cardinality and composite keys, build hierarchies and measures at different levels of granularity, and decide when bi-directional cross-filtering or role-playing dimensions fit. The closing lessons look at what makes a model slow and how data types and column choices change that.
What You Will Achieve
- Add a date or year dimension to a Power BI model and relate it to your fact tables with the right cardinality
- Build a hierarchy and create quick measures so a report can move between granularity levels
- Decide when bi-directional cross-filtering suits a model and when to set up role-playing dimensions instead
- Track down the causes of a slow report and fix them by revisiting data types and the choice between calculated and computed columns
Program Overview
Date Dimensions, Cardinality, and Key Relationships
Extends a model with more tables and relationships, starting with date and year dimensions and the cardinality that links them.
- Date dimensions and relationships in Power BI
- Creating and extending a year dimension
- Relationship cardinality
- Composite key relationships
Hierarchies, Measures, and Cross-Filtering
Works with hierarchies and granularity levels, then turns to relationship techniques for filtering in both directions and reusing a dimension.
- Hidden hierarchies and building a hierarchy
- Changing the granularity of a query
- Measures and quick measures
- Bi-directional cross-filtering and role-playing dimensions
Performance Optimization in Power BI
Gathers tips for spotting what slows a model and the calculation and filtering choices that help.
- Identifying performance problems
- Data types and calculations
- Calculated versus computed columns
- An alternative to bi-directional filtering
Certificate Awarded (Paid)
Complete the course to earn it.
Job Outlook
Business intelligence and reporting work in Power BI, where analysts maintain shared data models and keep dashboards responsive as tables and relationships multiply.
Good for: Power BI users who want their models to handle extra date tables, hierarchies and more complex relationships while keeping reports quick.
Keep in mind: The chapters center on relationships, hierarchies and performance tips; DAX appears mainly through measures and date tables rather than as a topic of its own.
Bottom line: A follow-on for Power BI modelers that pairs relationship design with the performance tuning a growing model needs.
Frequently Asked Questions
Which relationship cardinality types are discussed?
Cardinality has its own lesson, covering the one-to-many, one-to-one and many-to-many types that Power BI relationships support. A separate lesson builds relationships on composite keys.
When should a model use bi-directional cross-filtering?
The course weighs single-directional against bi-directional filtering in terms of model integrity and report behavior, shows where role-playing dimensions fit, and its final chapter presents an alternative to bi-directional filtering for performance reasons.
Is DAX used in this course?
Yes. You write DAX to customize the data model, including the CALENDAR() function for building a date table. Measures and quick measures also get a lesson of their own.


There are no reviews yet.