? Day 1: Data Wrangling Foundations & Power Query
? Objective: Build a solid understanding of data wrangling, introduce Power Query for transformations, and provide a structured intro to Power BI.
Session 1: Introduction to Data Wrangling (1.5 hours)
? What is Data Wrangling & Why is it Important?
- The role of data wrangling in analytics & AI
- Common data challenges & pitfalls
? Data Quality Issues & Cleaning Strategies
- Missing values, duplicates, inconsistencies
- Case study: How bad data impacts decision-making
? ? Hands-On Activity: "Data Detective" (Group Work)
- Teams receive a messy dataset and must:
✅ Identify key issues
✅ Propose cleaning strategies
✅ Discuss the impact on analytics
Session 2: Power Query for Data Transformation (2.5 hours)
? Introduction to Power Query Editor
- Power Query UI walkthrough
- Applied steps: Filtering, merging, appending datasets
? Advanced Data Cleaning & Transformations
- Handling missing values, text inconsistencies, outliers
- Unpivoting, pivoting, and reshaping data
? ? Hands-On Challenge: "Fix This Data!" (Group Activity)
- Each group is given a messy dataset
- They must clean & structure the data using Power Query
- Bonus: Optimize transformation steps for performance
Session 3: Introduction to Power BI (2 hours)
? Overview of Power BI Components
- Power Query vs. Data Modeling vs. Visualization
- How Power BI connects to different data sources
? Building a Simple Report in Power BI
- Loading data & creating a basic dashboard
- Connecting Power Query transformations to visuals
? ? Hands-On Challenge: "First Power BI Dashboard" (Individual Work)
- Import a dataset, apply basic transformations
- Create a simple visual report
? Optional Session 4: Python for Data Wrangling (1.5 hours)
? When to Use Python vs. Power Query
- Strengths & limitations of each tool
? Intro to pandas for Data Wrangling
- Cleaning missing data & outliers
- Data type conversions & transformations
? ? Hands-On Challenge: “Power Query vs. Python”
- Perform the same transformation using Power Query & Python
? ? Wrap-Up & Q&A (30 mins)
- Recap & troubleshooting
- Preview of Data Modeling & DAX (Day 2)
? Day 2: Data Modeling & Advanced DAX
? Objective: Optimize data modeling and master DAX for powerful calculations.
Session 5: Data Modeling Fundamentals (2 hours)
? Building an Efficient Data Mode
- Star vs. Snowflake schema for Power BI performance
- Handling many-to-many relationships
? ? Group Hands-On: “Redesign This Data Model”
- Teams are given a flawed data model and must redesign it.
Session 6: Advanced DAX – Going Beyond Basics (3 hours)
? DAX Deep Dive: Beyond Basic Measures
- Row Context vs. Filter Context
- Advanced Time Intelligence Functions (YTD, QTD, Moving Averages)
? ? Hands-On Challenge: "DAX Formula Battle" (Group Work)
- Teams receive business questions requiring complex DAX formulas.
Session 7: Automating Reports & Data Refresh (2 hours)
? Incremental Refresh & Power Automate Integration
- Setting up dynamic parameters for automation
? ? Hands-On Challenge: “Automate Your Data!”
- Each team configures an automated refresh workflow for a dataset.
? ? Wrap-Up & Q&A (30 mins)
- Recap & troubleshooting
- Preview of Dashboarding & Storytelling (Day 3)
? Day 3: Advanced Data Visualization & Storytelling
? Objective: Build interactive dashboards and communicate insights effectively.
Session 8: Data Storytelling & Visualization Best Practices (2 hours)
? Principles of Effective Dashboard Design
- Choosing the right charts & layouts
- Avoiding misleading visuals
? ? Group Activity: “Fix This Dashboard”
- Teams receive a badly designed dashboard and must improve it.
Session 9: Interactive Dashboards & Custom Visuals (3 hours)
? Enhancing User Experience in Power BI
- Slicers, Filters, Drill-Throughs, Bookmarks
- What-If Parameters for scenario analysis
? ? Hands-On Challenge: “Create a Dynamic Dashboard”
- Teams build an interactive dashboard using real-world data.
Session 10: Presenting Insights & Final Project (3 hours)
? ? Final Group Project: “Tell the Data Story”
- Teams present their dashboards as if to executives.
? ? Live Feedback & Peer Review
- Participants critique and suggest improvements.
? ? Final Wrap-Up & Next Steps (30 minutes)
- Best practices recap
- Resources for further learning
- Certificates & closing remarks