After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
Extend your Data Modelling Skills
In this course, you’ll extend your knowledge about facts, dimensions, and their relationships. You learn about the cardinality of relationships and how you can use bi-directional cross-filtering in your model.Use DAX to Customize your Data Model
You’ll also explore the use of quick measures and hierarchies and write DAX to fully customize your data model. Finally, you’ll get introduced to Power BI reporting best practices to improve the performance of your reports.Feels like what you want to learn?
Start Course for FreeWhat you'll learn
- Identify the purpose of a date dimension table and evaluate methods for creating one in Power BI, including the DAX CALENDAR() function.
- Differentiate between natural keys, surrogate keys, and composite keys, and recognize the cardinality types — one-to-many, one-to-one, and many-to-many — supported by Power BI relationships.
- Distinguish between single-directional and bi-directional cross-filtering and assess the trade-offs of each in terms of data model integrity and report behavior.
- Recognize the concept of role-playing dimensions and identify how USERELATIONSHIP() enables multiple inactive relationships in a Power BI data model.
- Evaluate common causes of data model performance problems and assess optimization techniques including import mode selection, calculated columns versus measures, and relationship management.
Prerequisites
Curriculum
Course outline
1
Date Dimensions and Relationships
In the first chapter, you'll extend your data modeling skills by adding more tables and relationships.
2
Granularity, Measures, and Hierarchies
You'll learn how to use hierarchies and explore several granularity levels of your data.
3
Advanced Data Modeling
In this chapter, you'll look at some advanced data modeling techniques. You'll learn how and when to use bi-directional cross filters and role-playing dimensions.
4
Identifying Performance Problems
In this final chapter, you'll study performance optimization tips and tricks in Power BI.
Intermediate Data Modeling in Power BI
Course
Complete
