Skip to main content

Remote training Excel Power Pivot: Use more power in Excel

Version: Microsoft 365
Learning format: Remote via Teams
Duration: 1 day (09:00-16:00)
Price for this remote Excel training (max 12p): € 1050 VAT excl. / Terms for this remote training.

Request a quote

Description

Are you already juggling with PivotTables in Excel? Then you will undoubtedly go wild with PowerPivot. In this session you will learn how to effortlessly merge an Excel list with an Access database. Or with a table originating from an SQL server. And not only that, this rock-solid tool has masses of new functions that enable you to analyse table data even better. Need to compile complex business reports? In this demo training session, we will be taking a closer look at how to do this.

Objectives

After this remote training, you can easily:

  • Import lists from a variety of data sources
  • Create PivotTables with data from different lists
  • Optimise a PowerPivot data model

Target Group

Anyone already familiar with PivotTables, but who would like to find out about an even more powerful analysing tool.

Prerequisites

Basic PivotTables operations (the different sections, change calculations, …) are not new to you.

Content

Part 1 Activating Power Pivot

  • 32bit version v 64bit version
  • Activating or deactivating Power Pivot add-in

Part 2 Importing data

  • Importing data directly into Power Pivot (Linking an Excel table, importing external data, maintaining connections)
  • Converting data to a Star scheme or Snowflake scheme
  • Importing data via Power Query
  • Refreshing data

Part 3 Optimising the Power Pivot data model

  • What are the requirements for a high-performance data model?
  • Defining relationships between tables
  • Defining date table
  • Months, weekdays,… sorting correctly
  • Setting standard calculations
  • Hiding columns in Excel/Datamodel
  • Creating and Using a Hierarchy
  • (Creating and Using a Perspective)

Part 4 Introduction to DAX (Data Analysis Expressions) Functions

  • Differences compared to Excel functions
  • Difference between a calculated field (measure) and a calculated column
  • Advantage of measures compared to Ad hoc calculations

Part 5 Excel PivotTable or Power Pivot PivotTable

  • When do you choose an Excel PivotTable?
  • When do you choose a Power Pivot PivotTable?
View all our trainings

Request for quotation

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?
This field is for validation purposes and should be left unchanged.