Mô tả khóa học

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.

Điều kiện tiên quyết

Data Modeling in Power BI

Date Dimensions and Relationships

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

Date dimensions and relationships

50 XP

Cardinality

50 XP

Date dimensions and relationships in Power BI

50 XP

Create a year dimension

100 XP

Extend the year dimension

100 XP

Composite key relationships

100 XP

Bắt Đầu Chương

Granularity, Measures, and Hierarchies

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

Granularity, measures, and hierarchies

50 XP

Hidden hierarchies

100 XP

Hierarchies and measures in Power BI

50 XP

Build a hierarchy

100 XP

Change the granularity of a query

100 XP

Measures and quick measures

100 XP

Bắt Đầu Chương

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.

Working with relationships

50 XP

Bi-directional relationships

50 XP

Cross-filtering and role-playing Dimensions

50 XP

Bi-directional cross-filtering

100 XP

Role-playing dimensions

100 XP

Bắt Đầu Chương