Course

You'll learn how to:

Start this course today

Build hands-on data skills with interactive exercises and projects.

Sign up

About this course

YouTube video player for HxIn7iYC-3c

 

The “Model Data in Microsoft Power BI” course teaches you how to create intuitive and effective data models, using DAX language (data analytics expressions) to build various analytics solutions and improve performance with Microsoft Power BI Query data retrieval tasks.

Lessons in this course

Loading lessons....

Thousands of learners have changed their careers with Dataquest

97%

Learners who recommend
Dataquest for career advancement

4.9 stars

Dataquest rating on
G2Crowd and SwitchUp

$30k

Average salary boost
for learners who complete a path

What you’ll be able to achieve

By the end of the course, you‘ll be able to do the following:

  • Design a data model in Microsoft Power BI
  • Create a common date table
  • Configure table and column properties
  • Configure many-to-many relationships
  • Resolve circular relationships
  • Define data granularity
  • Design a star schema
  • Create calculated columns
  • Use DAX to build measures
  • Use the CALCULATE function to manipulate filters
  • Implement time intelligence by using DAX
  • Review the performance of measures, relationships, and visuals
  • Use variables to improve performance and troubleshooting
  • Optimize performance and reduce the size of the model
  • Improve performance by reducing cardinality levels
  • Optimize models with table-level storage
  • Create and manage aggregations
  • Review the performance of measures, relationships, and visuals
  • Use variables to improve performance and troubleshooting
  • Optimize performance, and reduce the size of the model

Who is this course for?

This course is part of the “Analyzing data with Microsoft Power BI” skill path, which we designed for anyone who wants to start or advance their career in the business intelligence world. It primarily focuses on professionals that will need to use Power BI to analyze structured data from various sources to create reports and dashboards.

You don’t need previous knowledge or experience with Microsoft Power BI — or any other programming language. You just need to know a little about spreadsheets and math. This course will teach you how to use Power BI with confidence, rapidly and without getting too technical — in a short time.

Join a community of 1M+ data learners on Dataquest

1

Sign up for a free account

Get access to hundreds of free lessons.

2

Choose a course or path

Start anywhere, from beginner topics to advanced concepts.

3

Learn with hands-on exercises

Learn with real data and build your experience.

Apply your skills

Create projects, build your portfolio, and build your career.

Sign up today

or