Skip to main content

Home Power BIData Modeling in Power BI

Data Modeling in Power BI

Learn the key concepts of data modeling on Power BI.

Comece O Curso Gratuitamente

3 Horas9 Videos26 Exercicios

37.621 AprendizesDeclaração de Realização

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.

Treinar 2 ou mais pessoas?Experimente o DataCamp For Business

Loved by learners at thousands of companies

Descrição do Curso

Foundations of Data Modelling

Proper data modeling is the foundation of data analysis and creating reports in Power BI. This course lets you explore a toolbox of data cleaning, shaping, and loading techniques, which you can apply to your data.

Diving into Power Query

You'll get to know how to choose between Power Query and Power BI, and discover the foundations of data modeling by going into star and snowflake schemas. You'll apply all of this to real-world datasets issued by the United States Census Bureau.

Para Empresas

Treinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

Nas seguintes faixas

Certificação disponível

Analista de dados no Power BI

Ir para a trilha

Fundamentos do Power BI

Ir para a trilha

1
Defining Tables
Grátis
Proper data analysis relies on proper data modeling. This first chapter covers the basic concepts and teaches you how to set up and load data from multiple sources.
Reproduzir Capítulo Agora
Data modeling and table properties
50 xp
Power Query vs. Power BI
50 xp
Load and transform data
50 xp
Loading a CSV
100 xp
Rounding, replacement, and sorting
100 xp
Data categorization and visibility
100 xp
Working with string columns
100 xp
2
Shaping Tables
In this chapter, we continue comparing Power Query and Power BI practices. Later, you will exercise combining tables and column extraction on Power BI.
Reproduzir Capítulo Agora
Shaping tables
50 xp
Power Query vs. Power BI again
100 xp
Merging and appending queries
50 xp
Breaking a file into multiple tables
100 xp
Appending files
100 xp
Column extraction
100 xp
3
Dimensional Modeling
In this chapter, you'll learn more about one of the most popular approaches to data modeling. You'll get familiar with the basic building blocks of the dimensional model; facts, dimensions, and star schemas.
Reproduzir Capítulo Agora
Dimensional modeling
50 xp
Facts vs. dimensions
100 xp
Creating a star schema
50 xp
Splitting data into facts and dimensions
100 xp
Load a new dimension
100 xp
Create another dimension
100 xp
4
Star and Snowflake schemas
In this final chapter, you'll continue with an extension of the star schema: the snowflake schema. Lastly, you will have your first practice with performance analyzer in Power BI.
Reproduzir Capítulo Agora
Star and snowflake schemas
50 xp
Snowflake vs. star schema
50 xp
Evaluating performance
50 xp
Star schemas
100 xp
Snowflake schemas
100 xp
The performance analyzer
100 xp
Congratulations!
50 xp

Para Empresas

Treinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

Nas seguintes faixas

Certificação disponível

Analista de dados no Power BI

Ir para a trilha

Fundamentos do Power BI

Ir para a trilha

Conjuntos De Dados

DataCamp vs. Local Experience Exercises and Datasets

Colaboradores

Carl Rosseel

Lis Sulmont

Kevin Feasel

Nina Spreitzer

Pre Requisitos

Introduction to Power BI

Data Scientist at DataCamp

Maarten Van den Broeck

Senior Content Developer at DataCamp

O que os outros alunos têm a dizer?

Cadastre-se mais 13 milhões de alunos e comece Data Modeling in Power BI Hoje!

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.