Intermediate Data Modeling in Power BI

MellanliggandeFärdighetsnivå

Uppdaterad 2025-06

Master data modeling in Power BI.

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Kursbeskrivning

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.

Förkunskapskrav

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

Starta Kapitel

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

Starta Kapitel

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

Starta Kapitel

Identifying Performance Problems

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

Identifying performance problems

50 XP

Optimizing performance

100 XP

Performance tips in Power BI

50 XP

Data types and calculations

100 XP

Calculated versus computed columns

100 XP

An alternative to bi-directional filtering

100 XP

Congratulations!

50 XP

Starta Kapitel

Intermediate Data Modeling in Power BI

Kursen
är

Få ett prestationsutlåtande

Lägg till denna inloggningsuppgifter i din LinkedIn-profil, ditt CV eller ditt CV
Dela det på sociala medier och i ditt prestationssamtalRegistrera Dig Nu

Gå med över 19 miljoner elever och börja Intermediate Data Modeling in Power BI idag!

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Intermediate Data Modeling in Power BI

Skapa ditt gratiskonto

Utbilda 2 eller fler personer?

Kursbeskrivning

Extend your Data Modelling Skills

Use DAX to Customize your Data Model

Förkunskapskrav

Date Dimensions and Relationships

Granularity, Measures, and Hierarchies

Advanced Data Modeling

Identifying Performance Problems

Få ett prestationsutlåtande

Gå med över 19 miljoner elever och börja Intermediate Data Modeling in Power BI idag!

Skapa ditt gratiskonto

Utveckla dina datakunskaper med DataCamp för mobilen

Kursbeskrivning

Extend your Data Modelling Skills

Use DAX to Customize your Data Model

Få ett prestationsutlåtande

Gå med över .css-nklxlk{color:var(--wf-brand--main, #03EF62);} 19 miljoner elever och börja Intermediate Data Modeling in Power BI idag!

Skapa ditt gratiskonto

Utveckla dina datakunskaper med DataCamp för mobilen

Gå med över 19 miljoner elever och börja Intermediate Data Modeling in Power BI idag!