DAX Decoded: Essential Fundamentals in Power BI

Focused View

Enterprise DNA,Sam McKay

6:12:48

95 View

1. Introduction to DAX

1. Welcome to DAX Decoded.mp4

03:47

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.mp4

05:41

5. Understanding Data Scenario.mp4

03:03

6. Building Your First Power BI Model.mp4

04:51

7. Introduction to DAX - Review.html

8. Introduction to DAX - Quiz.html

2. DAX Basics

1. Distinguishing Between Measures & Calculated Columns.mp4

15:00

2. Mastering Simple Aggregations.mp4

08:44

3. Formula syntax, comments, variables.mp4

11:58

4. DAX vs Excel Formulas What Sets Them Apart.mp4

04:29

5. Harmonizing the Data Model with DAX.mp4

06:04

6. DAX Basics - Review.html

7. DAX Basics - Quiz.html

3. DAX Evaluation Context

1. Evaluation Context.mp4

04:48

2. Filter context.mp4

04:01

3. Row context.mp4

08:36

4. Critical Considerations for Context.mp4

08:10

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.mp4

11:04

2. Implementing Simple Filters.mp4

07:08

3. What are table functions.mp4

14:32

4. Classifying Time Intelligence Functions.mp4

08:34

5. How to combine patterns of DAX formula.mp4

09:09

6. Utilizing Quick Measures for Efficiency.mp4

06:33

7. Advanced DAX Real-world Examples.mp4

14:31

8. Advanced DAX Concepts - Review.html

9. Advanced DAX Concepts - Quiz.html

5. DAX Formula Patterns

1. Computing Percent of Total - Simple.mp4

03:36

2. Percent of Total - Context Considerations.mp4

04:14

3. Moving Averages - Simple.mp4

06:06

4. Re-using the Moving Averages Pattern.mp4

02:41

5.1 Cumulative Totals - Resource Pack.zip

5. Cumulative Totals Resource Materials.html

6. Cumulative Totals - ALL.mp4

04:23

7. Leveraging ALLSELECTED for Cumulative Totals.mp4

03:19

8. Cumulative totals - Measure Branching.mp4

07:02

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.mp4

09:55

3. Time Intelligence - Measure Branching.mp4

05:37

4. Calculating Percentage Change on Prior Period.mp4

04:56

5. Utilizing the DATEADD Function.mp4

07:31

6.1 Grouping - Resource Pack.zip

6. Grouping Material.html

7. Achieving Grouping via Calculated Columns.mp4

07:24

8. Applying Lookup Table Logic for Grouping.mp4

06:34

9. Dynamic Grouping Strategies with Support Tables.mp4

09:14

10. Ranking Customers Dynamically.mp4

12:30

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.mp4

09:12

3.1 Budgeting - Resource Pack.zip

3. Budgeting Material.html

4. Introducing Budgeting Models.mp4

11:10

5. Expanding Your Budgeting Models.mp4

10:27

6.1 Forecasting - Resource Pack.zip

6. Forecasting materials.html

7. Kick-starting with Forecasting Models.mp4

11:57

8. Advancing Your Forecasting Models.mp4

06:01

9.1 Parameter Tables - Resource Pack.zip

9. Parameter Tables Materials.html

10. Introduction to Parameter Tables.mp4

11:00

11. Diving into Parameter Tables.mp4

07:51

12. Troubleshooting Parameter Tables.mp4

03:47

13.1 Advanced Scenario Analysis Techniques - Resource Pack.zip

13. Advanced Scenario Analysis Techniques Resources.html

14. Mastering Advanced Scenario Analysis Techniques.mp4

18:11

15.1 Multi-Layered Scenario Analysis - Resource Pack.zip

15. Navigating Multi-Layered Scenario Analysis.mp4

09:14

16. Scenario Analysis Expanded.mp4

11:48

17. Related Distinct Counts.mp4

06:25

18. Applying DAX to Business Scenarios - Review.html

19. Applying DAX to Business Scenarios - Quiz.html

20. Congratulations and Next Steps.html

Description

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

