Free Power BI Live Training -Day 2 | Master Data Modeling, Relationships & DAX Foundations

Free Power BI Training — Day 2 (December 7, 2025)

Topic: Master Data Modeling & DAX for Business Intelligence
Instructor: Michael Mekbib

Welcome to Day 2 of the SI Analytics Academy Free Power BI Training Series.
In this hands-on live session, participants learned how to build high-performance semantic models, create effective table relationships, and write core DAX measures that power business intelligence dashboards.

📘 Training Guide & Practice Files
Access the slide deck, datasets, and follow-along materials here:
👉 https://powerbibymichael.lovable.app/
________________________________________
⭐ What You Will Learn (Step-by-Step Breakdown)
1️⃣ Data Modeling Concepts (20 mins)
• Understanding Fact vs. Dimension tables
• Star Schema structure
• Relationship cardinality & direction
• Why a strong semantic model improves performance
2️⃣ Building Relationships in Power BI (30 mins)
• Auto-detect vs. manual relationships
• Many-to-one data patterns
• Cross-filtering behavior
• Ensuring data model consistency & accuracy
3️⃣ DAX Fundamentals & Core Measures (45 mins)
Hands-on creation of essential measures, including:
• SUM()
• COUNTROWS()
• DISTINCTCOUNT()
• AVERAGE()
• Percentage calculations
• Foundational math expressions
________________________________________
🎯 Who This Training Is For
• Beginners seeking structure and clarity
• Intermediate users refining modeling & DAX skills
• Analysts preparing for Power BI roles
• Public health, business, finance, and operational intelligence practitioners
________________________________________
🚀 About SI Analytics Academy
SI Analytics empowers learners with practical, real-world data skills through structured training, coaching, and community learning.
Stay connected for upcoming sessions, daily tasks, and challenge activities.
________________________________________

🔗 Don’t Miss Previous Training Sessions
Day 1 Recording – Power BI Foundations:
   • Power BI for Beginners – Day 1: Interface,...