The Complete Dax Bootcamp From Beginner To Advanced

Complete DAX Training: Start from Scratch and Advance in Power BI. Master data analysis and reporting skills effectively

What you'll learn

Learn Data Analysis Expressions (DAX) from scratch

Complete DAX Bootcamp with assignments and solution walkthrough

DAX Functions with Demo, DAX Statements, Visual Calculations

Data Transformation Fundamentals to get started

Data Modeling Fundamentals to get started

Requirements

Power BI Desktop (free download)

Power BI Desktop (not available on MAC OS)

No paid software required

Basic Power BI Knowledge would be plus bot Not required

Description

Dive into the world of Data Analysis Expressions (DAX) in Power BI with my comprehensive course, designed to take you from fundamentals to advanced techniques. This course is ideal for those who have a basic understanding of data connecting and transformation fundamentals in Power Query, as well as data modeling basics (no worries even you don't have fundamental knowledge of data transformation and modeling, I have covered Data transformation and modeling fundamentals to get started DAX).Course Highlights:Fundamentals covered : Refresh your knowledge on data connecting and transformation fundamentals in Power Query and data modeling essentials to ensure a strong foundation.DAX Essentials: Understand the DAX engine, including row context and filter contexts, and explore calculated tables, calculated columns, and measures. Learn the differences between implicit and explicit measures.Aggregation Functions: Master core DAX functions for aggregation such as SUM, MIN, MAX, AVERAGE, COUNT, DISTINCTCOUNT, and COUNTROWS.Advanced DAX Techniques: Delve into CALCULATE functions, context transition, and the use of variables and measure tables for dynamic calculations.Iterator Functions: Learn to apply iterator functions like SUMX, MINX, MAXX, AVERAGEX, and COUNTX to iterate over tables and perform complex calculations.Filter Functions: Utilize filter functions including FILTER, ALL, ALLEXCEPT, and ALLSELECTED to manage and manipulate data contexts.Information Functions: Explore functions like SELECTEDVALUE, HASONEVALUE, ISBLANK, ISEVEN, ISODD, ISTEXT, ISFILTERED, CONTAINSSTRING, and ISINSCOPE for effective data evaluation.Logical Functions: Apply logical functions such as IF, AND, OR, SWITCH, and COALESCE to create robust and dynamic expressions.Mathematical Functions: Use mathematical functions like ABS, VALUE, MOD, ROUND, and DIVIDE for precise calculations and transformations.Text Functions: Master text manipulation with functions such as CONCATENATE, CONCATENATEX, LEFT, RIGHT, UPPER, LOWER, LEN, REPLACE, SUBSTITUTE, and FORMAT.Table Functions: Learn to handle tables with functions like CALCULATETABLE, DISTINCT, VALUES, SUMMARIZE, ADDCOLUMNS, SELECTCOLUMNS, UNION, and GENERATESERIES.Relationship Functions: Understand relationship functions such as RELATED, RELATEDTABLE, USERELATIONSHIP, and CROSSFILTER for managing data relationships.Ranking and Top N: Implement TOPN and RANKX functions to rank and filter top results in your datasets.Time Intelligence Functions: Master time-based calculations using DAX functions like TODAY, DATE, NOW, CALENDAR, and CALENDARAUTO. Learn to manipulate and analyze dates with functions such as YEAR, MONTH, QUARTER, WEEKNUM, and perform advanced time period calculations with TOTALYTD, TOTALQTD, TOTALMTD, DATESYTD, DATESQTD, DATESMTD, DATEADD, PARALLELPERIOD, SAMEPERIODLASTYEAR, DATESINPERIOD, EDATE, EOMONTH, PREVIOUSYEAR, PREVIOUSQUARTER, PREVIOUSMONTH, PREVIOUSDAY, NEXTYEAR, NEXTQUARTER, NEXTMONTH, NEXTDAY, STARTOFYEAR, STARTOFQUARTER, STARTOFMONTH, ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH, and DATEDIFF for comprehensive time-based analysis.Calculation Groups: Learn how to create and manage calculation groups to streamline your DAX expressions and enhance reporting efficiency.DAX Statements: Develop proficiency in writing and optimizing DAX statements for effective data analysis and reporting.Visual Calculations: Enhance visualizations with calculations that include previous, next, first, last, collapse, expand, running sums, and ranges.Additional Features:Tricks and Tips: Discover practical tips and tricks to streamline your DAX calculations and improve efficiency.Assignments: Apply your learning with hands-on assignments designed to reinforce key concepts and techniques.Solution Walkthroughs: Review detailed solutions to assignments, gaining deeper insights and understanding to enhance your skills.By the end of this course, you’ll be equipped with the skills to leverage DAX effectively for powerful data analysis and reporting in Power BI.

Overview

Section 1: Introduction and Course Structure

Lecture 1 Course Structure and Introduction

Lecture 2 Setting up things ready

Lecture 3 Important Note : Who is this course for

Lecture 4 Download resource (Data sets)

Section 2: Data Connecting & Transformation - Prerequisite

Lecture 5 Section Introduction

Lecture 6 Getting Data

Lecture 7 Transform Data in Power Query

Lecture 8 Date Table in Power Query

Lecture 9 Loading and wrapping up data transformation

Section 3: Data Model - Prerequisite

Lecture 10 Section Introduction

Lecture 11 Data Model Fundamentals

Lecture 12 Fact and Dimension tables

Lecture 13 Schemas

Lecture 14 Relationships, Cardinality & Filter flow

Section 4: DAX Started

Lecture 15 Section Introduction

Lecture 16 What is DAX

Lecture 17 The DAX Engine

Lecture 18 What is Calculated Column & Calculated Table

Lecture 19 What is Measure

Lecture 20 What is Implicit and Explicit Measure

Section 5: DAX - Aggregation Functions

Lecture 21 Section Introduction

Lecture 22 SUM

Lecture 23 MIN

Lecture 24 MAX

Lecture 25 Assignment - SUM, MIN, MAX

Lecture 26 Solution - SUM, MIN, MAX

Lecture 27 AVERAGE

Lecture 28 Assignment - AVERAGE

Lecture 29 Solution - AVERAGE

Lecture 30 COUNT

Lecture 31 DISTINCTCOUNT

Lecture 32 COUNTROWS

Lecture 33 Assignment - COUNT, DISTINCTCOUNT, COUNTROWS

Lecture 34 Solution - COUNT, DISTINCTCOUNT, COUNTROWS

Section 6: Context & Calculate, Variables, Tricks & Tips

Lecture 35 Understanding Filter Context

Lecture 36 CALCULATE

Lecture 37 Row Context & Context Transition

Lecture 38 Assignment - CALCULATE

Lecture 39 Solution - CALCULATE

Lecture 40 Variables

Lecture 41 Measures Table

Lecture 42 Formatting DAX

Section 7: Iterator Functions

Lecture 43 SUMX

Lecture 44 Assignment - SUMX

Lecture 45 Solution - SUMX

Lecture 46 MINX

Lecture 47 Assignment - MINX

Lecture 48 Solution - MINX

Lecture 49 MAXX

Lecture 50 Assignment - MAXX

Lecture 51 Solution - MAXX

Lecture 52 AVERAGEX

Lecture 53 Assignment - AVERAGEX

Lecture 54 Solution - AVERAGEX

Lecture 55 COUNTX

Lecture 56 Assignment - COUNTX

Lecture 57 Solution - COUNTX

Lecture 58 Assignment - Iterators

Lecture 59 Solutions - Iterators

Section 8: Filters Functions

Lecture 60 Section Introduction

Lecture 61 FILTER

Lecture 62 Assignment - FILTER

Lecture 63 Solution - FILTER

Lecture 64 ALL

Lecture 65 ALLEXCEPT

Lecture 66 ALLSELECTED

Lecture 67 Assignment - ALL,ALLEXCEPT,ALLSELECTED

Lecture 68 Solution - ALL,ALLEXCEPT,ALLSELECTED

Lecture 69 Assignment - Filters Functions

Lecture 70 Solution - Filters Functions

Section 9: Information Functions

Lecture 71 Section Introduction

Lecture 72 SELECTEDVALUE

Lecture 73 HASONEVALUE

Lecture 74 ISBLANK

Lecture 75 ISEVEN, ISODD

Lecture 76 ISTEXT

Lecture 77 CONTAINSSTRING

Lecture 78 ISFILTERED

Lecture 79 ISINSCOPE

Lecture 80 Assignment - Information Functions

Lecture 81 Solution - Information Functions

Section 10: Logical Functions

Lecture 82 Section Introduction

Lecture 83 IF Condition

Lecture 84 AND, OR, Operators

Lecture 85 NOT

Lecture 86 SWITCH

Lecture 87 COALESCE

Lecture 88 Assignment - Logical Functions

Lecture 89 Solution - Logical Functions

Section 11: Min & Max Highlight

Lecture 90 Highlight Min & Max data points using DAX

Section 12: Math Functions

Lecture 91 ABS

Lecture 92 VALUE

Lecture 93 MOD

Lecture 94 ROUND

Lecture 95 DIVIDE

Lecture 96 Assignment - Math Functions

Lecture 97 Solution - Math Functions

Section 13: Text Functions

Lecture 98 Section Introduction

Lecture 99 CONCATENATE

Lecture 100 CONCATENATEX

Lecture 101 LEFT, RIGHT

Lecture 102 UPPER, LOWER

Lecture 103 LEN

Lecture 104 Tricks and Tips (First Letter Upper and remaining Lower)

Lecture 105 REPLACE

Lecture 106 SUBSTITUTE

Lecture 107 FORMAT

Lecture 108 Assignment - Text Functions

Lecture 109 Solution - Text Functions

Section 14: Trick and Tips

Lecture 110 Running Total

Lecture 111 Previous 7 Days Running Total

Section 15: Table Functions

Lecture 112 Section Introduction

Lecture 113 CALCULATETABLE

Lecture 114 DISTINCT

Lecture 115 VALUES

Lecture 116 Assignment 1 - Table Functions

Lecture 117 Solution 1 - Table Functions

Lecture 118 SUMMARIZE

Lecture 119 Assignment 2 - Table Functions

Lecture 120 Solution 2 - Table Functions

Lecture 121 ADDCOLUMNS

Lecture 122 SELECTCOLUMNS

Lecture 123 UNION

Lecture 124 GENERATESERIES

Lecture 125 Assignment 3 - Table Functions

Lecture 126 Solution 3 - Table Functions

Section 16: Relationship Functions

Lecture 127 RELATED

Lecture 128 RELTEDTABLE

Lecture 129 USERELATIONSHIP

Lecture 130 CROSSFILTER

Lecture 131 Assignment - Relationship Functions

Lecture 132 Solution - Relationship Functions

Section 17: TopN, Rankx

Lecture 133 TOPN

Lecture 134 Assignment - TopN

Lecture 135 Solution - TopN

Lecture 136 RANKX

Lecture 137 Assignment - RANKX

Lecture 138 Solution - RANKX

Lecture 139 TOPN Trick

Section 18: Time Intelligence Functions

Lecture 140 Section Introduction

Lecture 141 TODAY, DATE, NOW

Lecture 142 CALENDAR, CALENDARAUTO

Lecture 143 YEAR, MONTH, QUARTER, WEEKNUM

Lecture 144 Calendar Table in DAX

Lecture 145 PREVIOUS YEAR, QUARTER, MONTH, DAY

Lecture 146 NEXT YEAR, QUARTER, MONTH, DAY

Lecture 147 START OF YEAR, QUARTER, MONTH

Lecture 148 END OF YEAR, QUARTER, MONTH

Lecture 149 Assignment 1 - Time Intelligence

Lecture 150 Solution 1 - Time Intelligence

Lecture 151 DATEADD

Lecture 152 SAMEPERIODLASTYEAR

Lecture 153 PARALLELPERIOD

Lecture 154 Assignment 2 - Time Intelligence

Lecture 155 Solution 2 - Time Intelligence

Lecture 156 DATESYTD and TOTALYTD

Lecture 157 DATESQTD and TOTALQTD

Lecture 158 DATESMTD and TOTALMTD

Lecture 159 Assignment 3 - Time Intelligence

Lecture 160 Solution 3 - Time Intelligence

Lecture 161 EDATE

Lecture 162 EOMONTH

Lecture 163 DATEDIFF

Lecture 164 Assignment 4 - Time Intelligence

Lecture 165 Solution 4 - Time Intelligence

Lecture 166 DATESINPERIOD

Lecture 167 Moving Average using DATESINPERIOD

Section 19: Calculation Groups

Lecture 168 Calculation Groups Introduction

Section 20: DAX Statements

Lecture 169 DAX Statements

Section 21: Visual Level Calculations

Lecture 170 Visual Calculations Introduction

Lecture 171 Visual Calculations Basics

Lecture 172 PREVIOUS and NEXT

Lecture 173 FIRST and LAST

Lecture 174 EXPAND and EXPANDALL

Lecture 175 COLLAPSE and COLLAPSEALL

Lecture 176 RUNNINGSUM

Lecture 177 RANGE

If you want to learn DAX from scratch,If you are a beginner and want to improve your problem solving skills in DAX,Even though this course is only DAX, have covered data transformation, data modeling fundamentals to get started