Data Consolidation using Power Query
July
22
2026
(Wednesday)
Time
10:00 AM PDT | 01:00 PM EDT
Duration: 90 Minutes
81 Days Left To REGISTER
Id: 212243
Duration: 90 Minutes
81 Days Left To REGISTER
Id: 212243
Instructor
Jai Malhotra
Jai Malhotra
Overview
Power Query can consolidate multiple files/sheets/folders into one standardized dataset-ideal for monthly MIS when formats are similar but sources are many.
Why you should Attend
- Consolidating multiple files manually leads to errors and missed records
- Folder-based consolidation can update with one click when new files arrive
- Standardize inconsistent formats across teams and branches
- Create a reliable data foundation for PivotTables, dashboards, and Power BI
- Learn common patterns for consolidating files, sheets, and folders effectively
Areas Covered in the Session
- Folder consolidation, combining
- Files/sheets
- Standardizing headers
- Adding metadata
- Refresh strategy
- Building a clean consolidated table
Who Will Benefit
- Reporting & MIS Teams
- Operations Teams
- Finance Teams
- Analysts who Consolidate data from many Sources Regularly
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)