Power BI Training
Introduction to Power BI Training Course
£695 + VAT for most venues (£795 + VAT for London)
2 days
There are three parts to creating a Power BI 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. If you're not sure whether you want to book on this course or on our two-day Excel Power BI tools course, have a look here.
Course details
Locations:Manchester, London
Next course:Tue 05 February 2019
Time:09.30-16.30
Course Contents
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
If time
Calendars
- Creating calendars
- Using multiple calendars
- Working days
Publishing reports
- Power BI accounts
- Power BI files (PBIX)
Power BI Service Overview
- Differences from PBI Desktop
- Workspaces
- Favorites
Using Power BI Service
- Reports and dashboards
- Using tiles
- Pinning to dashboards
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 468 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Sam Wilkinson (Humankind Charity)
Andrew Wilson (Fitinique Ltd)
Chris Chandler (Trafford Housing Trust)
Holly Gregson (Myerscough College)
Sarah Cradick (Signature)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Power BI is a standalone application, so there are no pre-requisites for attending this course.
Scheduled Introduction to Power BI training dates
Here are the Introduction to Power BI courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Tue/Wed 05-06 February 2019 | 2 | London | £795 | Book places |
| Tue/Wed 12-13 February 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 05-06 March 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 19-20 March 2019 | 2 | London | £795 | Book places |
| Tue/Wed 16-17 April 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 16-17 May 2019 | 2 | London | £795 | Book places |
| Tue/Wed 04-05 June 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 04-05 July 2019 | 2 | London | £795 | Book places |
| Tue/Wed 16-17 July 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 20-21 August 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 05-06 September 2019 | 2 | London | £795 | Book places |
| Thu/Fri 26-27 September 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 15-16 October 2019 | 2 | London | £795 | Book places |
| Tue/Wed 12-13 November 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 03-04 December 2019 | 2 | London | £795 | Book places |
| Thu/Fri 12-13 December 2019 | 2 | Manchester | £695 | Book places |
| Date(s) | Venue |
|---|---|
| 05/02 | London |
| 12/02 | Manchester |
| 05/03 | Manchester |
| 19/03 | London |
| 16/04 | Manchester |
| 16/05 | London |
| 04/06 | Manchester |
| 04/07 | London |
| 16/07 | Manchester |
| 20/08 | Manchester |
| 05/09 | London |
| 26/09 | Manchester |
| 15/10 | London |
| 12/11 | Manchester |
| 03/12 | London |
| 12/12 | 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).
