Data Modeling in Power BI

Offered byDataCamp

Data Modeling in Power BI
at
DataCamp
Overview

Learn the key concepts of data modeling on Power BI

Duration	3 hours
Total fee	Free
Mode of learning	Online
Schedule type	Self paced
Official Website	Explore Free Course
Credential	Certificate

Data Modeling in Power BI
at
DataCamp
Highlights

Learn from 9 Videos and 26 Exercises

Data Modeling in Power BI
at
DataCamp
Course details

Skills you will learn

Data Modeling

More about this course

This course lets you explore a toolbox of data cleaning, shaping, and loading techniques, which you can apply to your data
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

Data Modeling in Power BI
at
DataCamp
Curriculum

Defining Tables

Data modeling and table properties

Power Query vs. Power BI

Load and transform data

Loading a CSV

Rounding, replacement, and sorting

Data categorization and visibility

Working with string columns

Shaping Tables

Shaping tables

Power Query vs. Power BI again

Merging and appending queries

Breaking a file into multiple tables

Appending files

Column extraction

Dimensional Modeling

Dimensional modeling

Facts vs. dimensions

Creating a star schema

Splitting data into facts and dimensions

Load a new dimension

Create another dimension

Star and Snowflake schemas

Star and snowflake schemas

Snowflake vs. star schema

Evaluating performance

Star schemas

Snowflake schemas

The performance analyzer

Congratulations!

Data Modeling in Power BI
at
DataCamp
Faculty details

Sara Billen

Sara is a graduate of a master's degree in Business Engineering and Marketing Analysis. Prior to working at DataCamp she worked as a Data Science consultant for a Belgian IT company.

Maarten Van den Broeck

Maarten is an aquatic ecologist and teacher by training and a data scientist by profession. He is also a certified Power BI and Tableau data analyst. After his career as a PhD researcher at KU Leuven, he wished that he had discovered DataCamp sooner.