Basics of Power BI Modeling

Academy Membership

This is for individual Membership: When you are registering for yourself. if you want to register for a group or team, check out the team membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 430+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial
  • EUR: €45.40
  • GBP: £38.82
  • NZD: $82.00
  • CAD: $66.33
  • AUD: $75.17

Academy Membership - for Teams

This is for team Membership: When you have a group of team members registering. if you want to register for one person, check out the individual membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 430+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial
  • EUR: €45.40
  • GBP: £38.82
  • NZD: $82.00
  • CAD: $66.33
  • AUD: $75.17
per member

Basics of Power BI Modeling

Getting started with building the Power BI solution is easy. However, building a solution that performs well requires good data modeling. Data Modeling is the exercise of re-shaping tables from their original format into the new format for reporting. Data Modeling is one of the most important principals of building any reporting solution, using Power BI, or any other tools and services. This data modeling course starts with the basics of relationships. The course then continues by explaining what the star-schema is, what is the fact table and dimension table. You will learn how to build these tables and how to build a data model using these best practices. The course is tailored for Power BI users, You will learn about Power BI relationships, and how to use Power Query and other components of Power BI to build the right data model. However, the concepts used in this course are product-agnostic and can be used in any other tool and service.

Length: 4 Hours and 1 Minute

$259.95
  • EUR: €240.87
  • GBP: £205.96
  • NZD: $435.00
  • CAD: $351.91
  • AUD: $398.79
Or log in to access your purchased courses

Getting started with building the Power BI solution is easy. However, building a solution that performs well requires good data modeling. Data Modeling is the exercise of re-shaping tables from their original format into the new format for reporting. Data Modeling is one of the most important principals of building any reporting solution, using Power BI, or any other tools and services.

This data modeling course starts with the basics of relationships. The course then continues by explaining what the star-schema is, what is the fact table and dimension table. You will learn how to build these tables and how to build a data model using these best practices.

The course is tailored for Power BI users, You will learn about Power BI relationships, and how to use Power Query and other components of Power BI to build the right data model. However, the concepts used in this course are product-agnostic and can be used in any other tools and services.

Modules

Module 1: Relationships in Power BI

The course starts with understanding the basics of a relationship in Power BI. In this module you will learn why relationships are needed, what are types of the relationships, and some advise about how to use the right relationship in your model

Lessons

Module 2: Dimensional modeling

In this module you will learn about the Star-Schema. You will learn what star-schema is needed, what are the components of it, what are fact and dimension tables. How to build a star-schema from an operational data store.

Lessons

Module 3: Star schema in action

Now that you learned about the principals of data modeling and star-schema, you are ready to learn some sample models. In this module, you will learn how to build a model for real-world scenarios with many examples.

Lessons

Module 4: What about calculations

This module talks about how does the calculation fits into the Power BI modeling. Should the calculation be part of the data preparation and built into the structure of the star schema, or should it be done in DAX calculation after the modeling. This module takes you through some examples to understand the concept using real-world examples.

Lessons