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?
