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
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
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
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 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.
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.
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
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.
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.
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.
You can take your Power BI data model to the next level if you leverage other components of the Power BI ecosystem. In this module, you will learn how these components can make your model even better.