Prepare and transform data with Power Query
Training duration18 hours across 8 practical modules
DeliveryFace-to-face or virtual instructor-led
ProgrammeProfessional certification
Course summary
Build expertise that creates measurable value.
A practical introduction to data analysis and business intelligence. Participants learn to import and transform data, build robust models, create DAX calculations, develop interactive reports and publish insights with Microsoft Power BI.
Create business-ready data models
Build DAX measures and KPIs
Design effective reports and dashboards
Add filters, drill-through and analytical features
Publish and collaborate through Power BI Service
Entry qualifications
Is this programme right for you?
- Basic computer and internet skills
- Familiarity with common office tools
- No prior programming or AI experience required
Learner profile
Designed for ambitious professionals.
- Managers and business leaders
- Finance and accounting professionals
- Sales and marketing teams
- HR and operations professionals
- Business analysts
- Students and aspiring data professionals
Course content
A practical, structured learning journey.
Each module turns internationally relevant frameworks into skills you can apply in the workplace.
Module 01↗
Power BI Fundamentals & Data Connectivity
- Power BI Desktop and Service
- Excel, CSV and other sources
- Report-development workflow
Module 02↗
Power Query - Data Preparation
- Importing and profiling
- Cleaning messy data
- Combining files
- Conditional transformations
Module 03↗
Data Modeling & Relationships
- Fact and dimension tables
- Cardinality
- Cross-filter direction
- Star-schema concepts
Module 04↗
DAX & Business Calculations
- Measures and calculated columns
- CALCULATE and FILTER
- Time intelligence
- KPI measures
Module 05↗
Data Visualization & Reporting
- Charts and KPIs
- Tables and matrices
- Conditional formatting
- Maps and Top-N
Module 06↗
Interactive Reports & Analytics
- Slicers and filters
- Drill-through
- Bookmarks
- Decomposition Tree and Q&A
Module 07↗
Dashboard Development - Capstone
- Report layout
- Visual hierarchy
- Navigation
- Interactive Business Performance Dashboard
Module 08↗
Power BI Service & Collaboration
- Publishing reports
- Workspaces and sharing
- Mobile access
- Report subscriptions
Learning outcomes
Graduate ready to perform with confidence.
- 01Connect and transform business data
- 02Build effective data models
- 03Create DAX measures and KPIs
- 04Design professional interactive reports
- 05Develop a management-ready dashboard
- 06Publish and share insights through Power BI Service
Take the next step
Ready to advance your career?
Speak with an Entrepôt programme advisor about upcoming cohorts, delivery options and enrolment.