Mastering Dax And Data Models In Power Bi Desktop

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
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 stepRelationship between data tables - To understand the flow of informationDAX - Perform your data crunching and analysisVisual analytics - Not just numbers and but pictorial presentationI 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.

Overview

Section 1: Introduction

Lecture 1 Introduction to Power BI and Its components

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

Lecture 3 Loading of data in Power BI desktop using Query Editor and separate course

Lecture 4 Headsup about the course material

Section 2: Data Modelling

Lecture 5 Data Modelling mindset - Think in multiple tables

Lecture 6 Keys in Tables - Primary Key and Foreign Key

Lecture 7 Introduction to Normalisation of Datasets

Lecture 8 Rule # 1 : First Normal Form - single value and not repeating groups

Lecture 9 Rule # 2 : Second Normal Form - composite primary key

Lecture 10 Rule # 3 : Third Normal Form - dependency between non-key fields

Lecture 11 How to normalize the a dummy dataset by applying normalization rules

Lecture 12 Recap - Three Normalisation rules

Lecture 13 Table types - Data / Fact table and Lookup / Dimension Table

Lecture 14 Relationship Cardinality an introduction

Lecture 15 One to Many relationship

Lecture 16 Many to Many relationship

Lecture 17 One to One relationship

Lecture 18 Relationship cardinality recap

Lecture 19 Relationship in Power BI - Active / In-active, one / both way filter propagation

Lecture 20 Diagram view : Top Down, Star Schema, Snow Flakes - managing table presentation

Section 3: Preparing your data for Dashboards

Lecture 21 Tables related options - Table view, Rename, Hide / Delete

Lecture 22 Columns related - Width, Rename, Sort / Sort by, Hide / Delete, Filters, Groups

Lecture 23 Data Types valid inside Power BI Desktop

Lecture 24 Formatting data inside a column

Lecture 25 How to categorize data inside Power BI Desktop

Lecture 26 How to apply default summarization to a column inside Power BI Desktop

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

Lecture 28 How to import Power Pivot data model from Excel into Power BI

Section 4: DAX fundamentals - Power of Power BI desktop

Lecture 29 An introduction to DAX language fundamentals

Lecture 30 Data Types, DAX Operators and DAX Syntax

Lecture 31 DAX Functions list by categories - Table and Scalar values

Lecture 32 Calculated in Power Bi

Lecture 33 Calculated Measures in Power BI

Lecture 34 Calculated Columns vs Calculated Measure

Lecture 35 Filter Context and Row Context

Lecture 36 Golden rules of Measures and other important things

Section 5: Basic DAX function examples

Lecture 37 Introduction to Common DAX functions

Lecture 38 Related and Related Table function

Lecture 39 Date and Time functions in DAX

Lecture 40 Fundamental Math Operation using DAX functions and Operators

Lecture 41 Rounding off numbers inside Power BI

Lecture 42 Statistical DAX Functions

Lecture 43 DISTINCTCOUNT function in DAX to count unique customers, etc.

Lecture 44 Text functions

Lecture 45 SWITCH function best alternative to nested IF functions

Section 6: CALCULATE - boss of DAX functions and functions supporting it.

Lecture 46 Introduction to CALCULATE function in DAX

Lecture 47 CALCULATE syntax explanation

Lecture 48 Examples using CALCULATE function

Lecture 49 FILTER function introduction to syntax, how it works and when to use it.

Lecture 50 Using FILTER function in filter argument of CALCULATE

Lecture 51 Context Transition using CALCULATE and FILTER function

Lecture 52 ALL, ALLEXCEPT and ALLSELECTED function inside DAX to remove filter context

Lecture 53 ALL and ALLEXCEPT function case study - single table

Lecture 54 ALL and ALLEXCEPT function case study - multiple tables

Lecture 55 ALLSELECTED - remove initial filter context and keep filter context selectively

Lecture 56 CALCULATE, FILTER, ALL - differences and similarities while using these function

Lecture 57 Bonus - Discount on my other courses

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