About this Event
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 Wednesday 25 and Thursday 26 March 2026.
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.
If any of the courses you wish to attend are full or you cannot make the date, please let us know so that we can register your interest and let you know of future opportunities or add your name to a reserve list. You can contact the team on [email protected] or telephone 01284 716246.
Please note we run all our courses based on a minimum number of participants.
In the event of cancellation by the client not less than 10 working days before the course, the client will be entitled to a refund of 80% of the course fee (20% will be deducted for administration costs). A cancellation within 10 days of commencement will result in no refund to the client
Event Venue & Nearby Stays
University and Professional Development Centre, 73 Western Way, Bury St Edmunds, United Kingdom
GBP 325.00
