A DataCamp course building the data-preparation skills that separate a tidy report from a messy one. Over about three hours you learn to pivot and unpivot, transpose and append tables, combine data with joins, and write transformations in Power Query. A practical intermediate step for people who already know Power BI basics.
Good for: Levelling up Power BI data preparation with Power Query.
Less suitable if: You are new to Power BI or want DAX and modelling instead.
Skills you'll gain
Power BIPower QueryData transformationJoinsPivotingData cleaning
Is this course right for you?
A good fit if you…
You know Power BI basics
You want cleaner, better-prepared data
You work with messy datasets
Consider something else if you…
You are new to Power BI
You want DAX and modelling
You already master Power Query
Requirements: Power BI basics (DataCamp's Introduction to Power BI is a good precursor).
Realistic time: Around 3 hours.
About this course
Data Transformation in Power BI builds the data-preparation skills that separate a tidy report from a messy one. Over about three hours you learn to (un)pivot, transpose, and append tables, combine data with joins, and write transformations in the M language inside Power Query Editor.
What you'll learn
Pivot, unpivot and transpose tables
Append and combine data sources
Join tables in Power Query
Write transformations in the M language
Clean and reshape messy data
Prepare data for reliable reporting
This course includes
3h
On-demand video
Yes
Certificate
Yes
Mobile access
English
Language
What it costs
DataCamp runs on a subscription — roughly $14/month billed annually (more month-to-month), with the first chapter of each course free to try. A certificate of completion is included with the subscription.
Comparison · LBS
Compare alternatives for Data Transformation in Power BI
Same topic, different options. We surface the trade-offs others hide so you can pick the course that actually fits your time, budget, and goals.