Description
Excel’s rock-solid data tool? Get to know this tool during our training course ‘Excel Power Pivot Introduction’!
Are you already juggling with PivotTables in Excel? Then you will undoubtedly go wild with Power Pivot. What is Power Pivot? 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? Power Pivot 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 Power Pivot – Introduction’. And make it all very easy for yourself!
Objectives
Need to compile complex business reports? Sign up now for the course ‘Excel Power Pivot Introduction’. And make it all very easy for yourself!
Would you like to see with your own eyes what Power Pivot has to offer? Then sign up for our course ‘Excel Power Pivot’ 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 Power Pivot). 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
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?
