Description

Excel's rock-solid data tool? Get to know it in our training Excel Power Pivot: Module 1 - Introduction!

Already juggling PivotTables in Excel? Then you'll definitely go wild for Power Pivot. What is Power Pivot? It's a powerful Add-In for Excel. What exactly does it do? Build PivotTables lightning-fast from huge amounts of data. And even more impressive: that data doesn't even need to come from the same source!

This training explains how to seamlessly merge an Excel list with an Access database. Or with a table pulled from an SQL server. Did you know a normal Excel table is limited to 1,048,576 rows? Power Pivot breaks through even that barrier. On top of that, this powerhouse has a whole range of new functions to analyse table data even better.

Putting together complex business reports? Sign up now for this training Excel Power Pivot: Module 1 - Introduction. And make it easy on yourself!

Objectives

Putting together complex business reports? Sign up for the course 'Excel PowerPivot: Module 1 - Introduction'. And make it easy on yourself!

Where does the power of our Excel PowerPivot: Module 1 - Introduction training lie? Want to see with your own eyes what PowerPivot has up its sleeve? Then take our Excel PowerPivot: Module 1 - Introduction training and find out how to smoothly:

• Import lists from various data sources

• Create PivotTables with data from different lists

• Use DAX functions to analyse data more efficiently

Target audience

Anyone already comfortable with PivotTables who wants to discover an even more powerful analysis tool

Prerequisites

You need to be comfortable entering functions without using the function wizard (which isn't available in PowerPivot anyway). You should also know the basics of PivotTables: what the different sections are for (Filter, Columns, Rows and Values); how to change a PivotTable calculation from Sum to Average, how to show a value as a percentage of the total.

Contents

Part 1: Activating Power Pivot

• 32-bit vs 64-bit version

• Activating or deactivating the Power Pivot add-in

Part 2: Importing data

• Importing data directly into Power Pivot (linking Excel tables, importing external data, maintaining connections)

• Converting data to a star or snowflake schema

• Importing data via Power Query

• Refreshing data

Part 3: Optimising the Power Pivot data model

• Requirements for a powerful data model

• Defining relationships between tables

• Defining a date table

• Correctly sorting months, weekdays, etc.

• Setting default calculations

• Hiding columns in Excel/Data Model

• Creating and using a hierarchy

• (Creating and using a perspective)

Part 4: Introduction to DAX (Data Analysis Expressions)

• Differences compared to Excel functions

• Difference between a calculated field (measure) and a calculated column

• Benefits of measures compared to ad-hoc calculations

Part 5: Excel PivotTable vs Power Pivot PivotTable

• When to choose an Excel PivotTable?

• When to choose a Power Pivot PivotTable?