Stat Modeller – Excel Power BI Masterclass
Stat Modeller Reserve Your Spot
HYBRID · IN-PERSON + ONLINE

Advanced Excel and Power BI Masterclass

AI-Driven Business Analytics for Smarter Decision Making

Two intensive, hands-on days — join in person or live online. Led by Hiren Kakkad and a specialist facilitator.

DATE
10–11 Oct 2026
TIME
9:00 – 18:00
VENUE
Vadodara
FORMAT
Hybrid
CERTIFICATE
Included
ORIGINAL PRICE
₹9,999
 
60% OFF
EARLY BIRD
₹3,999
Before 20 Sep
50% OFF
REGULAR
₹4,999
After 20 Sep
Reserve Your Spot
BEYOND THE TWO DAYS

What comes with your seat

This isn’t just two days in a room — it’s a year of continued access and support built in.

Access to recorded course for 1 year

Revisit every Advanced Excel and Power BI session for a full year after the masterclass — rewatch any module whenever you need a refresher. Worth ₹5,000, included free with your seat.

Free 1-hour 1-to-1 expert consulting

A free, 1-hour one-on-one online session with our expert team — bring your own data problem and work through it together.

Certificate of completion

A certificate recognizing the skills you’ve built over the two days, ready to add to your profile or resume.

WHY ATTEND

Two working days, not two long lectures

Built for people who need to leave knowing how to actually do the work — not just having watched someone else do it.

Hands-on with real data

You’ll work inside real spreadsheets and real Power BI files — building, breaking, and fixing things yourself, not watching slides.

Two full, focused days

Enough time to move from what you already know in Excel and Power BI to advanced, decision-ready techniques.

Direct access to your trainers

In person or live online, question by question — get your own datasets and reports looked at as you work.

DAY-WISE AGENDA

What you’ll cover, hour by hour

Two focused days, each structured the same way — Day 1 on Advanced Excel, Day 2 on Power BI.

Day 1 Advanced Excel
9:00 – 9:30
Breakfast
9:30 – 11:15

Session 1 · Formulas, Conditional Formatting & Data Validation

  • Basic and intermediate Excel formulas
  • Conditional formatting to highlight key insights
  • Data validation to control and standardize data entry
11:15 – 11:30
Tea Break
11:30 – 13:30

Session 2 · Data Cleaning and Power Query

  • Data cleaning and formatting best practices
  • Importing and transforming data with Power Query
  • Removing duplicates and handling blanks or errors
  • Combining and appending multiple data sources
13:30 – 14:15
Lunch Break
14:15 – 16:00

Session 3 · Advanced Formulas and Functions

  • Lookup functions: VLOOKUP, INDEX-MATCH, XLOOKUP
  • Logical and conditional functions: IFS, SUMIFS, COUNTIFS
  • Introduction to array formulas and dynamic arrays
  • Common formula errors and how to handle them
16:00 – 16:15
Tea Break
16:15 – 18:00

Session 4 · Pivot Tables and Dashboards

  • Building PivotTables and PivotCharts
  • Using slicers and timelines for interactivity
  • Designing a one-page Excel dashboard
  • Bringing it together into a decision-ready dashboard
Day 2 Power BI
9:00 – 9:30
Breakfast
9:30 – 11:15

Session 1 · Power BI Fundamentals & Data Import

  • Power BI interface and overall workflow
  • Connecting to multiple data sources
  • Data transformation using Power Query in Power BI
  • Structuring data for reliable analysis
11:15 – 11:30
Tea Break
11:30 – 13:30

Session 2 · Data Modeling & DAX Essentials

  • Building relationships between tables
  • Introduction to DAX formulas
  • Calculated columns versus measures
  • Common DAX functions: SUM, CALCULATE, FILTER
13:30 – 14:15
Lunch Break
14:15 – 16:00

Session 3 · Building Interactive Dashboards

  • Choosing the right visuals for your data
  • Slicers, filters, and drill-throughs
  • Designing a clean, decision-ready report layout
  • Formatting for clarity and impact
16:00 – 16:15
Tea Break
16:15 – 18:00

Session 4 · Publishing & Real-World Application

  • Publishing reports to Power BI Service
  • Sharing reports and scheduling data refresh
  • Row-level security basics
  • Open Q&A applying Power BI to your own data
MEET YOUR TRAINERS

Led by practitioners, not presenters

Hiren Kakkad

Hiren Kakkad

Founder & CEO, Stat Modeller

15+ years turning raw, disconnected data into decision-ready intelligence. A Certified Lean Six Sigma Master Black Belt and Google Analytics Certified Professional, pairing rigorous statistical methods with fluency in today’s leading analytics and AI tools.

LEAN SIX SIGMA MASTER BLACK BELT GOOGLE ANALYTICS CERTIFIED 15+ YEARS EXPERIENCE 17K+ TRAINED GLOBALLY 200+ PROJECTS LED
Anish Parmar

Anish Parmar

Researcher & Lean Six Sigma Consultant

A Lean Six Sigma practitioner and researcher pursuing a PhD in Management, with an M.Sc. in Quality & Productivity Management. Anish has trained professionals in Advanced Excel and built Power BI dashboards for data-driven decision-making, and currently researches Lean Six Sigma adoption in Indian MSMEs.

PHD SCHOLAR · MANAGEMENT M.SC. QUALITY & PRODUCTIVITY ADVANCED EXCEL & POWER BI
PRICING

Reserve your seat at the best price

Early bird pricing ends 20 September — lock in your spot before the price goes up.

ORIGINAL PRICE
₹9,999
 
60% OFF
EARLY BIRD
₹3,999
Before 20 Sep
50% OFF
REGULAR
₹4,999
After 20 Sep
Reserve Your Spot

Save your seat for this exclusive masterclass.

Join us in person or online for two intensive days and bring your own data problems. Includes a year of recorded access, 1-on-1 expert consulting, and a certificate of completion.

10–11 OCT 2026
9:00 – 18:00
HYBRID

Reserve your spot

Enter your details below to confirm your interest.
Own laptop required · Limited to a small, hands-on cohort
✓

Thank you for showing interest!

Our team will reach out to you shortly.

You cannot copy content of this page