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

1. Introduction and Course Structure

1. Course Structure and Introduction

2. Setting up things ready

Files.zip

2. Data Connecting & Transformation - Prerequisite

1. Section Introduction

2. Getting Data

3. Transform Data in Power Query

4. Date Table in Power Query

5. Loading and wrapping up data transformation

3. Data Model - Prerequisite

1. Section Introduction

2. Data Model Fundamentals

3. Fact and Dimension tables

4. Schemas

5. Relationships, Cardinality & Filter flow

4. DAX Started

1.1 dax complete bootcamp.zip

1. Section Introduction

2. What is DAX

3. The DAX Engine

4. What is Calculated Column & Calculated Table

5. What is Measure

6. What is Implicit and Explicit Measure

5. DAX - Aggregation Functions

1. Section Introduction

2. SUM

3. MIN

4. MAX

5. Assignment - SUM, MIN, MAX

6. Solution - SUM, MIN, MAX

7. AVERAGE

8. Assignment - AVERAGE

9. Solution - AVERAGE

10. COUNT

11. DISTINCTCOUNT

12. COUNTROWS

13. Assignment - COUNT, DISTINCTCOUNT, COUNTROWS

14. Solution - COUNT, DISTINCTCOUNT, COUNTROWS

6. Context & Calculate, Variables, Tricks & Tips

1. Understanding Filter Context

2. CALCULATE

3. Row Context & Context Transition

4. Assignment - CALCULATE

5. Solution - CALCULATE

6. Variables

7. Measures Table

8. Formatting DAX

7. Iterator Functions

1. SUMX

2. Assignment - SUMX

3. Solution - SUMX

4. MINX

5. Assignment - MINX

6. Solution - MINX

7. MAXX

8. Assignment - MAXX

9. Solution - MAXX

10. AVERAGEX

11. Assignment - AVERAGEX

12. Solution - AVERAGEX

13. COUNTX

14. Assignment - COUNTX

15. Solution - COUNTX

16. Assignment - Iterators

17. Solutions - Iterators

8. Filters Functions

1.1 dax complete bootcamp.zip

1. Section Introduction

2. FILTER

3. Assignment - FILTER

4. Solution - FILTER

5. ALL

6. ALLEXCEPT

7. ALLSELECTED

8. Assignment - ALL,ALLEXCEPT,ALLSELECTED

9. Solution - ALL,ALLEXCEPT,ALLSELECTED

10. Assignment - Filters Functions

11. Solution - Filters Functions

9. Information Functions

1. Section Introduction

2. SELECTEDVALUE

3. HASONEVALUE

4. ISBLANK

5. ISEVEN, ISODD

6. ISTEXT

7. CONTAINSSTRING

8. ISFILTERED

9. ISINSCOPE

10. Assignment - Information Functions

11. Solution - Information Functions

10. Logical Functions

1. Section Introduction

2. IF Condition

3. AND, OR, Operators

4. NOT

5. SWITCH

6. COALESCE

7. Assignment - Logical Functions

8. Solution - Logical Functions

11. Min & Max Highlight

1. Highlight Min & Max data points using DAX

12. Math Functions

1. ABS

2. VALUE

3. MOD

4. ROUND

5. DIVIDE

6. Assignment - Math Functions

7. Solution - Math Functions

13. Text Functions

1.1 dax complete bootcamp.zip

1. Section Introduction

2. CONCATENATE

3. CONCATENATEX

4. LEFT, RIGHT

5. UPPER, LOWER

6. LEN

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

8. REPLACE

9. SUBSTITUTE

10. FORMAT

11. Assignment - Text Functions

12. Solution - Text Functions

14. Trick and Tips

1. Running Total

2. Previous 7 Days Running Total

15. Table Functions

1. Section Introduction

2. CALCULATETABLE

3. DISTINCT

4. VALUES

5. Assignment 1 - Table Functions

6. Solution 1 - Table Functions

7. SUMMARIZE

8. Assignment 2 - Table Functions

9. Solution 2 - Table Functions

10. ADDCOLUMNS

11. SELECTCOLUMNS

12. UNION

13. GENERATESERIES

14. Assignment 3 - Table Functions

15. Solution 3 - Table Functions

16. Relationship Functions

1. RELATED

2. RELTEDTABLE

3. USERELATIONSHIP

4. CROSSFILTER

5. Assignment - Relationship Functions

6. Solution - Relationship Functions

17. TopN, Rankx

1. TOPN

2. Assignment - TopN

3. Solution - TopN

4. RANKX

5. Assignment - RANKX

6. Solution - RANKX

7. TOPN Trick

18. Time Intelligence Functions

1. Section Introduction

2. TODAY, DATE, NOW

3. CALENDAR, CALENDARAUTO

4. YEAR, MONTH, QUARTER, WEEKNUM

5. Calendar Table in DAX

6. PREVIOUS YEAR, QUARTER, MONTH, DAY

7. NEXT YEAR, QUARTER, MONTH, DAY

8. START OF YEAR, QUARTER, MONTH

9. END OF YEAR, QUARTER, MONTH

10. Assignment 1 - Time Intelligence

11. Solution 1 - Time Intelligence

12. DATEADD

13. SAMEPERIODLASTYEAR

14. PARALLELPERIOD

15. Assignment 2 - Time Intelligence

16. Solution 2 - Time Intelligence

17. DATESYTD and TOTALYTD

18. DATESQTD and TOTALQTD

19. DATESMTD and TOTALMTD

20. Assignment 3 - Time Intelligence

21. Solution 3 - Time Intelligence

22. EDATE

23. EOMONTH

24. DATEDIFF

25. Assignment 4 - Time Intelligence

26. Solution 4 - Time Intelligence

27. DATESINPERIOD

28. Moving Average using DATESINPERIOD

19. Calculation Groups

1. Calculation Groups Introduction

20. DAX Statements

1. DAX Statements

21. Visual Level Calculations

1. Visual Calculations Introduction

2. Visual Calculations Basics

3. PREVIOUS and NEXT

4. FIRST and LAST

5. EXPAND and EXPANDALL

6. COLLAPSE and COLLAPSEALL

7. RUNNINGSUM

8. RANGE

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy