Preparing Data with Power Query
Connecting to, profiling, cleaning and transforming data for Power BI.
MSBA-260 12 lessons planned ▶ Video lessons coming soon
Offered by HSM University · Microsoft Certification Prep
Course content
- 1Data sources and connection modesComing
- 2Import, DirectQuery and Direct LakeComing
- 3Profiling data qualityComing
- 4Cleaning and transforming columnsComing
- 5Merging and appending queriesComing
- 6Pivoting and unpivotingComing
- 7Parameters and functionsComing
- 8Query foldingComing
- 9Dataflows and shared queriesComing
- 10Handling errors and nullsComing
- 11Privacy levels and gatewaysComing
- 12Case study: combining sales files from many storesComing
Requirements
Recommended background. You can start any course at any time.
Description
Connecting to, profiling, cleaning and transforming data for Power BI.