Mastering DAX and Data Models in Power BI Desktop

Name: Mastering DAX and Data Models in Power BI Desktop
Rating: 4.3 (42 reviews)

Build your foundation for Data Modelling, Relationhsip, DAX language in Power BI

Created byAbhay Gadiya

Last updated 5/2020

English

What you'll learn

Building foundation about Data Models, Relationships and DAX formulas in Power BI
Various foundational concepts of Data Models and relationship not covered in any other course
Normalized and de-normalized datasets – advantages and difference
Three fundamentals rules for normalizing your dataset for better performance
Star Schema, Snowflakes Schema, Top Down schema for Data Models
One to Many, Many to One, Many to One relationship
Simple and easy to understand approach explaining complex concepts of Power BI DAX
DAX Studio, DAX Variables, Time intelligence and other complex DAX formulas

Course content

6 sections • 57 lectures • 5h 45m total length

Introduction to Power BI and Its components3:22
Power BI desktop - Download & Install. Learn about desktop layout4:46
Loading of data in Power BI desktop using Query Editor and separate course4:13
Headsup about the course material0:38

Data Modelling mindset - Think in multiple tables5:16
This video explains importance of data modelling in Power BI Desktop. Before you start working on any data using Power BI desktop you must create appropriate data models so that you can avoid lot of data structure problems later on.
Keys in Tables - Primary Key and Foreign Key5:03
This videos explains what are primary keys, foreign keys in any tables. How to identify them and why these are important for creating relationships inside Power BI Desktop.
Introduction to Normalisation of Datasets5:03
People from Excel background are used to single table for analysis however when you are using Power BI Desktop it is recommended to have normalised dataset in multiple tables. This video explains how to perform normalisation on your table.
Rule # 1 : First Normal Form - single value and not repeating groups5:16
This video explain first rule of normalisation with regards to key only one information inside a single column. It also explains how to keep records in table so as to comply with this first rule of normalisation.
Rule # 2 : Second Normal Form - composite primary key6:19
This video explain second rule of normalising the datasets.
Rule # 3 : Third Normal Form - dependency between non-key fields5:37
How to normalize the a dummy dataset by applying normalization rules13:13
Recap - Three Normalisation rules3:01
Table types - Data / Fact table and Lookup / Dimension Table5:58
Relationship Cardinality an introduction1:50
One to Many relationship2:48
Many to Many relationship2:22
One to One relationship1:45
Relationship cardinality recap1:46
Relationship in Power BI - Active / In-active, one / both way filter propagation14:50
Diagram view : Top Down, Star Schema, Snow Flakes - managing table presentation5:49

Tables related options - Table view, Rename, Hide / Delete5:47
Columns related - Width, Rename, Sort / Sort by, Hide / Delete, Filters, Groups17:38
Data Types valid inside Power BI Desktop4:27
Formatting data inside a column5:38
How to categorize data inside Power BI Desktop2:49
How to apply default summarization to a column inside Power BI Desktop3:42
How to mark a table as Date Table inside Power BI Desktop and why is it required2:46
How to import Power Pivot data model from Excel into Power BI3:30

Introduction to CALCULATE function in DAX4:56
CALCULATE syntax explanation6:41
Examples using CALCULATE function6:17
FILTER function introduction to syntax, how it works and when to use it.7:03
Using FILTER function in filter argument of CALCULATE6:37
Context Transition using CALCULATE and FILTER function7:08
ALL, ALLEXCEPT and ALLSELECTED function inside DAX to remove filter context4:25
ALL and ALLEXCEPT function case study - single table11:30
ALL and ALLEXCEPT function case study - multiple tables3:31
ALLSELECTED - remove initial filter context and keep filter context selectively7:08
CALCULATE, FILTER, ALL - differences and similarities while using these function7:54
Bonus0:06

Requirements

Person should know Power BI Query editor – how to import and transform data inside Power BI
This course is next step after completing my Power BI Query Editor course
Person is keen to learn more concepts about Power BI DAX
Ensure that you have latest version of Power BI Desktop installed

Description

**** Life time access to course materials and practice activities. Money back guarantee ****

If you are planning to get started with Power BI and your data analytics journey it is very important that you follow a proper path to learn various concepts about data analytics.

Gathering the data- Perform your Extract > Transform > Load (ETL) activities.
Model your data - Normalizing your data is one of the critical step
Relationship between data tables - To understand the flow of information
DAX - Perform your data crunching and analysis
Visual analytics - Not just numbers and but pictorial presentation

I have covered ETL activities in my course titled - Power Bi Query Editor - Master Data Transformation. It have more than 6+ hours video content explaining all the concepts related to Power Query and M Language with the help of real world datasets.

Once you have completed above course you must move on to next step for Data Modelling, Relationships and DAX.

Currently various courses at Udemy will explain only DAX and will cover data modelling & relationship only briefly. However, structuring data properly is essential to achieving good performance in your reports and to maintaining a low level of complexity in your DAX formulas.

The easiest way to create a data model in Power BI is to gather the data “as is” from a data source, define relationships, and then start designing reports. But this approach raises several issues when you have too many tables, or different levels of granularity. This course will explain in detail how you can create appropriate data models by applying fundamental rules of normalizing your data.

For person starting with DAX it is little challenging as he may need to visualize in my mind what result he would get from the DAX formula he is writing. This can be confusing, so I have created this course which you will give simple and easy to understand explanation about using various DAX formulas. This course will guide you to deep understanding about various concepts of DAX like filter context, row context, evaluation context, Table or scalar DAX functions, Iterator DAX functions, Calculated Measures, Calculated Columns, etc.

Who this course is for:

Students who have completed my Power BI Query editor course and want to learn now more about DAX
If you want to prepare for Power BI certifications from Microsoft
For all those who want to automate management reporting and wow their stakeholders.
Perform your data analysis quickly using DAX

Mastering DAX and Data Models in Power BI Desktop

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 13min

Data Modelling16 lectures • 1hr 26min

Preparing your data for Dashboards8 lectures • 46min

DAX fundamentals - Power of Power BI desktop8 lectures • 1hr 6min

Basic DAX function examples9 lectures • 1hr

CALCULATE - boss of DAX functions and functions supporting it.12 lectures • 1hr 13min

Requirements

Description

Who this course is for: