-
Course Overview
There are three parts to creating a Power BI Desktop report, all of which are covered by this two-day course. Firstly, you’ll learn how to get data from all manner of different sources, using Query Editor to manipulate the results; secondly, you’ll learn how to create, format and use visualisations (tables, charts, gauges, maps and many more); and thirdly, you’ll learn how to create calculated columns and measures using basic DAX language. You’ll also learn how to use Power BI Web, and get an overview of Power BI Mobile.
-
Course Details
Obtaining Data
- Different data sources: Files, Databases and the Web
- Changing the Data Source
Transforming Data
- Removing Columns/Rows
- Data Type Changes
- Filters
- Grouping
- Split
- Duplicate
- Combine: Append and Merge Queries
- Pivot/Unpivot
- Columns: Add Column, Custom Function, Conditional Column, Index Column
Relationships
- Model View and Relationship management
- Join Kinds
- Working with Related Tables
- Hierarchies
Introduction to DAX Formula & Measures
- Formula
- Measures
- Quick Measure
Date Tables and Time Intelligence
- Creating Date Tables
- Time Intelligence Formulas and Measures
Visualisations
- Table
- Matrix
- Charts
- Maps
- KPI (Key Performance Indicator)
- Conditional Formatting
- Spatial Intelligence
Visualisation Manipulation
- Filter: Basic and Advanced
- Top 10
- Slicer
- Drill Through
Publishing/Sharing Reports
- Publishing to the Power BI Service on the web
- Exporting to PDF
-
Next Running Dates
Virtual Live Classroom
- 27th – 28th August 2026
- 29th – 30th October 2026
Merseyside Classroom- 16th – 17th November 2026
-
FAQs
Who’s it for?
Existing users of Microsoft Power Bi who wish to learn how to use Power Bi effectively
What are the Course Requirements?
Delegates will need to have a good working knowledge.
What will be the Career Path?
- Data Analysts
- Project Manager
Are any Financial Options Provided?
- 0% Interest Free payments available.
RewardInformal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor. Course Completion Certificate will be awarded on successful completion of the course.
What is provided with the Course?
- Course Material
- Aftercare Course Support