This course includes
- 2 months, 48+ hours of hands-on training
- Micro batches of 6 to 10 learners
- 1 free retake of the entire programme
- SKETO certification in Power BI and Advanced Excel
- Dashboards built on data from your own field
- Two capstone projects: an Excel dashboard and a full Power BI report
Same core skills for everyone. Projects from your world.
Every learner masters the same core: Advanced Excel, Power Query, Power BI and DAX. What changes is the data you practise on. Your dashboards are built on real datasets from the field you work in, or the one you want to move into, so you learn the reports your own industry runs on.
- Excel
- Pivot Tables
- Power Query
- Power BI
- DAX
- Data Modelling
The core: same for every learner
Your projects: built on your industry's data
You build HR dashboards: hiring, attrition, payroll and employee performance.
You build financial KPI trackers: transactions, collections, budgets and risk.
You build sales performance reports: targets, regions, pipelines and forecasts.
Operations, marketing or your own business: tell us on your counselling call and we pick datasets from your world.
What you'll learn
3 stages · 7 hands-on modules · real business data from day one
Stage 1: Advanced Excel3 modules
Module 01Stage 1
Excel Foundations & Core Functions
- Basic Excel functions for data handling and calculations
- Text functions for cleaning and transforming data
- Sorting, filtering and organising datasets
- Data validation for accuracy
Module 02Stage 1
Logical & Lookup Functions
- IF, AND, OR, IFS and nested IF
- VLOOKUP, HLOOKUP, INDEX-MATCH and XLOOKUP
- What-If analysis: Goal Seek, Scenario Manager and Data Tables
Module 03Stage 1
Pivot Tables, Charts & Excel Dashboards
- Pivot Tables to find trends in large datasets
- Charts for clear storytelling
- Slicers and interactive elements
- A full Excel dashboard, built from scratch
Stage 2: Power BI3 modules
Module 04Stage 2
Power BI Foundations & Data Connection
- Power BI Desktop and when to use Excel or Power BI
- Connecting to Excel, CSV and databases
- Power Query for import, cleaning and transformation (ETL)
Module 05Stage 2
Data Modelling & DAX Calculations
- Table relationships and data models
- Calculated columns, measures and quick measures
- Time intelligence (YTD, MoM, QoQ), CALCULATE, FILTER and context transition
Module 06Stage 2
Power BI Visualizations & Dashboards
- Bar, line, scatter, map, funnel and KPI visuals
- Drill-through, cross-filtering and bookmarks
- Report layout and design
- Publishing to Power BI Service and sharing reports
Stage 3: Capstone & Career Prep1 module
Module 07Stage 3
Capstone Projects & Career Prep
- Two end-to-end projects: an Excel dashboard and a full Power BI report
- Portfolio review and LinkedIn
- Interview Q&A for data analyst roles
- Introduction to the PL-300 certification pathway
AI built into your dashboards
Power BI comes with built-in AI. You use it in your projects: find what drives your numbers, write report summaries and answer questions in plain English.
- Key Influencers
- Smart Narratives
- Plain-English Q&A
- AI Copilot
- Decomposition Tree
- ChatGPT for Excel
AI-powered business dashboard
A Power BI dashboard with AI visuals, Key Influencers and Smart Narratives.
Automated forecasting model
Forecasts built with Power BI's AI features and Excel analytics.
Natural-language analytics
A Q&A page where anyone can ask questions in plain English and get charts back.
Two ways to start
See how we teach before you commit to the full course.
- Dadar West classroom
- Live online
- Free retake
- Installments available
Free call with a counsellor
Free
Talk through your goals, the syllabus and your options. No obligation.
Speak to an Admissions CounsellorLive trial class
₹499
A 2-hour hands-on session where you work on a live dataset with our trainer.
Book a ₹499 Trial ClassIs this course right for you?
This program focuses on industry-relevant skills and practical expertise. Successful learners receive a SKETO certificate, not an academic degree.
A good fit if
- You work in finance, operations, sales or HR and spend hours on manual Excel reports
- You're a fresher or graduate who wants to start in Data Analytics
- You run a business or team and want to track your own KPIs
Not the right fit if
- You want a weekend crash course. This one runs for 2 months
- You want theory only, without hands-on projects
- You only want recorded videos
Learn in class or live online
In our Dadar classroom
Learn face to face with your trainer and a small group of classmates.
- Live, interactive classes
- Trainer in the room with you
- Doubts answered on the spot
Live online
Join live classes from wherever you are.
- Live sessions, not recordings
- Ask your trainer in real time
What our students say
★★★★★"…It also helped me increase my programming and statistical knowledge. The teaching staff is great and always available to solve any queries. You also get job opportunities from their end so you can apply side by side while learning."
KSKaustubh SawantData Science · UrbanPro Review
★★★★★"…It was an exceptional experience. The instructor was knowledgeable, enthusiastic, and made complex concepts easy to understand. The interactive sessions and hands-on exercises helped reinforce the learning material."
ADAyush DhumalGoogle Review · Mar 2025
★★★★★"I had an outstanding learning experience of the Expert Data Science program. The instructors were not only highly skilled but also deeply committed to ensuring every concept was clearly understood. Their practical approach and real-world examples made even the most advanced topics approachable…"
SSaiExpert Data Science · Google Review
Sourced from Google Reviews and UrbanPro.
Frequently asked questions
Do I need prior Excel knowledge?
No. The course starts with Excel basics and builds up to lookups, pivot tables and dashboards before you move to Power BI.
Will my dashboards match my field?
Yes. Everyone learns the same core skills, but your projects use data from your field: HR data if you're in HR, finance data if you're in banking or finance, real sales datasets if you're aiming for a sales manager role. We agree your project focus on your free counselling call.
What is the fee for the full course?
We confirm the exact fee and installment plan on your free counselling call. You can also try a 2-hour live class for ₹499 first.
Are classes online or in person?
Both: in our Dadar West classroom or live online. Online classes are live and interactive, not recordings, and cover the same curriculum. Morning, afternoon and evening batches are available.
Is this a degree?
No. It is a skills course with a SKETO certificate. It does not replace a university degree.
What job roles can I aim for?
BI Analyst, Data Analyst, BI Developer, MIS Executive, Dashboard Developer or Financial Analyst, or a data-driven version of your current role. Outcomes depend on your background and effort.
Can I attend a class before deciding?
Yes. The 2-hour live trial class costs ₹499. You work on a live dataset with our trainer.
Speak to an Admissions Counsellor
Share a few details and we'll call you within 2 working hours (10am–8pm).