Power BI: Beginner to Advanced
- 20 hours • 5 weeks • Saturday + Sunday • 2 hours each
Course at a glance
A focused weekend rhythm that turns concepts into repeatable practice.
20
guided hours
10
live sessions
5
weekends
01
capstone
- Begin with the desktop workflow. Finish by modelling, analysing, designing and publishing a complete report
What students will learn
CONNECT
Import common business data sources
TRANSFORM
Clean and reshape data in Power Query
MODEL
Build relationships and star schemas
CALCULATE
Write DAX measures and time intelligence
COMMUNICATE
Design clear, interactive dashboards
DELIVER
Publish, refresh and share responsibly
5-week learning roadmap
01
FOUNDATION
Query
02
STRUCTURE
M + data
modelling
03
LOGIC
DAX foundations + depth
04
STORY
05
DELIVERY
capstone
Fee & Batch Details
Invest in your future with affordable degree fees and flexible batch options
Program Fee
Masterclass Fee: ₹6,500.00
Click the link above and complete the payment. Once the payment is received, your joining link will be sent to your email within 2 hours. If you have any questions, please fill out the form below. Otherwise, you can secure your seat directly by paying through the link.
Batch Details
Starts from 18th Dec 2026
Seats On First Come- First Serve Basis.
Build your profile with the latest trend and get easily placed in Top Corporates
Our Course Certificates are trusted by these industry leaders
Build Your Resume
Build your profile with the latest trend and get easily placed in Top Corporates
Day 1 • Saturday — Power BI fundamentals
SESSION GOAL
Navigate Power BI Desktop and understand how data moves from source to report.
- Desktop interface and core workflow
- Connect to Excel or CSV data
- Create first visuals and filters
- Save a structured .pbix file
PRACTICAL
Build a one-page sales overview from a provided flat file.
Day 2 • Sunday — Power Query data cleaning
SESSION GOAL
Turn untidy source data into a dependable analysis-ready table.
- Query Editor and applied steps
- Data types, nulls and errors
- Split, merge and replace values
- Append and combine files
PRACTICA
Clean monthly sales extracts and produce one consistent table.
Day 3 • Saturday — Advanced Power Query + M
SESSION GOAL
Build reusable transformations and read the M logic behind each step.
- Pivot, unpivot and grouping
- Parameters and reusable queries
- M syntax and step references
- Basic custom functions
PRACTICAL
Create a parameter-driven folder ingestion query.
Day 4 • Sunday — Data modelling
SESSION GOAL
Create a clean semantic model that supports accurate, maintainable analysis.
- Facts, dimensions and grain
- Relationships and cardinality
- Star schema design
- Date and lookup tables
PRACTICA
Refactor a flat sales table into a working star schema
Day 5 • Saturday — DAX fundamentals
SESSION GOAL
Write measures that respond correctly to report filters and business questions.
- Measures versus calculated columns
- SUM, COUNTROWS and DIVIDE
- Filter and row context
- CALCULATE fundamentals
PRACTICAL
Create revenue, margin, quantity and average-order measures
Day 6 • Sunday — Intermediate and advanced DAX
SESSION GOAL
Combine filter logic and iterators to solve richer analytical problems.
- Iterator functions such as SUMX
- FILTER and context transition
- Variables for readable DAX
- Ranking and contribution analysis
PRACTICA
Build product rank and percentage-of-total measures.
Day 7 • Saturday — Time intelligence
SESSION GOAL
Compare performance across periods using a robust date table.
- Date table requirements
- MTD, QTD and YTD
- Previous-period comparisons
- Rolling measures
PRACTICAL
Add YTD sales, prior year and year-on-year growth.
Day 8 • Sunday — Professional dashboards
SESSION GOAL
CoTurn analysis into an accessible, decision focused report experience.
- Visual selection and hierarchy
- Slicers, drill-through and tooltips
- Themes, alignment and accessibility
- Performance-aware page design
PRACTICA
Redesign the sales report as an executive dashboard
Day 9 • Saturday — Advanced Power BI and publishing
SESSION GOAL
Prepare a report for distribution, refresh and controlled collaboration.
- Power BI Service workflow
- Workspaces, apps and sharing
- Refresh and gateway concepts
- Row-level security basics
PRACTICAL
Publish a report and define a safe sharing checklist.
Day 10 • Sunday — End-to-end capstone
SESSION GOAL
Apply the full workflow independently and explain the choices made
- Ingest and clean the data
- Model and calculate
- Design and validate
- Present and peer-review
PRACTICA
Deliver a complete business report plus a brief walkthrough and improvement plan
Practical datasets and projects
Sales
Orders, revenue, discount, profit
Products
Category, brand, cost, price
Customers
Segment, city, region
Calendar
Date, month, quarter, year
Teaching methodology and assessmen
20%
EXPLAIN
Short concept blocks
30%
DEMONSTRATE
Instructor-led build
40%
PRACTISE
Guided then independent
10%
REVIEW
Checks, questions, feedback
From learner to independent report builder
01 Prepare
Connect, clean and document data
02 Model
Build relationships and a date table
03 Analyse
Write measures that answer business questions
04 Communicate
Design interactive, accessible reports
05 Deliver
Publish, validate and plan continued practice
NEXT:
repeat the capstone with a new dataset, maintain a DAX notebook, and seek feedback on one published portfolio report.