Power BI Training
Introduction to PowerPivot Training Course
£695 + VAT for most venues (£850 + VAT for London)
2 days
Excel can do so much more than simple pivot tables! This two-day course will show you how to:
- create simple, elegant data models in PowerPivot;
- use these data models to create pivot tables based on multiple tables;
- use queries to build queries to extract, transform and load data (this used to be called Power Query, but is now integrated in Excel);
- start to use the DAX language for more in-depth analysis of data;
- analyse time series data ("compare this month's sales with the same period in the previous quarter");
- create hierarchies, and display them in pivot tables;
- create and display KPIs in Excel;
- understand what Power BI Desktop is, and how it is the same in many ways as PowerPivot / Power Query;
- create visualisations in Power BI Desktop (tables, charts and matrices);
- understand how to publish Power BI Desktop reports to the cloud, and pin tiles to dashboards.
Note that you'll need to be using Excel 2016 (or 2013) Professional Plus or Office 365 ProPlus to be able to use the Power BI (Power Business Intelligence) features within Excel.
Course details
Locations:London, Manchester
Next course:Thu 14 March 2019
Time:09.30-16.30
Course Contents
PowerPivot data models
Importing SQL Server tables- Filtering rows/columns
- Data and diagram view
- Hiding from client view
- Relationships
Pivot tables using PowerPivot
- Drill-down vs Quick Explore
- Slicers and timelines
- Controlling what you see
Using Excel tables
- Creating and naming tables
- Adding to data models
Using other data sources
- Importing Access and Excel
- Pasting from the clipboard
Getting data (Power Query)
- Querying databases
- Web pages
Transforming data (Power Query)
- Splitting columns
- Merging and inserting columns
- Other transforms
Calculated columns
- Creating calculated columns
- Using the RELATED function
- BLANK and SWITCH
Measures
- The all-important query context
- Implicit calculated fields
- AutoSum fields
- Creating in Excel and PowerPivot
DAX basics
- The DAX Studio add-in
- Calculating ratios
- Aggregate X functions
The CALCULATE function
- Replacing filters
- Using ALL
- Using VALUES to edit filters
If time
More advanced DAX functions
- Using FILTER to filter tables
- Ranking
- The EARLIER function
Calendars
- Creating in Excel or SQL
- Linking to calendars
- Sorting months
- Multiple date tables
Date functions
- Period to date
- Fiscal year calculations
- Parallel periods
- Semi-additive measures
Hierarchies
- Creating hierarchies
- Pros and cons
KPIs
- Relative KPIs
- Absolute KPIs
Perspectives
- Creating perspectives
- Viewing parts of a model
Power View
- What Power View is
- Why not to use it!
Power BI Desktop overview
- Importing data
- Visualisations
- Simple drill-down
- Publishing dashboards
If time
Power BI Desktop maps
- Localising data
- Types of map
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 492 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Richard Harker (Thales UK Ltd )
John Nairn (Hall and Woodhouse Ltd)
Alexandra Black (Global Aerospace)
Claire Jones (Swiss Reinsurance Management Ltd)
Rainer Pratl (CFA Institute)
There are lots more where these came from (or just refresh this page to change the quotes shown).
This course uses Excel 2016 Professional Plus or Office 365 ProPlus.
Scheduled PowerPivot / Excel Power BI training dates
Here are the PowerPivot / Excel Power BI courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Thu/Fri 14-15 March 2019 | 2 | London | £850 | Book places |
| Tue/Wed 09-10 April 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 30-31 May 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 18-19 July 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 24-25 September 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 29-30 October 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 28-29 November 2019 | 2 | Manchester | £695 | Book places |
| Date(s) | Venue |
|---|---|
| 14/03 | London |
| 09/04 | Manchester |
| 30/05 | Manchester |
| 18/07 | Manchester |
| 24/09 | Manchester |
| 29/10 | Manchester |
| 28/11 | 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).
