❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 18th, 2023]

Skills and Knowledge:
By taking this course, students will acquire the skills and knowledge necessary to increase the complexity of their data models, create and understand more complex calculations, understand evaluation context, troubleshoot when things don't go according to plan, and create and produce Business Intelligence style Dashboard and Insight reports. Additionally, students will gain an understanding of variables, row and filter context, static segmentation, multiple data tables, RANKX() and TOPN(), different granularities, budget vs actuals, budget patterns (single year and multiple years), and budgets (monthly).
Professional Growth:
This course contributes to professional growth by providing students with the knowledge and skills necessary to create and understand more complex calculations in Power Pivot. Through the course, students will learn how to increase the complexity of their data models, understand evaluation context, and troubleshoot when things don't go according to plan. Additionally, the course provides practice exercises to help students embed and consolidate their skills, as well as video solutions to ensure they are never on their own. By taking this course, students will be better equipped to work in finance, statistics, project, business and market analysis, or any data reporting role, and create and produce Business Intelligence style Dashboard and Insight reports.
Further Education:
This course is suitable for preparing further education as it provides comprehensive instruction on the fundamentals of DAX Power Pivot and helps students to transition into more advanced concepts. It covers a range of topics and provides practice exercises to help students embed and consolidate their skills. Additionally, the course has been highly praised by other students, indicating its effectiveness in helping them to develop their DAX skills.

Course Syllabus

Introduction

Warm Up Exercises

Step 1 - Variables

Step 2 Row & Filter Context

Step 3 Static Segmentation

Step 4 Multiple Data Tables

Step 5 RANKX() & TOPN()

Step 6 Different Granularity

Step 7 Budget vs Actuals

Step 8 Budget Patterns YEARLY

Step 9 Budget Pattern - Multiple YEARS

Step 10 Monthly Budgets for Part Years

Bonus Section