The Complete DAX Bootcamp from Beginner to Advanced

Focused View

Balamurugan Sivasangar

14:13:33

0 View

1. Introduction and Course Structure

1. Course Structure and Introduction.mp4

01:58

2. Setting up things ready.mp4

01:25

Files.zip

2. Data Connecting & Transformation - Prerequisite

1. Section Introduction.mp4

00:28

2. Getting Data.mp4

03:37

3. Transform Data in Power Query.mp4

13:43

4. Date Table in Power Query.mp4

04:34

5. Loading and wrapping up data transformation.mp4

00:44

3. Data Model - Prerequisite

1. Section Introduction.mp4

00:27

2. Data Model Fundamentals.mp4

01:04

3. Fact and Dimension tables.mp4

02:51

4. Schemas.mp4

02:13

5. Relationships, Cardinality & Filter flow.mp4

11:24

4. DAX Started

1.1 dax complete bootcamp.zip

1. Section Introduction.mp4

00:29

2. What is DAX.mp4

01:57

3. The DAX Engine.mp4

01:15

4. What is Calculated Column & Calculated Table.mp4

02:39

5. What is Measure.mp4

03:07

6. What is Implicit and Explicit Measure.mp4

01:59

5. DAX - Aggregation Functions

1. Section Introduction.mp4

03:37

2. SUM.mp4

03:52

3. MIN.mp4

03:25

4. MAX.mp4

01:47

5. Assignment - SUM, MIN, MAX.mp4

00:33

6. Solution - SUM, MIN, MAX.mp4

02:57

7. AVERAGE.mp4

01:42

8. Assignment - AVERAGE.mp4

00:39

9. Solution - AVERAGE.mp4

02:30

10. COUNT.mp4

01:50

11. DISTINCTCOUNT.mp4

02:37

12. COUNTROWS.mp4

01:52

13. Assignment - COUNT, DISTINCTCOUNT, COUNTROWS.mp4

00:49

14. Solution - COUNT, DISTINCTCOUNT, COUNTROWS.mp4

03:00

6. Context & Calculate, Variables, Tricks & Tips

1. Understanding Filter Context.mp4

05:34

2. CALCULATE.mp4

04:42

3. Row Context & Context Transition.mp4

06:19

4. Assignment - CALCULATE.mp4

01:21

5. Solution - CALCULATE.mp4

04:51

6. Variables.mp4

08:13

7. Measures Table.mp4

03:54

8. Formatting DAX.mp4

02:34

7. Iterator Functions

1. SUMX.mp4

07:40

2. Assignment - SUMX.mp4

00:47

3. Solution - SUMX.mp4

00:50

4. MINX.mp4

06:55

5. Assignment - MINX.mp4

00:31

6. Solution - MINX.mp4

01:28

7. MAXX.mp4

04:54

8. Assignment - MAXX.mp4

00:41

9. Solution - MAXX.mp4

01:37

10. AVERAGEX.mp4

04:23

11. Assignment - AVERAGEX.mp4

00:27

12. Solution - AVERAGEX.mp4

01:24

13. COUNTX.mp4

03:14

14. Assignment - COUNTX.mp4

00:13

15. Solution - COUNTX.mp4

01:14

16. Assignment - Iterators.mp4

01:50

17. Solutions - Iterators.mp4

05:26

8. Filters Functions

1.1 dax complete bootcamp.zip

1. Section Introduction.mp4

01:03

2. FILTER.mp4

11:50

3. Assignment - FILTER.mp4

02:37

4. Solution - FILTER.mp4

09:49

5. ALL.mp4

10:38

6. ALLEXCEPT.mp4

06:28

7. ALLSELECTED.mp4

09:39

8. Assignment - ALL,ALLEXCEPT,ALLSELECTED.mp4

02:09

9. Solution - ALL,ALLEXCEPT,ALLSELECTED.mp4

03:50

10. Assignment - Filters Functions.mp4

03:21

11. Solution - Filters Functions.mp4

09:45

9. Information Functions

1. Section Introduction.mp4

01:23

2. SELECTEDVALUE.mp4

10:09

3. HASONEVALUE.mp4

06:41

4. ISBLANK.mp4

02:26

5. ISEVEN, ISODD.mp4

02:03

6. ISTEXT.mp4

01:12

7. CONTAINSSTRING.mp4

03:27

8. ISFILTERED.mp4

02:35

9. ISINSCOPE.mp4

04:04

10. Assignment - Information Functions.mp4

01:28

11. Solution - Information Functions.mp4

02:42

10. Logical Functions

1. Section Introduction.mp4

01:02

2. IF Condition.mp4

07:06

3. AND, OR, Operators.mp4

14:13

4. NOT.mp4

01:38

5. SWITCH.mp4

08:18

6. COALESCE.mp4

03:22

7. Assignment - Logical Functions.mp4

02:39

8. Solution - Logical Functions.mp4

11:43

11. Min & Max Highlight

1. Highlight Min & Max data points using DAX.mp4

12:21

12. Math Functions

1. ABS.mp4

04:08

2. VALUE.mp4

02:07

3. MOD.mp4

02:34

4. ROUND.mp4

05:38

5. DIVIDE.mp4

06:33

6. Assignment - Math Functions.mp4

01:34

7. Solution - Math Functions.mp4

03:22

13. Text Functions

1.1 dax complete bootcamp.zip

