Course · Power BI
Power Query & Data Preparation
Turn messy files and system extracts into clean, repeatable data with Power Query, so the report never needs manual fixing.
- Level
- Beginner to intermediate
- Format
- Live online, small group
- Length
- 9 hours, 3 sessions
- Price
- $119
Price and enrolment
$119 per learner
- 3 sessions × 3 hours (9 hours)
- Live online, groups of up to 12
- Hands-on labs and course materials
- Q&A with the instructor
We confirm the next cohort dates and send an invoice. Your seat is held once payment is received. Prices in US dollars, excluding any local taxes.
Save with a path
This course is part of the Power BI Analyst path: $449 for the full path.
See Learning PathsWho it is for
This course is for
- Power BI and Excel users who spend time cleaning data
- Analysts receiving files from many systems
- Finance teams consolidating monthly extracts
Syllabus
What each session covers
Session 1 · Reliable imports
- Connecting to files, folders and databases
- Promoting headers, types and locale issues
- Applied steps you can still read in six months
Session 2 · Reshaping data
- Unpivot, pivot and grouping
- Merges and appends without duplicates
- Handling nulls, errors and unexpected values
Session 3 · Repeatable pipelines
- Combining a folder of monthly files
- Parameters and simple functions
- Query folding and refresh performance basics
Hands-on labs
What you will build
- Combine twelve monthly files into one table
- Fix a source with mixed date formats
- Build a reusable cleaning function
- Validate row counts and totals after each step
Before you join
Prerequisites and setup
- Level
- Beginner to intermediate
- Prerequisite
- Basic Power BI or Excel Power Query use
- You need
- Power BI Desktop installed
Outcomes
After the course you should be able to
- Build repeatable preparation steps
- Combine and reshape data confidently
- Spot and handle data-quality problems early
Courses build practical skills. They do not promise certification passes, job placement, salary increases or expert-level mastery.
Related courses
Continue learning
Power BI Fundamentals
The full Power BI workflow for new users: connect data, clean it, model it, write first measures and publish a useful report.
$149 per learner
Data Modelling & DAX
The skills behind trustworthy numbers: star-schema models, relationships, filter context and DAX measures that give the same answer everywhere.
$199 per learner
Advanced DAX & Performance
For people who already write DAX: advanced patterns, calculation groups and finding out why a report is slow.
$199 per learner
Dashboard Design & Storytelling
Design reports people actually read: layout, visual choice, navigation and how to lead a reader to a decision.
$89 per learner
Power BI Service, Security & Governance
Run Power BI as a reliable team environment: workspaces, apps, refresh, gateways, row-level security and ownership.
$119 per learner
Need it built? · Datazeb Consulting
Want Datazeb to build or fix your Power BI?
The trainers deliver Power BI projects for clients. If you need a model, dashboard or a governed environment built for you, the consulting team can help.
datazeb.com
Reserve your seat on Power Query & Data Preparation
Send the short form; we confirm the next cohort dates and send an invoice.