📅 Duration: 3 Months | ⏰ Timings: Weekends Only (4 Hours/Week)

🚀 Learn Power BI from Scratch to Advanced Level – Perfect for Beginners, Job Seekers & Working Professionals

🔸 Course Highlights

• Learn from Basic to Advanced with hands-on examples

• Live Interactive Sessions every weekend

• Build real-world dashboards & projects

• Learn Data Modeling, DAX, Power Query, and Publishing

• Get interview preparation, resume tips, and portfolio support

🧭 Course Structure

✅ Module 1: Introduction to Power BI (Week 1)

• What is Business Intelligence?

• Power BI Overview: Desktop, Service, Mobile

• Installing Power BI Desktop

• Interface & Navigation

• Understanding Datasets, Reports, and Dashboards

✅ Module 2: Working with Data (Week 2)

• Connecting to data: Excel, CSV, Web, SQL Server

• Import vs Direct Query

• Power Query Editor Introduction

• Data Cleaning & Shaping Basics

✅ Module 3: Power Query – Data Transformation (Week 3–4)

• Removing Errors & Duplicates

• Splitting & Merging Columns

• Append vs Merge Queries

• Custom & Conditional Columns

• Parameters, Unpivoting, Grouping

✅ Module 4: Data Modeling (Week 5)

• Star vs Snowflake Schema

• Creating & Managing Relationships

• Active/Inactive Relationships

• Calendar Table & Date Hierarchies

✅ Module 5: DAX – Power BI Formulas (Week 6–7)

• Measures vs Calculated Columns

• Basic DAX: SUM, COUNT, AVERAGE

• Logical DAX: IF, SWITCH, AND, OR

• Text Functions: LEFT, RIGHT, FIND

• Time Intelligence: YTD, MTD, QTD

• Advanced DAX: CALCULATE, ALL, SUMX, FILTER, EARLIER

✅ Module 6: Data Visualization (Week 8–9)

• Charts: Bar, Line, Pie, Table, Matrix

• Cards, KPIs, Donut & Gauge Visuals

• Slicers, Filters & Drill Through

• Conditional Formatting

• Bookmarks, Buttons & Tooltips

• Creating Themes and Layouts

✅ Module 7: Advanced Features (Week 10)

• Row Level Security (RLS)

• What-If Parameters

• Performance Analyzer

• Advanced Tooltips

• Q&A Feature

• Optimization Techniques

✅ Module 8: Power BI Service & Sharing Reports (Week 11)

• Publishing to Power BI Service

• Creating Dashboards in Service

• Sharing Reports and Collaboration

• Scheduled Refresh

• Export Options

• Power BI Mobile App Overview

✅ Module 9: Capstone Project + Job Prep (Week 12)

• Final Dashboard Project (Real-world Data)

• Report Design Best Practices

• Resume & LinkedIn Profile Guidance

• Common Interview Questions

• Power BI Certification (PL-300) Guidance

📢 New Batch Starting Soon!