POWER BI · 2 Days

Microsoft Power BI Desktop Foundation

Self-service business intelligence, connecting data sources, Query Editor data shaping, data modeling, visualisations, and publishing reports.

Duration: 2 Days From £550/day (up to 8 learners) 1-to-1 or Groups of up to 8 Learners (Larger by Arrangement) M365 (Desktop & Web) · Office 2021/2024 Certificate · Manuals · 1-Year Support

Complete Course Syllabus

Introduction to Power BI & Data Connections

  • Power BI ecosystem overview (Desktop, Service, Mobile)
  • Connecting to Excel, CSV, databases, web, and folder data sources
  • Navigating Report, Data, and Model views in Power BI Desktop

Query Editor: Cleaning & Transforming Data

  • Using Power Query Editor to filter, sort, and remove rows/columns
  • Cleaning text, number, and date data types
  • Splitting columns, replacing values, and managing Applied Steps and M code

Merging, Appending & Shaping Queries

  • Combining datasets using Merge Queries (Joins) and Append Queries
  • Pivoting and unpivoting columns to normalise data structures
  • Grouping and aggregating data during import

Data Modelling & Relationships

  • Designing a star schema and managing table relationships
  • Understanding cardinality and cross-filter direction
  • Creating calculated columns, hierarchies, and basic DAX measures

Interactive Visualisations, KPIs & Drill-Downs

  • Building bar, line, combo, matrix, table, map, and KPI card visuals
  • Formatting visuals, conditional formatting, and applying report themes
  • Configuring slicers, drill-downs, drill-through pages, and custom tooltips

Publishing to Power BI Service & Dashboards

  • Publishing reports from Power BI Desktop to Power BI Service workspaces
  • Building interactive dashboards by pinning report tiles and Q&A visuals
  • Sharing reports and dashboards securely with colleagues
Copied to Clipboard ✓

Ready to Share