Power BI Live Course (2 Days/Week: Sat & Sun)

Module 1: Introduction to Power BI

• What is Power BI?

• Comparison with Excel

• Power BI ecosystem: Desktop, Service, Mobile

• Downloading & Installing Power BI

• Basic settings after installation

Module 2: Data Sources & Power Query

• Frontend (Data, Model, Report) vs Backend (Power Query, DAX)

• Connecting to different data sources

• Power Query Editor overview

• Data Cleaning & Transformation

  • Date tools

  • Text tools

  • Number tools

  • Index & Conditional Columns

  • Grouping, Aggregating

  • Pivot & Unpivot

  • Promoted Headers

  • Column by Example

• Merging & Appending Queries

• Advanced Editor in Power Query

• Pros of Power Query: Build once, Refresh always

Module 3: Data Modelling with Power Pivot

• Power Pivot Overview

• Relationships in Power BI (One-to-One, One-to-Many, Many-to-Many)

• Star Schema vs Snowflake Schema

• Primary Key & Foreign Key Concepts

Module 4: DAX (Data Analysis Expressions)

• Calculated Columns & Measures

• DAX Functions:

  • Aggregation (SUM, AVERAGE, MIN, MAX, COUNT)

  • Text & Logical Functions

  • Date & Time Functions

  • Statistical Functions

  • Time Intelligence Functions (YTD, MTD, QTD, SAMEPERIODLASTYEAR, PARALLELPERIOD, etc.)

  • Iterators (SUMX, AVERAGEX, MINX, MAXX, COUNTX)

  • FILTER, VALUES, RELATED, RELATEDTABLE, LOOKUPVALUE

• Important DAX Functions: CALCULATE, RELATED, ALL

• Operators in Power BI

Module 5: Visualization & Dashboards

• Creating Tables, Charts, and KPIs

• Conditional Formatting in visuals

• Interactive Dashboards (Filters, Slicers, Drill-through)

• Best practices for Dashboard Design

Module 6: Advanced Power BI

• Creating New Tables using DAX

• Time Intelligence in Real Scenarios

• Iterator Functions with Examples

• Using ALL, ALLEXCEPT for Context Control

Module 7: Final Project & Dashboard Publishing

• Building a Business Dashboard from Raw Data

• Publishing & Sharing Reports

• Power BI Service vs Power BI Desktop

• Security & Access Control in Power BI

Schedule:

• Start Date: 1st November 2025

• Days: Saturday & Sunday

• Time: 7:00 PM – 9:00 PM (IST)

• Mode: Live on Zoom

• Fees: ₹2000 for early birds only