Data Analysis using PowerBI and Excel
A hands-on virtual masterclass that takes you from cleaning messy spreadsheets in Excel to building interactive PowerBI dashboards. Learners follow live demonstrations, practise on guided datasets, and leave with a reusable analysis workflow plus a finished dashboard they can show in interviews.
Organised by
Date
Sat, 14 Nov 2026
Time
06:32 AM - 06:32 AM (3 days)
Venue
Google Meet
Seats
97 of 99 left
Registration closes on 13 Nov 2026, 06:32 AM.
Your Seat at a Glance
The joining link opens in My Masterclasses 15 minutes before the start.
- 06:32 AM - 06:32 AM · 3 days
- Virtual · Google Meet
- Register by 13 Nov 2026, 06:32 AM
99 iSure Coins
Speakers
Dimpu Sarath Kumar + 2 more
Verified certificate: After the masterclass is completed, download an Intern Stump certificate with the skills you achieved and a QR code anyone can verify.
How This Masterclass Works
Three simple steps - reserve your seat, learn live from the experts and walk away with a verified certificate.
Step 1: Register & Reserve
Reserve your seat for ₹198 - pay online or use your iSure Coins. Intern Stump members join free. You get an instant confirmation email.
What You'll Gain:
- Instant seat confirmation by email
- Saved in My Masterclasses
- Free with Intern Stump membership
Step 2: Attend Live with the Experts
Open My Masterclasses on 14 Nov 2026 - the joining link appears 15 minutes before the start.
What You'll Gain:
- Live session with 3 expert speakers
- 3-day agenda · 15 sessions
- 9 tools and techniques
Step 3: Get Your Certificate
Once the masterclass is marked completed, download your verified certificate from My Masterclasses.
What You'll Gain:
- Certificate with the skills achieved
- QR code anyone can verify
- Download as PDF anytime
How we designed our Product?
Every masterclass is a focused, expert-led live experience - planned day by day, built around practical skills and finished with a verified certificate.
Industry Expert Speakers
Learn from 3 industry experts who work on these problems every day.
Live Online Session
Join from anywhere - the joining link appears in My Masterclasses 15 minutes before the start.
Hands-on Practice
Work with 9 tools and techniques the speakers use on real projects.
Clear Prerequisites
Eligibility and requirements are listed upfront, so you know exactly who it is for and what to keep ready.
Save & Plan Ahead
Bookmark masterclasses you like or add them to your cart and register when you are ready.
Hosted by Intern Stump
Every masterclass is reviewed and published by the Intern Stump team before registrations open.
Verified Certificate
Every certificate lists the skills you achieved in this masterclass and carries a QR code anyone can verify.
Day-wise Agenda
Every session has a fixed time slot, a clear topic and the skills it builds - so you know exactly what you will learn and when.
Pay with iSure Coins
Reserve your seat with iSure Coins in one tap. Intern Stump members join every masterclass free.
Seat price
₹198
Limited Seats
Seats are capped so every learner can ask questions and get answers from the speakers.
Career-Ready Skills
32 skills tagged to this masterclass - the same skills printed on your certificate.
My Masterclasses
Your seat, joining details and certificate live in one place - with an instant confirmation email when you register.
FAQs Answered
8 common questions about timings, joining and certificates - answered on this page.
Verify Anywhere
Recruiters and colleges can check your certificate on the Intern Stump verify page or by scanning its QR code.
Included in Membership
Intern Stump members join every masterclass free, along with every AI career tool.
Talk to a Consultant
Questions before you register? Our team answers on WhatsApp and email.
Eligibility & Requirements
Check who this masterclass is designed for and what to keep ready.
Who can join
- Students who want a practical start in data analysis
- Freshers preparing for analyst or business roles
- Working professionals who report on data regularly
- Anyone moving from Excel towards PowerBI
What you need
- A laptop or desktop with a stable internet connection
- Microsoft Excel installed on your device
- PowerBI Desktop installed, which runs on Windows
- No prior analysis experience needed, only curiosity
Skills You Will Gain
These skills are printed on your certificate after the masterclass.
What You Will Learn
A day-by-day schedule - every session lists its time, topic and the skills you will practise, taught live by the experts.
3
Days
15
Sessions
13.3
Total hours
29
Skills
Open a day to see its schedule.
01 Day 1 · Sat, 14 Nov 2026 Excel Foundations for Analysis 5 sessions 11:30 AM – 04:00 PM 4.5 hrs 10 skills
-
111:30 AM – 12:15 PM
Understanding data and analysis workflow
Learn how analysts frame questions, collect data and plan their work.
Analysis workflow Data basics -
212:15 PM – 01:15 PM
Cleaning and preparing messy data
Fix duplicates, blanks, formats and inconsistent text using practical Excel techniques.
Data cleaning Data validation -
301:15 PM – 02:15 PM
Essential formulas and lookups
Use logical, text and lookup functions to enrich and calculate data.
Excel formulas Lookup functions -
402:15 PM – 03:15 PM
Pivot tables and pivot charts
Summarise large datasets quickly and spot patterns with pivot reports.
Pivot tables Pivot charts -
503:15 PM – 04:00 PM
Highlighting insights with formatting
Apply conditional formatting and simple charts to make findings clear.
Conditional formatting Charts
02 Day 2 · Sun, 15 Nov 2026 PowerBI Data Modelling Essentials 5 sessions 11:30 AM – 04:00 PM 4.5 hrs 10 skills
-
111:30 AM – 12:15 PM
Getting started with PowerBI Desktop
Tour the interface and import data from Excel and other sources.
PowerBI interface Data import -
212:15 PM – 01:15 PM
Transforming data with Power Query
Clean, merge and reshape data using repeatable query steps.
Power Query Data transformation -
301:15 PM – 02:15 PM
Building a data model
Connect tables with relationships and understand fact and dimension tables.
Data modelling Relationships -
402:15 PM – 03:15 PM
Introduction to DAX measures
Write simple calculated columns and measures for totals and ratios.
DAX basics Measures -
503:15 PM – 04:00 PM
Time-based analysis in PowerBI
Compare periods and trends using a date table and basic time functions.
Date table Trend analysis
03 Day 3 · Mon, 16 Nov 2026 Dashboards and Storytelling 5 sessions 11:30 AM – 03:45 PM 4.3 hrs 10 skills
-
111:30 AM – 12:15 PM
Choosing the right visuals
Match charts, tables and cards to the question you want answered.
Visual selection Charts -
212:15 PM – 01:30 PM
Designing an interactive dashboard
Build report pages with slicers, filters and clear layout principles.
Dashboard design Slicers -
301:30 PM – 02:15 PM
Drill-downs and interactivity
Add tooltips, drill-through and cross-filtering for deeper exploration.
Drill-through Interactivity -
402:15 PM – 02:45 PM
Publishing and sharing reports
Understand export options, sharing basics and keeping reports refreshed.
Publishing Report sharing -
502:45 PM – 03:45 PM
Presenting insights and portfolio tips
Turn your dashboard into a story and prepare it for interviews.
Data storytelling Portfolio
Everything about Data Analysis using PowerBI and Excel in one PDF
Full curriculum, fees, experts, FAQs, contact and demo details - free to download, no login needed.
Meet Your SMEs
Industry professionals who lead this masterclass live and share real-world knowledge and practical experience.
SME Board Member
Meet Dimpu Sarath Kumar, Founder & CEO of Intern Stump, empowering the next generation through educational innovation and research
SME Board Member
Steering SME partnership strategies, platform growth models, and institutional business expansion initiatives.
SME Board Member
Computer Science professional specializing in AI, software development, education, and UI/UX consulting.
Tools and Techniques You Will Learn
Industry-standard tools, frameworks and methods used live in this masterclass - with practical exposure to how professionals apply them.
Microsoft Excel
Used to clean data, apply formulas and prepare datasets for analysis.
PowerBI Desktop
Main tool for modelling data and building interactive dashboards in the session.
Power Query
Used to import, clean and reshape data with repeatable transformation steps.
Pivot Tables
Used to summarise large datasets and explore patterns in Excel quickly.
XLOOKUP and VLOOKUP
Used to match records and bring related values across different tables.
DAX Measures
Used to calculate totals, ratios and time comparisons inside PowerBI models.
Data Modelling
Technique for linking fact and dimension tables through clear relationships.
Conditional Formatting
Used to highlight outliers, thresholds and trends directly within worksheets.
Dashboard Slicers
Used to let viewers filter report visuals interactively with a click.
Data Analysis using PowerBI and Excel
Reserve your seat for this virtual masterclass on 14 Nov 2026.
Session Highlights & Details
Everything about the live session, the agenda, the speakers and the certificate included with your registration.
Sat, 14 Nov 2026 · 06:32 AM – 16 Nov 2026, 06:32 AM
Duration: 3 days
Virtual · Google Meet
Registered learners get the joining link in My Masterclasses 15 minutes before the start.
3-day agenda · 15 sessions · 13.3 hrs live
Excel Foundations for Analysis · PowerBI Data Modelling Essentials · Dashboards and Storytelling
32 career-ready skills
Data cleaning Excel formulas Lookup functions Pivot tables Pivot charts Conditional formatting +26 moreDimpu Sarath Kumar, Venkata Ravali, Harshavardhan Kumar
Learn live from verified industry experts.
Questions about joining, fees or the certificate?
Read the FAQs or talk to our consultant.
Inclusive of 18% GST · pay online
or use iSure Coins (99 cover it all)
Free with Membership
- Live virtual session with 3 expert speakers (3 days)
- 3-day agenda covering 29 skills
- 9 tools and techniques
- Verified certificate with the skills achieved + QR verification
- Joining link in My Masterclasses 15 minutes before the start
-
Pay online or with iSure Coins - free with an Intern Stump membership
FAQs and Talk to our Consultant
Answers about joining, fees, registration and the certificate - or connect directly with an academic consultant.
Frequently Asked Questions
Click any question to view the answer.
Talk to our Consultant
Get personalized academic & career guidance.
Data Analysis using PowerBI and Excel
Sat, 14 Nov 2026 · 06:32 AM – 16 Nov 2026, 06:32 AM · Virtual · ₹198 (pay online or with iSure Coins, free for members)
Sample Masterclass Certificate
Your name, LMS ID and certificate number appear on the certificate you earn.
