Mastering DAX and Data Models in Power BI Desktop
Created by Abhay Gadiya, Last Updated 31-Jan-2020, Language:English
Mastering DAX and Data Models in Power BI Desktop
Build your foundation for Data Modelling, Relationhsip, DAX language in Power BI
Created by Abhay Gadiya, Last Updated 31-Jan-2020, Language:English
What Will I Get ?
- Building foundation about Data Models, Relationships and DAX formulas in Power BI
- Various foundation 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
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
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
Course Content
-
Introduction to Data Modelling
17 Lectures 01:25:56-
Data Modelling mindset - think in multiple tables
Preview00:05:16 -
File Resources
-
Keys in Tables - Primary Key and Foreign Key
Preview00:05:03 -
Introduction to Normalisation of Datasets
Preview00:05:03 -
Rule # 1 : First Normal Form - single value and not repeating groups
00:05:16 -
Rule # 2 : Second Normal Form - composite primary key
00:06:19 -
Rule # 3 : Third Normal Form - dependency between non-key fields
00:05:37 -
How to normalize the a dummy dataset by applying normalization rules
00:13:13 -
Recap - Three Normalisation rules
00:03:01 -
Table types - Data / Fact table and Lookup / Dimension Table
00:05:58 -
Relationship Cardinality an introduction
00:01:50 -
One to Many relationship
00:02:48 -
Many to Many relationship
00:02:22 -
One to One relationship
00:01:45 -
Relationship cardinality recap
00:01:46 -
Relationship in Power BI - Active / In-active, one / both way filter propagation
00:14:50 -
Diagram view : Top Down, Star Schema, Snow Flakes - managing table presentation
00:05:49
-
-
Preparing your data for Dashboards
8 Lectures 00:46:17-
Tables related options - Table view, Rename, Hide / Delete
00:05:47 -
Columns related - Width, Rename, Sort / Sort by, Hide / Delete, Filters, Groups
00:17:38 -
Data Types valid inside Power BI Desktop
Preview00:04:27 -
Formatting data inside a column
00:05:38 -
How to categorize data inside Power BI Desktop
00:02:49 -
How to apply default summarization to a column inside Power BI Desktop
00:03:42 -
How to mark a table as Date Table inside Power BI Desktop and why is it required
00:02:46 -
How to import Power Pivot data model from Excel into Power BI
00:03:30
-
-
DAX fundamentals - Power of Power BI desktop
8 Lectures 01:06:28-
An introduction to DAX language fundamentals
00:03:02 -
Data Types, DAX Operators and DAX Syntax
00:09:44 -
DAX Functions list by categories - Table and Scalar values
00:06:41 -
Calculated in Power Bi
00:09:38 -
Calculated Measures in Power BI
00:13:59 -
Calculated Columns vs Calculated Measure
00:03:19 -
Filter Context and Row Context
00:11:36 -
Golden rules of Measures and other important things
00:08:29
-
-
Basic DAX function examples
9 Lectures 01:00:10-
Introduction to Common DAX functions
00:02:06 -
Related and Related Table function
00:06:48 -
Date and Time functions in DAX
00:08:13 -
Fundamental Math Operation using DAX functions and Operators
00:12:11 -
Rounding off numbers inside Power BI
00:06:11 -
Statistical DAX Functions
00:05:43 -
DISTINCTCOUNT function in DAX to count unique customers, etc.
00:07:13 -
Text functions in DAX
00:05:16 -
SWITCH function best alternative to nested IF functions
00:06:29
-
-
CALCULATE - boss of DAX functions and functions supporting it.
11 Lectures 01:13:10-
Introduction to CALCULATE function in DAX
00:04:56 -
CALCULATE syntax explanation
00:06:41 -
Examples using CALCULATE function
00:06:17 -
FILTER function introduction to syntax, how it works and when to use it.
00:07:03 -
Using FILTER function in filter argument of CALCULATE
00:06:37 -
Context Transition using CALCULATE and FILTER function
00:07:08 -
ALL, ALLEXCEPT and ALLSELECTED function inside DAX to remove filter context
00:04:25 -
ALL and ALLEXCEPT function case study - single table
00:11:30 -
ALL and ALLEXCEPT function case study - multiple tables
00:03:31 -
ALLSELECTED - remove initial filter context and keep filter context selectively
00:07:08 -
CALCULATE, FILTER, ALL - differences and similarities while using these function
00:07:54
-