Mastering DAX and Data Models in Power BI Desktop

Focused View

Abhay Gadiya

5:44:25

6 View

1 - Introduction

1 - Introduction to Power BI and Its components.mp4

03:22

2 - Power BI desktop Download & Install Learn about desktop layout.mp4

04:46

3 - Loading of data in Power BI desktop using Query Editor and separate course.mp4

04:13

3 - adventure works database newxlsx.zip

4 - Headsup about the course material.html

2 - Data Modelling

5 - Data Modelling mindset Think in multiple tables.mp4

05:16

6 - Keys in Tables Primary Key and Foreign Key.mp4

05:03

7 - Introduction to Normalisation of Datasets.mp4

05:03

8 - Rule First Normal Form single value and not repeating groups.mp4

05:16

9 - Rule Second Normal Form composite primary key.mp4

06:20

10 - Rule Third Normal Form dependency between non key fields.mp4

05:37

11 - How to normalize the a dummy dataset by applying normalization rules.mp4

13:13

11 - de normalised datasets finalxlsx.zip

12 - Recap Three Normalisation rules.mp4

03:01

13 - Table types Data Fact table and Lookup Dimension Table.mp4

05:58

14 - Relationship Cardinality an introduction.mp4

01:50

15 - One to Many relationship.mp4

02:49

16 - Many to Many relationship.mp4

02:22

17 - One to One relationship.mp4

01:45

18 - Relationship cardinality recap.mp4

01:46

19 - Relationship in Power BI Active In active one both way filter propagation.mp4

14:50

20 - Diagram view Top Down Star Schema Snow Flakes managing table presentation.mp4

05:49

3 - Preparing your data for Dashboards

21 - Tables related options Table view Rename Hide Delete.mp4

05:47

22 - Columns related Width Rename Sort Sort by Hide Delete Filters Groups.mp4

17:38

23 - Data Types valid inside Power BI Desktop.mp4

04:27

24 - Formatting data inside a column.mp4

05:38

25 - How to categorize data inside Power BI Desktop.mp4

02:49

26 - How to apply default summarization to a column inside Power BI Desktop.mp4

03:42

27 - How to mark a table as Date Table inside Power BI Desktop and why is it required.mp4

02:46

28 - How to import Power Pivot data model from Excel into Power BI.mp4

03:30

28 - import excel data modelsxlsx.zip

4 - DAX fundamentals Power of Power BI desktop

29 - An introduction to DAX language fundamentals.mp4

03:02

30 - Data Types DAX Operators and DAX Syntax.mp4

09:44

31 - DAX Functions list by categories Table and Scalar values.mp4

06:41

31 - dax functions listxlsx.zip

32 - Calculated in Power Bi.mp4

09:38

32 - DAX Fundamentals.zip

33 - Calculated Measures in Power BI.mp4

13:59

34 - Calculated Columns vs Calculated Measure.mp4

03:19

35 - Filter Context and Row Context.mp4

11:36

36 - Golden rules of Measures and other important things.mp4

08:29

5 - Basic DAX function examples

37 - Introduction to Common DAX functions.mp4

02:06

38 - Related and Related Table function.mp4

06:48

38 - aw returnsxlsx.zip

39 - Date and Time functions in DAX.mp4

08:13

40 - Fundamental Math Operation using DAX functions and Operators.mp4

12:11

40 - aw returnsxlsx.zip

41 - Rounding off numbers inside Power BI.mp4

06:11

42 - Statistical DAX Functions.mp4

05:43

43 - DISTINCTCOUNT function in DAX to count unique customers etc.mp4

07:13

44 - Text functions.mp4

05:16

45 - SWITCH function best alternative to nested IF functions.mp4

06:29

6 - CALCULATE boss of DAX functions and functions supporting it

46 - Introduction to CALCULATE function in DAX.mp4

04:56

47 - CALCULATE syntax explanation.mp4

06:41

48 - Examples using CALCULATE function.mp4

06:17

49 - FILTER function introduction to syntax how it works and when to use it.mp4

07:03

50 - Using FILTER function in filter argument of CALCULATE.mp4

06:38

51 - Context Transition using CALCULATE and FILTER function.mp4

07:08

52 - ALL ALLEXCEPT and ALLSELECTED function inside DAX to remove filter context.mp4

04:25

53 - ALL and ALLEXCEPT function case study single table.mp4

11:30

54 - ALL and ALLEXCEPT function case study multiple tables.mp4

03:31

55 - ALLSELECTED remove initial filter context and keep filter context selectively.mp4

07:08

56 - CALCULATE FILTER ALL differences and similarities while using these function.mp4

07:54

57 - Bonus Discount on my other courses.html

Description

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

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

Who is this 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

What You Need to Know?

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

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

I am Chartered Accountant, Certified Fraud Examiner and have completed Diploma in Information System Audit (Indian equivalent exam for CISA). I have circa 20+ years of experience into Data Analytics, Internal Audits, External (Statutory) Audits, SOX Compliance, Risk Assessment and Regulatory Compliance. I have audited various entities under BFSI, Automotive Manufacturing, ITES, Infrastructure and Pharmaceuticals sectors. I have worked circa 9 years with Big4 consultancy firms – Deloitte, Price Waterhouse, Bank of New York Mellon & Maersk.I have conducted various workshops at Institute of Chartered Accountants of India. Approximately 1000+ people have attended these workshops and have given extremely positive feedback.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.