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
Related Training
More Power Bi Courses
POWER BI · 1 Day
Microsoft Power BI Desktop DAX
Optimise speed and efficiency using DAX formula language, basic/advanced functions, variables, calculated tables, and parameter tables.
View Full Syllabus
→
POWER BI · 2 Days
Microsoft Power BI - DAX+
Comprehensive 2-day DAX mastery for experienced Power BI users. Covers the complete DAX formula language, advanced filter context, time-intelligence, performance tuning, dataflows, incremental refresh, and DAX Studio testing.
View Full Syllabus
→
EXCEL · 1 Day
Microsoft Excel Introduction
Master workbook navigation, efficient data handling, and essential formulas. Create professional-looking spreadsheets, design clear charts, and produce polished print-ready reports.
View Full Syllabus
→