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
Connect to data sources, build data models with tables and relationships, and use DAX measures to create interactive Power BI Desktop visuals and reports.
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
Explore third normal form by ensuring non-key fields do not depend on each other, remove redundancy, and use a separate lookup table with one-to-many relationships for integrity and performance.
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
Explore diagram view to understand top-down, star, and snowflake schemas and how to arrange tables and relationships for clear data flow in Power BI.

Tables related options - Table view, Rename, Hide / Delete5:47
Columns related - Width, Rename, Sort / Sort by, Hide / Delete, Filters, Groups17:38
Explore how to manage columns in Power BI Desktop: adjust width, rename, delete or hide, and sort by, apply filters, and group to streamline dashboard data.
Data Types valid inside Power BI Desktop4:27
Explore how Power BI Desktop assigns and changes column data types, including decimal, whole, date/time, text, and binary data, ensuring a single type per column.
Formatting data inside a column5:38
How to categorize data inside Power BI Desktop2:49
Categorize data in Power BI Desktop to enable maps and hyperlinks, using geographical data categories like country or region on relevant columns. The global icon signals geographic data.
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
Discover how to mark a calendar table as a date table in Power BI Desktop, enabling time intelligence with a unique date column in your data model.
How to import Power Pivot data model from Excel into Power BI3:30
Import your Excel power pivot data models into power bi desktop to recreate tables, relationships, and measures, saving time on setup and enabling instant visualizations.

An introduction to DAX language fundamentals3:02
Discover DAX language fundamentals, a data analysis expressions functional language with 200 plus functions built for Power BI Desktop, extending Excel syntax to multi-table calculations.
Data Types, DAX Operators and DAX Syntax9:44
DAX Functions list by categories - Table and Scalar values6:41
Calculated in Power Bi9:38
Calculated Measures in Power BI13:59
Master calculated measures in Power BI by writing explicit DAX measures, learn their single-value outputs, portability, and nesting, and use them in visuals without increasing data model size.
Calculated Columns vs Calculated Measure3:19
Filter Context and Row Context11:36
Explore how evaluation context shapes DAX calculations in Power BI, distinguish filter context from row context, and see how visual coordinates filter data for measures and calculated columns.
Golden rules of Measures and other important things8:29

Introduction to Common DAX functions2:06
Explore common DAX functions across date and time, math and trigonometry, statistics, text, and logic categories, using calculated columns and matrix visuals in Power BI Desktop.
Related and Related Table function6:48
Master the related and related table functions in Power BI Desktop to pull information across the one-side lookup table and the many-side data table, using active relationships and aggregations.
Date and Time functions in DAX8:13
Fundamental Math Operation using DAX functions and Operators12:11
Rounding off numbers inside Power BI6:11
Learn to round numbers in Power BI using round, round up, round down, and the MROUND function, and to extract integers and decimals from profits in a sales dataset.
Statistical DAX Functions5:43
DISTINCTCOUNT function in DAX to count unique customers, etc.7:13
Text functions5:16
SWITCH function best alternative to nested IF functions6:29
Learn how to use the switch function as an alternative to nested IFs in Power BI Desktop, applying simple equal conditions and complex tests to map values efficiently.

Introduction to CALCULATE function in DAX4:56
Explore how the dax calculate function drives context transitions and overrides filter context to shape measure results in Power BI.
CALCULATE syntax explanation6:41
Master the calculate syntax in Power BI by examining the mandatory first argument, filtering conditions, and how visuals' initial filter context, product color, and product category interact.
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
Explore how the all, allexcept, and allselected functions remove filter context in Power BI Desktop, using table and column references inside calculate, with practical examples and a forthcoming case study.
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
Explore the differences and similarities between calculate, filter, and all in Power BI data modeling, using calendar year filters and initial filter context versus all function behavior.
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: