Data Sanitization / Cleaning / Transformation Using Power Query
May
20
2026
(Wednesday)
Time
10:00 AM PDT | 01:00 PM EDT
Duration: 90 Minutes
19 Days Left To REGISTER
Id: 212235
Duration: 90 Minutes
19 Days Left To REGISTER
Id: 212235
Instructor
Jai Malhotra
Jai Malhotra
Overview
Still cleaning data manually? One error can derail your insights.
Reports breaking every time data changes? That is a process risk.
Relying on formulas alone limits speed, accuracy, and scalability.
Manual data preparation increases rework and missed deadlines.
Ignoring Power Query means underusing Excel and Power BI's true power.
Inefficient data transformation slows decision-making.
Falling behind on modern data tools can impact professional relevance.
Areas Covered in the Session
- Split Column
- Merge Query with 6 Joins
- Append Query
- Fuzzy Match
Who Will Benefit
- Data Analyst
- Business Analyst
- CFO
- Team Leaders
- Data Professionals
- Banking Professionals
- Sales Professionals
- Finance Professionals etc.
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)