Microsoft Office training -  PowerPivot / Excel Power BI

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 for PowerPivot / Excel Power BI coursesLocations:Manchester, London
  • Next PowerPivot / Excel Power BI course locationNext course:Thu 16 August 2018
  • PowerPivot / Excel Power BI course timesTime:09.30-16.30

Course Contents

PowerPivot data models

  • Training topicImporting SQL Server tables
  • Training topicFiltering rows/columns
  • Training topicData and diagram view
  • Training topicHiding from client view
  • Training topicRelationships

Pivot tables using PowerPivot

  • Training topicDrill-down vs Quick Explore
  • Training topicSlicers and timelines
  • Training topicControlling what you see

Using Excel tables

  • Training topicCreating and naming tables
  • Training topicAdding to data models

Using other data sources

  • Training topicImporting Access and Excel
  • Training topicImporting cubes
  • Training topicPasting from the clipboard

Getting data (Power Query)

  • Training topicQuerying databases
  • Training topicWeb pages and XML files

Transforming data (Power Query)

  • Training topicSplitting columns
  • Training topicMerging and inserting columns
  • Training topicOther transforms

Calculated columns

  • Training topicCreating calculated columns
  • Training topicUsing the RELATED function
  • Training topicBLANK and SWITCH

Measures

  • Training topicThe all-important query context
  • Training topicImplicit calculated fields
  • Training topicAutoSum fields
  • Training topicCreating in Excel and PowerPivot

DAX basics

  • Training topicThe DAX Studio add-in
  • Training topicCalculating ratios
  • Training topicAggregate X functions

The CALCULATE function

  • Training topicReplacing filters
  • Training topicUsing ALL
  • Training topicUsing VALUES to edit filters

Covered if time allows If time

More advanced DAX functions

  • Training topicUsing FILTER to filter tables
  • Training topicRanking
  • Training topicThe EARLIER function

Calendars

  • Training topicCreating in Excel or SQL
  • Training topicLinking to calendars
  • Training topicSorting months
  • Training topicMultiple date tables

Date functions

  • Training topicPeriod to date
  • Training topicFiscal year calculations
  • Training topicParallel periods
  • Training topicSemi-additive measures

Hierarchies

  • Training topicCreating hierarchies
  • Training topicPros and cons

KPIs

  • Training topicRelative KPIs
  • Training topicAbsolute KPIs

Perspectives

  • Training topicCreating perspectives
  • Training topicViewing parts of a model

Power View

  • Training topicWhat Power View is
  • Training topicWhy not to use it!

Power BI Desktop overview

  • Training topicImporting data
  • Training topicVisualisations
  • Training topicSimple drill-down
  • Training topicPublishing dashboards

Covered if time allows If time

Power BI Desktop maps

  • Training topicLocalising data
  • Training topicTypes of map

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Course delivered in a very easy to understand manner, good content and manuals."

Siobhan McNulty (Hewlett Packard)

"We had an excellent trainer. Thank you."

Fabio Priori (Antares Underwriting Services Limited)

"Course admin good with helpful maps and hotel suggestions appreciated. Love the course manual - good details and much better materials than other courses I've been on. Useful materials and USB stick to help consolidate. I was impressed with the resources on the Wise Owl website - in particular the videos are excellent."

Mary-Ann Forrest (Cotswold District Council)

"Excellent course."

Andrew Critchley (Global Aerospace)

"Very good content and delivery. Excellent!"

Bryan Skinner (KPMG LLP)

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 16-17 August 2018 2 £695 Book places
Thu/Fri 04-05 October 2018 2 £850 Book places
Mon/Tue 08-09 October 2018 2 £695 Book places
Tue/Wed 13-14 November 2018 2 £850 Book places
Tue/Wed 20-21 November 2018 2 £695 Book places
Date(s) Venue
16/08
04/10
08/10
13/11
20/11

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).

Related Courses

Introduction to Power BI

Introduction

2 day course

SSAS - Tabular Model

Introduction

2 day course

DAX

Intermediate

2 day course

Other Power BI Tools training resources

Power BI exercises

Power BI exercises

View Power BI Desktop or PowerPivot exercises

Power BI videos

Power BI videos

View PowerPivot videos

Power BI skills assessment

Power BI skills assessment

View Power BI skills skills assessment tests

Power BI blogs

Power BI blogs

View Power BI - Excel or Power BI blogs

This page has 0 threads Add post