All courses
Power Query
Automate messy data preparation with repeatable, refreshable ETL workflows.
Duration
1 day (7 hours)
Fee
KES 15,500
per participant
About this course
Tired of cleaning the same spreadsheet every week? Power Query lets you record data preparation steps once and refresh them with a single click. This focused, one-day course teaches you how to import, clean and combine data from any source — files, folders, databases or the web.
Class goals
- Import data from files, folders, databases and the web
- Clean and transform data with repeatable steps
- Merge and append queries to combine datasets
- Parameterise queries and build reusable functions
- Set up reliable refresh strategies
Course outline
- 1Importing from files, folders & web
- 2Cleaning & transforming data
- 3Merging and appending queries
- 4Parameters & functions
- 5Refresh strategies
Delivery
Live online
Interactive virtual classroom from anywhere.
In person
At our venue, or at your office for corporate groups.