Classroom Training
Introduction to Power BI
Classroom training course - online version also available
£695 + VAT for most venues (£795 + VAT for London)
2 days
Things that you'll learn on this two-day course include:
- how to load data from all manner of different sources, and how to build a data model;
- how to use Query Editor to transform data as you load it;
- how to create, format and use visualisations (tables, charts, gauges, maps and many more);
- how to create calculated columns using the basic DAX language; and
- how to work with calendars in Power BI.
You'll also learn how to publish reports to Power BI Service.
Course details
Possible locations:London, Manchester, Online
Next classroom course:Mon 25 January 2021
Time:10.00-16.30
Course Contents
The contents of this course are as follows:
Basic reports
- Getting data
- Basic visualisations
- Shapes, text boxes and images
Data sources
- SQL Server / databases
- Excel / text files
- Websites and web services
Formatting visualisations
- The formatting panes
- Conditional formatting
Charts
- Working with charts
- Specific chart type issues
- Grouping and binning
Other types of visualisation
- Working with matrices
- Working with cards
Dashboard visualisations
- Gauges
- Single-number visualisations
- KPIs
Query editor
- Filtering rows
- Manipulating columns
- Working with data types
More on query editor
- Creating new columns
- Introducing the M language
Multiple tables
- Relationships
- Filter directions
Filtering data
- Slicers
- Visualisation level filters
Drill-down
- Interactions
- "See records" feature
Drill-through filtering
- Adding drillthrough filters
- Back buttons
Overview of maps
- The types of map
- Geo-location
- Introduction to ArcGIS
Calculated columns
- Adding columns
- IF and SWITCH
- The RELATED function
Publishing reports
- Power BI accounts
- Power BI files (PBIX)
Power BI Service
- Publishing
- Dashboards and tiles
- Sharing reports
App workspaces
- Creating app workspaces
- Publishing apps
Power BI is a standalone application, so there are no pre-requisites for attending this course.
Why Choose Us?
- No more than 5 people per class
- Proper restaurant lunch included
- 505 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Davine Cooke (Manchester Metropolitan University)
Tony Pole (UP Global Sourcing (UK) Ltd)
Edward Wenham (Crown Commercial Service)
Andrew Riley (Cross Keys Homes)
Simon Lyons (The Original Factory Shop)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Scheduled Introduction to Power BI training dates
Here are the classroom Introduction to Power BI courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Mon/Tue 25-26 January 2021 | 2 | Manchester | £695 | Book places |
| Thu/Fri 11-12 February 2021 | 2 | London | £795 | Book places |
| Thu/Fri 25-26 February 2021 | 2 | Manchester | £695 | Book places |
| Mon/Tue 29-30 March 2021 | 2 | Manchester | £695 | Book places |
| Thu/Fri 08-09 April 2021 | 2 | London | £795 | Book places |
| Thu/Fri 20-21 May 2021 | 2 | Manchester | £695 | Book places |
| Mon/Tue 28-29 June 2021 | 2 | Manchester | £695 | Book places |
| Thu/Fri 01-02 July 2021 | 2 | London | £795 | Book places |
| Thu/Fri 12-13 August 2021 | 2 | Manchester | £695 | Book places |
| Date(s) | Venue |
|---|---|
| 25/01 | Manchester |
| 11/02 | London |
| 25/02 | Manchester |
| 29/03 | Manchester |
| 08/04 | London |
| 20/05 | Manchester |
| 28/06 | Manchester |
| 01/07 | London |
| 12/08 | Manchester |
All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power BI training at your offices (we'll even provide and set up the computers).
