Data Analysis Using Power Pivot
June
11
2026
(Thursday)
Time
10:00 AM PDT | 01:00 PM EDT
Duration: 90 Minutes
40 Days Left To REGISTER
Id: 212238
Duration: 90 Minutes
40 Days Left To REGISTER
Id: 212238
Instructor
Jai Malhotra
Jai Malhotra
Overview
Power Pivot is Excel's data modeling engine for handling large datasets, creating relationships, and writing DAX measures for advanced analysis.
Why you should Attend
- Struggling with huge files and slow formulas? Power Pivot is built for scale
- Combine multiple tables and create relationships like a mini-database inside Excel
- Build reusable KPIs and measures instead of repeating formulas on every sheet
- Learn the foundation of DAX needed for Power BI and modern analytics roles
- Create faster, cleaner dashboards and PivotTables powered by a data model
Areas Covered in the Session
- Data Model basics
- Relationships
- Star schema concepts
- Measures vs calculated columns
- DAX introduction
- Power Pivot-enabled PivotTables
Who Will Benefit
- Analysts Handling large datasets
- Finance Teams Building KPIs
- MIS/Reporting Professionals
- Excel users Transitioning to Power BI
Speaker Profile
Jai Malhotra is Microsoft Certified Professional who has 11 years of rich training experience as Corporate Trainer. The Instructor has conducted more than 900 training sessions of Corporate Sessions and upskilled work forces in the domain of Microsoft Excel, Power BI, SQL, Power Point, ChatGPT and Copilot. He got opportunity to serve Companies like Deloitte, NTT Data, Hafel, Virtusa, SBI Cards, Tata AIG, Maruti Suzuki, Max Life Insurance, Volvo Eicher, XL-Catlin, L&T, M3M, WSP, Panasonic, PwC, Paisa Bazaar etc.
Access Recorded Version
One Attendee / Group Attendees
Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)