1. Section Introduction.mp4

00:49

2. CONCATENATE.mp4

03:38

3. CONCATENATEX.mp4

08:29

4. LEFT, RIGHT.mp4

05:38

5. UPPER, LOWER.mp4

02:15

6. LEN.mp4

01:11

7. Tricks and Tips (First Letter Upper and remaining Lower).mp4

09:35

8. REPLACE.mp4

05:13

9. SUBSTITUTE.mp4

02:26

10. FORMAT.mp4

13:55

11. Assignment - Text Functions.mp4

02:29

12. Solution - Text Functions.mp4

14:40

14. Trick and Tips

1. Running Total.mp4

07:24

2. Previous 7 Days Running Total.mp4

03:21

15. Table Functions

1. Section Introduction.mp4

01:29

2. CALCULATETABLE.mp4

10:16

3. DISTINCT.mp4

03:05

4. VALUES.mp4

01:39

5. Assignment 1 - Table Functions.mp4

01:59

6. Solution 1 - Table Functions.mp4

06:28

7. SUMMARIZE.mp4

09:37

8. Assignment 2 - Table Functions.mp4

01:33

9. Solution 2 - Table Functions.mp4

07:21

10. ADDCOLUMNS.mp4

05:15

11. SELECTCOLUMNS.mp4

03:33

12. UNION.mp4

04:31

13. GENERATESERIES.mp4

02:43

14. Assignment 3 - Table Functions.mp4

01:06

15. Solution 3 - Table Functions.mp4

06:02

16. Relationship Functions

1. RELATED.mp4

07:16

2. RELTEDTABLE.mp4

04:52

3. USERELATIONSHIP.mp4

06:20

4. CROSSFILTER.mp4

06:34

5. Assignment - Relationship Functions.mp4

00:48

6. Solution - Relationship Functions.mp4

01:26

17. TopN, Rankx

1. TOPN.mp4

11:14

2. Assignment - TopN.mp4

00:25

3. Solution - TopN.mp4

03:51

4. RANKX.mp4

14:42

5. Assignment - RANKX.mp4

01:05

6. Solution - RANKX.mp4

04:46

7. TOPN Trick.mp4

05:13

18. Time Intelligence Functions

1. Section Introduction.mp4

00:49

2. TODAY, DATE, NOW.mp4

03:44

3. CALENDAR, CALENDARAUTO.mp4

10:53

4. YEAR, MONTH, QUARTER, WEEKNUM.mp4

04:21

5. Calendar Table in DAX.mp4

06:44

6. PREVIOUS YEAR, QUARTER, MONTH, DAY.mp4

12:16

7. NEXT YEAR, QUARTER, MONTH, DAY.mp4

10:03

8. START OF YEAR, QUARTER, MONTH.mp4

05:59

9. END OF YEAR, QUARTER, MONTH.mp4

06:59

10. Assignment 1 - Time Intelligence.mp4

03:17

11. Solution 1 - Time Intelligence.mp4

20:06

12. DATEADD.mp4

16:18

13. SAMEPERIODLASTYEAR.mp4

07:59

14. PARALLELPERIOD.mp4

12:24

15. Assignment 2 - Time Intelligence.mp4

01:04

16. Solution 2 - Time Intelligence.mp4

08:02

17. DATESYTD and TOTALYTD.mp4

10:32

18. DATESQTD and TOTALQTD.mp4

10:26

19. DATESMTD and TOTALMTD.mp4

09:26

20. Assignment 3 - Time Intelligence.mp4

00:58

21. Solution 3 - Time Intelligence.mp4

05:07

22. EDATE.mp4

08:59

23. EOMONTH.mp4

07:09

24. DATEDIFF.mp4

04:22

25. Assignment 4 - Time Intelligence.mp4

00:58

26. Solution 4 - Time Intelligence.mp4

06:56

27. DATESINPERIOD.mp4

11:47

28. Moving Average using DATESINPERIOD.mp4

06:36

19. Calculation Groups

1. Calculation Groups Introduction.mp4

08:36

20. DAX Statements

1. DAX Statements.mp4

06:03

21. Visual Level Calculations

1. Visual Calculations Introduction.mp4

02:26

2. Visual Calculations Basics.mp4

05:51

3. PREVIOUS and NEXT.mp4

03:48

4. FIRST and LAST.mp4

04:05

5. EXPAND and EXPANDALL.mp4

07:53

6. COLLAPSE and COLLAPSEALL.mp4

08:17

7. RUNNINGSUM.mp4

04:49

8. RANGE.mp4

05:36

Description

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

Who is this for?

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

What You Need to Know?

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

More details

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.
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

DAX

Balamurugan Sivasangar

Instructor's Courses

I’m a dedicated data analyst specializing in Power BI and DAX, with a strong passion for teaching and sharing my expertise.My journey in data analysis has equipped me with a deep understanding of how to turn complex datasets into actionable insights. I am committed to making learning data analysis accessible and engaging, blending practical skills with clear, easy-to-understand explanations. My goal is to empower individuals and teams to leverage their data effectively, driving strategic decision-making and fostering growth.In my teaching, I focus on demystifying data analysis concepts, using a variety of methods to ensure that every participant can grasp and apply these skills in real-world scenarios. Whether through hands-on workshops or detailed tutorials, I am dedicated to supporting learners every step of the way and making data analysis a powerful tool for success.

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.