Intermediate Data Modeling in Power BI
Offered By: DataCamp
Course Description
Overview
Master data modeling in Power BI.
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.
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.
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.
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.
Syllabus
- Date Dimensions and Relationships
- In the first chapter, you'll extend your data modeling skills by adding more tables and relationships.
- Granularity, Measures, and Hierarchies
- You'll learn how to use hierarchies and explore several granularity levels of your data.
- 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.
- Identifying Performance Problems
- In this final chapter, you'll study performance optimization tips and tricks in Power BI.
Taught by
Maarten Van den Broeck and Sara Billen
Related Courses
Microsoft Power BI: Advanced Data Analysis and VisualisationCloudswyft via FutureLearn Advanced Data Modeling
Meta via Coursera Advanced Monitoring and Optimizing with DynamoDB (Simplified Chinese)
Amazon Web Services via AWS Skill Builder Advanced Monitoring and Optimizing with DynamoDB (Japanese)
Amazon Web Services via AWS Skill Builder Advanced Monitoring and Optimizing with DynamoDB (German)
Amazon Web Services via AWS Skill Builder