PowerPivot / Excel Power BI

Course

Online

£ 695 + VAT

Description

  • Type

    Workshop

  • Level

    Beginner

  • Methodology

    Online

  • Duration

    2 Days

  • Start date

    Different dates available

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 Power Query to build queries to extract, transform and load data;
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 and display KPIs in Excel;
create Power View reports within Excel based on your data models; and
create and show Power Maps (including making videos of trends over time).

Note that you'll need to be using Excel 2013 Professional Plus or Office 365 ProPlus to be able to use the Power BI (Power Business Intelligence) features within Excel.

Important information

Documents

  • Excel PowerPivot-Excel Power BI.pdf

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • PowerPivot data models
  • Pivot tables using PowerPivot
  • Using Excel tables
  • Using other data sources
  • Getting data (Power Query)
  • Transforming data (Power Query)
  • Calculated columns
  • Measures
  • DAX basics
  • The CALCULATE function
  • Calendars
  • Date Functions
  • Hierarchies
  • KPIs
  • Perspectives
  • Power View
  • Power BI Desktop overview

Teachers and trainers (1)

Andrew Gould

Andrew Gould

Senior Trainer

Course programme

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
  • Importing cubes
  • Pasting from the clipboard
Getting data (Power Query)
  • Querying databases
  • Web pages and XML files
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

Additional information

£695 + VAT for most venues (£850 + VAT for London)

PowerPivot / Excel Power BI

£ 695 + VAT