Unleash Excel Business Intelligence! This course includes:
- Power Pivot workbooks
- Excel Data Model
- Create table relationships
- Import & query data
- Power PivotTable and Charts

Power Pivot for Microsoft Excel Course Content
Course Duration
One day or two half-days
Course Objectives
After completing this course you will be able to describe the main ways to import and query data using Power Pivots workbooks in Excel, to generate PivotTable and PivotChart reports and to create relationships between Power Pivot tables.
Course Prerequisites
Previous knowledge of Excel PivotTable features is useful but not essential. Basic understanding of relational data is useful but not essential.
Who is this Course for
Professionals who want to use Power Pivot full capabilities in Excel 2010 and who recognise the need for Business Intelligence.
Introduction
Â
- Why use PowerPivots
- PowerPivot Workbooks
- The PowerPivot tab
- Data sources
- Relationships
Importing Data
Â
- Using the Table Import Wizard
- Import and Filter from Databases
- Run SQL Query
- Get Data from Files
- Copy and Paste Data
- Create Linked Tables
PowerPivot Tables
Â
- Formatting Numbers
- Handling Technical and Useless Columns
- Understanding Calculated Columns
- Using Lookup Tables
- Understanding Measures
- Handling Many Tables
- Refreshing Data
Creating Relationships
Â
- Understanding relationships
- Review existing relationships
- Create new relationships
Building DAX Formulas
Â
- Formula basics
- DAX Data Types
- DAX Operators
- Calculated Columns Examples
- DAX Measure Examples
- RELATED, CALCULATE functions
PivotTables & PivotChart Reporting
Â
- Difference between Excel PivotTable and PowerPivot PivotTables
- Updating the table
- Changing the table structure
- Formatting the PivotTable
- Creating a PivotChart
- PivotChart Layouts
- Changing the Chart type
- Formatting the Chart
Slicers
Â
- Adding slicers to PivotTables and Charts
- Resizing Slicers
- Slicer options