Skip to main content

Home Power BIIntermediate Data Modeling in Power BI

Intermediate Data Modeling in Power BI

Master data modeling in Power BI.

Start Course for Free

3 Horas9 Videos24 Exercises

18.917 LearnersStatement of Accomplishment

Create Your Free Account

Google LinkedIn Facebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Training 2 or more people?Try DataCamp For Business

Loved by learners at thousands of companies

Descrição do Curso

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.

For Business

Training 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

Nas seguintes faixas

Certificação disponível

Analista de dados no Power BI

Ir para a trilha

1
Date Dimensions and Relationships
Livre
In the first chapter, you'll extend your data modeling skills by adding more tables and relationships.
Reproduzir Capítulo Agora
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
2
Granularity, Measures, and Hierarchies
You'll learn how to use hierarchies and explore several granularity levels of your data.
Reproduzir Capítulo Agora
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
3
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.
Reproduzir Capítulo Agora
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
4
Identifying Performance Problems
In this final chapter, you'll study performance optimization tips and tricks in Power BI.
Reproduzir Capítulo Agora
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

For Business

Training 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

Nas seguintes faixas

Certificação disponível

Analista de dados no Power BI

Ir para a trilha

Datasets

Exercises and Datasets DataCamp vs. Local Experience

Collaborators

Nina Spreitzer

Kevin Feasel

Carl Rosseel

Prerequisites

Data Modeling in Power BI

Data Scientist at DataCamp

Maarten Van den Broeck

Senior Content Developer at DataCamp

What do other learners have to say?

Join over 13 million learners and start Intermediate Data Modeling in Power BI today!

Create Your Free Account

Google LinkedIn Facebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.