This Microsoft Power BI Desktop training course is aimed at anyone looking to use this powerful, flexible, and highly accessible tool to connect with and shape the world of data, build robust models, and craft well-structured reports, which can then be seamlessly shared through Microsoft Power BI Service with users.
Delegates require a good knowledge of MS Excel and access to Office 365
Learn to use Power BI Desktop to create queries, data connections, and reports that can easily be shared with others. Through Power BI Desktop learn to integrate proven Microsoft technologies such as the Query engine, data modelling, and visualisations. Discover how to harness Power BI Service to share these connections, models and reports in accessible ways for users to view and interact with on all kinds of devices.
2 day programme to include the following:
Introduction to Power BI
- What is Power BI?
- The Power BI service
- Power BI Desktop
- Reports and Dashboards
Data Sources
- Connecting to Files
- Importing Excel Files
- Publishing to Power BI from Excel
- Updating Files in Power BI
- Data Refresh
Shaping and Combining Data
- The Query Editor
- Applied Steps
- Advanced Editor
- Shaping Data
- Formatting Data
- Transforming Data
- Combining Data
- Merging Data
Modelling Data
- What are Relationships?
- Viewing Relationships
- Creating Relationships
- Cardinality
- Cross Filter Direction
- What is DAX?
- Syntax
- Functions
- Context
- Calculated Columns
- Calculated Tables
- Measures
Interactive Data Visualisations
- Power BI Reports: Page Layout and Formatting
- Multiple Visualisations
- Creating Charts
- Using Geographic Data
- Service Settings
- Desktop Settings
This course will be run at West Suffolk College University and Professional Development Centre on Thursday 27 and Friday 28 November 2025.
To book and pay by credit/debit card please click on the 'get tickets' button shown above.
If you are an Employer and wish to pay via invoice please contact us to receive further instructions.
