Advanced DAX & Power BI Data Modeling
Course Objectives
1. Master Power BI visualization options and best practices.
2. Learn to use AI visuals such as Key Influencers and Decomposition Tree.
3. Develop advanced report design techniques and storytelling with data.
4. Use Power BI’s Smart Narratives and Q&A features.
5. Configure dynamic formatting and conditional visuals using DAX.
Prerequisites
• Basic knowledge of Power BI Desktop and DAX.
• Understanding of data modeling and business KPIs.
Tools & Environment
• Power BI Desktop (latest version)
• Sample data reports for visualization exercises
• Windows OS, preferably 8GB RAM or higher
Beyond Objectives Learning
• Implement AI-powered visuals to uncover insights.
• Design compelling reports focused on storytelling.
• Use advanced formatting to enhance user experience.
• Prepare to work as a Power BI report developer or business intelligence analyst.
Sr. Title Topic Objective
45 DAX Programming - What is DAX Basics Introduce filter context concepts in
Filter Context - Part 1 DAX programming for Power BI.
46 DAX Programming - What is DAX Basics Continue deep dive into filter
Filter context - Part 2 context and its importance in DAX.
47 Snowflake and Galaxy Scheme in Data Understand Snowflake and Galaxy
Power BI - Introduction Modeling schema concepts in Power BI data
Schemas modeling.
48 Snowflake & Galaxy schema Data Practical example of Snowflake &
implementation example in Modeling Galaxy schema implementation in
Power BI - Part 1 Power BI.
49 Snowflake & Galaxy schema Data Continuation of Snowflake & Galaxy
implementation in Power BI - Modeling schema example implementation.
Part 2
50 DAX Programming in Power BI - DAX & Learn how DAX interacts with Power
DAX, Data Modeling & Vertipaq Storage BI's Vertipaq storage engine and
Engine Engine data modeling.
51 DAX Programming in Power BI - DAX Understand implicit measures and
What are implicit measures Measures their use cases in Power BI.
52 DAX Programming in Power BI - DAX Learn about explicit measures and
What are explicit measures Measures how to create them.
53 DAX Programming in Power BI - DAX Introduction to key DAX functions
DAX Functions - Part 1 Functions used in Power BI.
54 DAX Programming in Power BI - DAX Continuation of DAX functions
DAX Functions - Part 2 Functions overview.
55 DAX Programming in Power BI - DAX Further explore advanced DAX
DAX Functions - Part 3 Functions functions.
Sr. Title Topic Objective
56 DAX Programming in Power BI - DAX Functions Advanced DAX functions part 4
DAX Functions - Part 4 with examples.
57 DAX Programming in Power BI - Data Modeling Understand when and how to
How and why to disable Autodetect Settings disable auto-detect
relationships in data modeling relationships for optimized
modeling.
58 DAX Programming in Power BI - DAX Functions Part 5 in the series of DAX
DAX Functions - Part 5 functions explained.
59 DAX Programming in Power BI - DAX Functions Continuation of DAX functions.
DAX Functions - Part 6
60 DAX Programming in Power BI - DAX Functions Deep dive into CALCULATE
DAX Functions (CALCULATE) - Part (CALCULATE) function and its usage in Power
7 BI.
61 DAX Programming in Power BI - DAX Functions Explore KEEPFILTERS function
DAX Functions (KEEPFILTERS) - Part and scenarios to use it.
8
62 DAX Programming in Power BI - DAX Functions Learn about REMOVEFILTERS
DAX Functions (REMOVEFILTERS) - function to clear filters in DAX
Part 9 queries.
63 DAX Programming in Power BI - DAX Functions Understand how to use
DAX Functions (VAR) - Part 10 (VAR) variables in DAX for optimized
calculations.
64 DAX Programming in Power BI - DAX Functions Explore modifiers in
DAX Functions (CALCULATE (Modifiers) CALCULATE for flexible DAX
Modifiers) - Part 11 expressions.
65 DAX Programming in Power BI - DAX Functions Detailed look at FILTER function
DAX Functions (FILTER) - Part 12 (FILTER) in DAX and its applications.
66 DAX Programming in Power BI - DAX Table Learn about table functions
DAX Functions (Table functions in Functions inside DAX measures.
measures) - Part 13
67 DAX Programming in Power BI - DAX Functions Understand the ALL function
DAX Functions (ALL) - Part 14 (ALL) and its impact on filters.
68 DAX Programming in Power BI - DAX Functions Learn to summarize data using
DAX Functions SUMMARIZECOLUMNS function.
(SUMMARIZECOLUMNS) - Part 15
69 DAX Programming in Power BI - DAX Functions Further advanced usage of
DAX Functions (FILTER) - Part 16 (FILTER) FILTER function in complex
scenarios.
70 DAX Programming in Power BI - Time Introduction to time intelligence
Time Intelligence Functions - Intelligence functions for date-based
Introduction calculations.
71 DAX Programming in Power BI - Time Learn how to implement year-
Time Intelligence Functions - Intelligence to-date calculations using DAX.
Year-to-Date Pattern
Sr. Title Topic Objective
72 DAX Programming in Power BI - Time Explore quarter-to-date (QTD)
Time Intelligence Patterns QTD, Intelligence and month-to-date (MTD)
MTD with Field Parameters patterns in DAX.
73 DAX Programming in Power BI - Time Learn previous period
Time Intelligence using Previous Intelligence calculation patterns with DAX.
Period Pattern
74 DAX Programming in Power BI - Time Understand running total
Time Intelligence Running Total Intelligence calculations in Power BI using
Pattern DAX.
75 Learn Power BI in Urdu / Hindi - Webinar Participate in a free live
Free AMA live webinar on 14-02- webinar for Power BI learning
2025 in Urdu/Hindi.
76 DAX Programming in Power BI - Data Understand relationships and
Relationships and Bi-Directional Relationships bi-directional filtering in Power
Filtering - Part 1 BI.
77 DAX Programming in Power BI - Data Continuation of relationships
Relationships and Bi Directional Relationships and filtering concepts.
Filtering - Part 2
78 Connecting Power BI with an SQL Data Source Learn how to connect Power BI
Server Database - Storage Mode in Connections to SQL Server with different
Power BI - Part 1 storage modes.
79 Import vs DirectQuery - Storage Data Storage Compare Import and
Modes in Power BI - Part 2 Modes DirectQuery storage modes in
Power BI.
80 Import vs DirectQuery - Storage Data Storage Continuation of storage modes
Modes in Power BI - Part 3 Modes discussion.
81 Import vs DirectQuery - Storage Data Storage Further details on storage
Modes in Power BI - Part 4 Modes mode differences and best
practices.
82 Import vs DirectQuery - Storage Data Storage Additional storage modes
Modes in Power BI - Part 5 Modes insights and configurations.
83 Import vs DirectQuery - Storage Data Storage More on performance impacts
Modes in Power BI - Part 6 Modes of different storage modes.
84 Import vs DirectQuery - Storage Data Storage Continued exploration of
Modes in Power BI - Part 7 Modes storage modes.
85 Import vs DirectQuery - Storage Data Storage Bonus content on dual storage
Modes in Power BI - Part 8 Modes mode in Power BI.
86 Import vs DirectQuery - Storage Data Storage Understand dual storage mode
Modes in Power BI (Bonus: Dual Modes capabilities and benefits.
Storage Mode) - Part 9
Minimum Completion Criteria:
• Complete all modules and MCQs
• Attempt weekly marathons
• Submit at least 2 out of 5 projects in the final level
• Attend minimum 80% of lessons
Certificate Details
• Upon successful completion of the Internship, learners will receive a Government-
Recognized Certificate from Vidyawan, a registered MSME enterprise (Udyam
Registration No: UDYAM-WB-14-0205610).
One Month Internship Certificate Weekly Marathon Participation Certificate
Performance-Based Badge System
• Gold Badge – For Top Performers (90%+ score, completed 4+ projects)
• Silver Badge – For consistent performance (70–89%)
• Copper/Participant Badge – For all learners who complete the program
Contact Information
For queries, registration, or collaboration, feel free to contact us:
Vidyawan – Internship & Skill Development Platform
(A Government-registered MSME – UDYAM-WB-14-0205610)
• Email: [email protected]
• Website: www.vidyawan.in (Get in touch section)
• Location: West Bengal, India
• Follow us for updates and upcoming internships
