In the first chapter, you'll extend your data modeling skills by adding more tables and relationships.

Date dimensions and relationships

Cardinality

Date dimensions and relationships in Power BI

Create a year dimension

Extend the year dimension

Composite key relationships

Date Dimensions and Relationships

You'll learn how to use hierarchies and explore several granularity levels of your data.

Granularity, measures, and hierarchies

Hidden hierarchies

Hierarchies and measures in Power BI

Build a hierarchy

Change the granularity of a query

Measures and quick measures

Granularity, Measures, and Hierarchies

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.

Working with relationships

Bi-directional relationships

Cross-filtering and role-playing Dimensions

Bi-directional cross-filtering

Role-playing dimensions

Advanced Data Modeling

In this final chapter, you'll study performance optimization tips and tricks in Power BI.

Identifying performance problems

Optimizing performance

Performance tips in Power BI

Data types and calculations

Calculated versus computed columns

An alternative to bi-directional filtering

Congratulations!

Identifying Performance Problems

DataCamp vs. Local Experience

Exercises and Datasets

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.

<h2>Extend your Data Modelling Skills</h2>
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.
<br><br> 
<h2>Use DAX to Customize your Data Model</h2>
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.


Data Modeling in Power BI

Intermediate Data Modeling in Power BI

Data Analyst in Power BI

Curriculum Manager at DataCamp

Let's practice!

https://s3.amazonaws.com/assets.datacamp.com/production/course_29081/subtitles/course_29081_a911893c92802cc0f9cd27773a4815f7.vtt

Advanced Data Modeling - Cross-filtering and role-playing Dimensions

Cross-filtering and role-playing Dimensions

Create Your Free Account