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
MongoDB for DevelopersMongoDB University Data Wrangling with MongoDB
MongoDB via Udacity Intro to Point & Click App Development
Salesforce via Udacity SAP Business Suite powered by SAP HANA
SAP Learning Desarrollo de Aplicaciones Web: Conceptos Básicos
University of New Mexico via Coursera