What You'll Learn?

Understand the fundamentals of DAX in Power BI and its significance in data analysis.
Learn how to apply basic and advanced DAX concepts, including Evaluation Context, Filter and Row context, and the powerful CALCULATE function.
Learn to conduct advanced scenario analyses and interpret customer behaviors using DAX.
Acquire the ability to solve real-world business problems such as budgeting, forecasting, and attrition analysis using DAX.

Who is this for?

Power BI users who want to enhance their data analysis skills using DAX.

Business Intelligence professionals looking to leverage DAX in their analytical tasks.

Data Analysts aiming to build robust and flexible data models.

Beginners who want to learn DAX from scratch to improve their reporting capabilities.

Decision-makers who want to understand how data analysis can support strategic planning.

Individuals considering a career in data analytics or data science and professionals who deal with data in industries such as finance, marketing, HR, sales, etc.

What You Need to Know?

Basic understanding of Microsoft Power BI and its functionalities. Some familiarity with data analysis concepts and principles.

An installed version of Microsoft Power BI Desktop on your computer.

No prior knowledge of DAX is required, making this course suitable for beginners in DAX.

More details

Description
Welcome to "DAX Decoded: Essential Fundamentals in Power BI". This comprehensive course is designed to take you from a DAX beginner to a Power BI master. With a blend of essential fundamentals and advanced techniques, this course offers an all-inclusive guide to DAX (Data Analysis Expressions), the formula language used in Power BI.

You'll start with the basics, understanding what DAX is and why it's critical when using Power BI. By learning and mastering the essential DAX calculations, you'll gradually move on to understanding formula syntax and how DAX calculations and the Power BI data model synergize. Key DAX concepts like CONTEXT and the use of the CALCULATE statement will be thoroughly explored. You'll also dive deep into table functions, time intelligence functions, and get a hands-on understanding of how to solve common to complex analytical problems.

Equipped with multiple demo data sets and downloadable Power BI files to practice along, the course also includes review assessments to solidify your understanding. Whether you're looking to solve simple aggregations or tackle complex analytical techniques, this course is your key to mastering DAX in Power BI.

Enroll now and unlock the full potential of your data analysis skills in Power BI with DAX!
Who this course is for:
Power BI users who want to enhance their data analysis skills using DAX.
Business Intelligence professionals looking to leverage DAX in their analytical tasks.
Data Analysts aiming to build robust and flexible data models.
Beginners who want to learn DAX from scratch to improve their reporting capabilities.
Decision-makers who want to understand how data analysis can support strategic planning.
Individuals considering a career in data analytics or data science and professionals who deal with data in industries such as finance, marketing, HR, sales, etc.

User Reviews

Rating

average 0

Total votes0

Focused display

Ready to take your data skills to the next level?Are you just starting out? Have basic data skills? Highly experienced? Perfect, we got you!We are a real-world data skills training specialist that has helped 220,000+ people like you future-proof their careers for nearly 10 years now.We believe that there is a direct correlation between a person’s data skills and their earning potential.Learning data skills doesn’t have to be difficult; in fact, we believe that it should be easy, actionable, and effective.With us, you’ll learn real-world data skills from actual experts that are immediately transferable to your career.Ready to learn Power BI, Excel, R, SQL, ChatGPT + More?Let’s do this.Start learning with us today!

Sam McKay

Instructor's Courses

Eager to enhance your understanding of data?Whether you're a newbie, possess some data proficiency, or are a seasoned professional - you're in the right place!We are a leading data education powerhouse that has successfully navigated over 230,000+ data enthusiasts just like you towards a prosperous career path for almost a decade.We firmly hold that mastering data skills can dramatically augment one's earning capability.Grasping data skills doesn't have to be an uphill task; instead, we stand by the philosophy that learning should be seamless, applicable, and result-oriented.Under our guidance, you’ll glean practical data skills from genuine experts, skills that you can directly apply to your professional life.Keen to master tools like Power BI, Excel, Python, SQL, ChatGPT, and more?Let's embark on this journey together.Kickstart your data journey with us now!

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.