Data Modeling in Power BI

Instructor: Microsoft

Beginner Level • 4 hours to complete • Flexible Schedule

What You'll Learn

  • ✓How to form a model using a Star Schema.
  • ✓How to write calculations DAX to create elements and analysis in Power BI.
  • ✓How to optimize performance in a Power BI model.

Skills You'll Gain

Data Analysis Expressions (DAX)
Data Transformation
Data Modeling
Time Series Analysis and Forecasting
Star Schema
Performance Tuning
Power BI
Database Design

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate from Microsoft

There are 4 modules in this course

This module introduces data modeling and the schemas used to create them.

This module introduces the learner to the DAX (Data Analysis Expressions) language. The module explores the syntax of DAX using multiple business use cases. The module also integrates DAX with previous lessons on database tables and their use and introduces the concept of time intelligence.

This module explores the optimization process and examines the tools and methods to achieve this in Power BI, including using performance analyzer and DirectQuery features. This module also dives deeper into DAX and its use in the real world.

In this module, you will be assessed on the key skills covered in the course. This module summarizes the course and reflects on the primary learning objectives. The module also contains the project for the course, which encapsulates the learning into a practical whole.