Excel · Power Query · Power BI
Enterprise Data Pipelines: Power Query to Power BI
Prepare a reviewable data pipeline from Excel Tables through Power BI handoff controls.
This class moves from structured Excel Tables into Power Query, Power Pivot, Power BI, mapping, refresh, and handoff controls. Participants use supplied source packets to clean, connect, model, visualize, map, refresh, and document outputs without turning the course into unsupported live database work.
Duration2 Days
Who this course is forGovernment analysts, data professionals, and teams moving from spreadsheet reporting into Power Query, Power Pivot, Power BI, mapping, refresh controls, and handoff packages.
What you will learn
- Convert raw ranges into structured tables with reliable headers, filters, and refresh-ready fields.
- Import, clean, reshape, and name repeatable Power Query steps, then check the resulting table.
- Connect tables with relationships and measures, then test a model-backed summary against source expectations.
- Build a focused report page from cleaned data, use filters deliberately, and check every visible number.
- Prepare anonymized location data, build a map, and assess geography, small-count, precision, and sharing risks.
- Refresh, validate, export, and document a report package so another person can operate it safely.
Course modules
- Excel Tables
- Power Query Cleaning
- Power Pivot Model
- Power BI Report
- Power Maps
- Refresh and Handoff