Automation Using Power Query
June
04
2026
(Thursday)
Time
10:00 AM PDT | 01:00 PM EDT
Duration: 90 Minutes
33 Days Left To REGISTER
Id: 212237
Duration: 90 Minutes
33 Days Left To REGISTER
Id: 212237
Instructor
Jai Malhotra
Jai Malhotra
Overview
Power Query enables you to build repeatable data preparation steps once and refresh them anytime-turning manual weekly work into automated workflows.
Why you should Attend
- Save hours every week by automating repetitive import and cleanup tasks
- Reduce errors caused by manual copy-paste and ad-hoc formula fixes
- Build refresh-ready pipelines for monthly MIS, dashboards, and reconciliations
- Standardize data processing steps across teams for consistent reporting
- Learn best practices to maintain, document, and troubleshoot queries
Areas Covered in the Session
- Automated data import
- Refresh strategy
- Parameterization basics
- Append/merge automation
- Scheduled refresh concepts
- Error handling
Who Will Benefit
- MIS/Reporting Teams
- Business & Data Analysts
- Finance/Operations Professionals
- Excel/Power BI users handling recurring datasets
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)