DAX Decoded: Essential Fundamentals in Power BI

سرفصل های دوره

From Beginner to Master: Unlocking the Power of DAX Formulas in Power BI

1. Introduction to DAX

1. Welcome to DAX Decoded

2. Microsoft Power BI user-interface updates to be aware of.html

3.1 MiP-resource-pack.zip

3. Introduction to DAX Resources.html

4. Unpacking DAX Importance and Use Cases

5. Understanding Data Scenario

6. Building Your First Power BI Model

7. Introduction to DAX - Review.html

8. Introduction to DAX - Quiz.html

2. DAX Basics

1. Distinguishing Between Measures & Calculated Columns

2. Mastering Simple Aggregations

3. Formula syntax, comments, variables

4. DAX vs Excel Formulas What Sets Them Apart

5. Harmonizing the Data Model with DAX

6. DAX Basics - Review.html

7. DAX Basics - Quiz.html

3. DAX Evaluation Context

1. Evaluation Context

2. Filter context

3. Row context

4. Critical Considerations for Context

5. DAX Evaluation Context - Review.html

6. DAX Evaluation Context - Quiz.html

4. Advanced DAX Concepts

1. Why CALCULATE is the Master Key in DAX

2. Implementing Simple Filters

3. What are table functions

4. Classifying Time Intelligence Functions

5. How to combine patterns of DAX formula

6. Utilizing Quick Measures for Efficiency

7. Advanced DAX Real-world Examples

8. Advanced DAX Concepts - Review.html

9. Advanced DAX Concepts - Quiz.html

5. DAX Formula Patterns

1. Computing Percent of Total - Simple

2. Percent of Total - Context Considerations

3. Moving Averages - Simple

4. Re-using the Moving Averages Pattern

5.1 Cumulative Totals - Resource Pack.zip

5. Cumulative Totals Resource Materials.html

6. Cumulative Totals - ALL

7. Leveraging ALLSELECTED for Cumulative Totals

8. Cumulative totals - Measure Branching

9. DAX Formula Patterns Review.html

10. DAX Formula Patterns Quiz.html

6. Time Intelligence and Grouping in DAX

1.1 Time Intelligence - Resource Pack.zip

1. Time Intelligence Resource.html

2. Aggregating Data with Time Intelligence

3. Time Intelligence - Measure Branching

4. Calculating Percentage Change on Prior Period

5. Utilizing the DATEADD Function

6.1 Grouping - Resource Pack.zip

6. Grouping Material.html

7. Achieving Grouping via Calculated Columns

8. Applying Lookup Table Logic for Grouping

9. Dynamic Grouping Strategies with Support Tables

10. Ranking Customers Dynamically

11. Time Intelligence and Grouping in DAX - Review.html

12. Time Intelligence and Grouping in DAX - Quiz.html

7. Applying DAX to Business Scenarios

1.1 Events in Progress - Resource Pack.zip

1. Events in Progress Material.html

2. Events in Progress Concept

3.1 Budgeting - Resource Pack.zip

3. Budgeting Material.html

4. Introducing Budgeting Models

5. Expanding Your Budgeting Models

6.1 Forecasting - Resource Pack.zip

6. Forecasting materials.html

7. Kick-starting with Forecasting Models

8. Advancing Your Forecasting Models

9.1 Parameter Tables - Resource Pack.zip

9. Parameter Tables Materials.html

10. Introduction to Parameter Tables

11. Diving into Parameter Tables

12. Troubleshooting Parameter Tables

13.1 Advanced Scenario Analysis Techniques - Resource Pack.zip

13. Advanced Scenario Analysis Techniques Resources.html

14. Mastering Advanced Scenario Analysis Techniques

15.1 Multi-Layered Scenario Analysis - Resource Pack.zip

15. Navigating Multi-Layered Scenario Analysis

16. Scenario Analysis Expanded

17. Related Distinct Counts

18. Applying DAX to Business Scenarios - Review.html

19. Applying DAX to Business Scenarios - Quiz.html

20. Congratulations and Next Steps.html

139,000 تومان

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

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

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

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