Excel PowerPivot: Module 1 - Introduction

  • Duration: 1 day

Description

Excel's rock-solid data tool? Get to know this tool during our training course ‘Excel PowerPivot Introduction’!

Are you already juggling with PivotTables in Excel? Then you will undoubtedly go wild with PowerPivot. What is PowerPivot? It is an extremely powerful tool in Excel. What exactly does it do? It very quickly builds up PivotTables from huge amounts of data. And even more amazing: the data does not all need to come from the same source!

This course explains how to seamlessly merge an Excel list with an Access database. Or with a table originating from an SQL server. Did you know that a normal Excel table is limited to 1,048,576 rows? PowerPivot manages to break down this barrier too. And not only that, this rock-solid tool has masses of new features that enable you to analyse table data even better.

Need to compile complex business reports? Sign up now for the course ‘Excel PowerPivot - Introduction’. And make it all very easy for yourself!

Objectives

Need to compile complex business reports? Sign up now for the course ‘Excel PowerPivot Introduction’. And make it all very easy for yourself!

Would you like to see with your own eyes what PowerPivot has to offer? Then sign up for our course ‘Excel PowerPivot’ and find out how to effortlessly:

  • Import tables from a variety of different data sources
  • Create PivotTables with data from different tables
  • Use DAX functions for more efficient data analysis

Target Group

This course is for anyone already familiar with PivotTables, but who would like to find out about an even more powerful analysing tool.

Prerequisites

You need to be familiar with entering functions without using the function wizard (which is not available in PowerPivot). Furthermore, you must be familiar with the basic PivotTables operations, such as: what are the different sections used for (Filter, Columns, Rows and Values); how do you change a calculation in a PivotTable from Sum into Average, how do you show the value as a percentage relative to the total.

Content

PowerPivot

  • 32-bit version versus the 64-bit version
  • Installing PowerPivot
  • (De)activating PowerPivot

Importing data

  • Linking an Excel table
  • Creating a fixed table in PowerPivot
  • Importing an Excel table
  • Importing text files
  • Importing data from other data sources (Access, SQL, ODBC …)
  • Maintaining connections
  • Refreshing data

Working in the PowerPivot window

  • What are the differences compared to the Excel datasheet?
  • The different data types
  • Adding and deleting fields/columns
  • Sorting
  • Filtering

Optimizing the PowerPivot data model

  • Defining relationships between tables
  • Defining date table
  • Correctly sorting months, weekdays, ...
  • Setting standard calculations
  • Hiding columns in Excel/data model
  • Creating and using a hierarchy
  • Creating and using a perspective

PowerPivot PivotTables

  • Creating a PowerPivot PivotTable
  • Differences compared to an Excel PivotTable
  • Filtering a PowerPivot PivotTable using slicers

Introduction to DAX functions (Data Analysis Expressions)

  • Differences compared to Excel features
  • Difference between a calculated field (measure) and a calculated column
  • Row Context, Filter Context and Query Context
  • DAX functions: Related, RelatedTable, Countrows, All, Sumx, Countx, Countax, minx, maxx, averagex, filter, calculate

Excel PivotTable or PowerPivot PivotTable

  • When to choose an Excel PivotTable?
  • When to choose a PowerPivot PivotTable?
  • What added-value does PowerPivot have compared to the integrated functionality of PivotTables in Excel?

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

This training as in-company training?

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request