Data Transformation & Cleansing Using Power Query (ETL Concepts)
Time:
10:00 AM PDT | 01:00 PM EDT
Duration:
90 Minutes
Webinar Id:
54905
More Trainings by this Expert
Price Details
Live: One Dial-in One Attendee
Corporate Live: Any number of participants
Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Overview:
This webinar will train participants on Power Query-based Data Transformation & Cleansing, using ETL concepts commonly used in:
- MIS Reporting
- Data Analytics
- Power BI reporting pipelines
Participants will learn how to:
- import data from multiple sources
- clean and standardize datasets
- transform data for reporting readiness
- merge/append files automatically
- build a refreshable ETL workflow
The key outcome is:
- Stop manual cleaning
- Build repeatable transformations
- Refresh and generate clean data instantly
Why should you Attend:
- Are you cleaning the same Excel data every day or every month manually?
- Does raw data come in different formats from different teams/vendors?
- Do your reports get delayed due to data cleaning?
- Do you make mistakes while copy-pasting and formatting reports?
- Do you want to automate your cleaning process with one Refresh button?
- Do you want to learn ETL concepts used in Data Analytics & BI tools?
Areas Covered in the Session:
Understanding the ETL process
- Extract - Transform - Load (Power Query mindset)
Power Query Overview:
- Where Power Query is used (Excel + Power BI)
- Query Editor interface
- Applied Steps (how automation happens)
Importing data from different sources:
- Excel, CSV, Text
- Folder (combine multiple files)
- Tables, ranges
Data cleansing operations:
- remove blanks / nulls
- remove duplicates
- trim / clean text
- fix inconsistent naming
- replace values
- split columns / merge columns
- change data types correctly
Data transformation techniques:
- add conditional columns
- custom columns
- extract characters / numbers
- date transformation
- pivot/unpivot
Data shaping for reporting:
- normalize raw datasets
- set proper headers
- promote/demote headers
Merge & Append queries
- Merge (like VLOOKUP/XLOOKUP but professional)
- Append (combine multiple sheets/files)
Creating refresh-ready pipelines:
- refresh all
- auto update when new file comes
Query loading options:
- load to worksheet
- load to data model (Power Pivot / Power BI)
Who Will Benefit:
- MIS Executives / MIS Analysts
- Data Analysts / Reporting Analysts
- HR & Payroll professionals handling reports
- Finance & Accounts teams working on reconciliations
- Sales operations / sales reporting teams
- Operations & supply chain teams
- Business analysts
- Excel users upgrading to Power BI / analytics
Speaker Profile
Hirdesh Bhardwaj is the Founder of Webs Jyoti and a seasoned corporate trainer with over 17 years of experience in Excel, Data Analysis, VBA, SQL, and BI tools. He has trained 20,000+ professionals across 130+ companies and authored books used by more than 25 universities. His training approach focuses on clarity, real-world application, and practical problem-solving.
