Click here to send this to a colleague or friend.
Microsoft PowerPivot

Microsoft Office version 2010, 2013 and 2016

PowerPivot for Excel is an add-in that is used for connecting to and integrating large amounts of data in Excel workbooks. The data that you add to the workbook is stored internally, as an embedded PowerPivot database.

You can use this database in Excel or in Power View reports. In Excel, the workbook provides all of the data visualization and interaction features. Using the PivotTable reporting skills you already have, you can build sophisticated workbooks that are based on Excel’s rich data analytical tools.

Power View reports can use the workbook as an external data source for live, ad hoc reporting in SharePoint. Power View is a premium Reporting Services feature that is part of the SQL Server 2012 release. It is a server-side report designer that is built into SharePoint so that you can create your reports online.

As with any Excel workbook, in PowerPivot for Excel you can add data from a wide variety of data sources, including a relational database, a multidimensional database, data feeds, an Excel table, or a Reporting Services report. You can also add data from files on your local computer, and use data that you download from the Web.

However, unlike Excel, you can then create relationships between these data to form a single data set, and then perform analyses against this data. You are not limited to one million rows either -- PowerPivot enables you to add and work with millions of rows of data locally, depending on the actual physical memory available on your desktop computer.



Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.

Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists.


Supported Data Sources

PowerPivot supports importing data from SQL Server databases, Analysis Services cubes, Access databases, Excel worksheets, text files, data feeds, and more.

Register now for this workshop
PowerPivot Supported Data Sources
What is an Access Database? Creating a Pivot Table in the Excel Window
Add Data by Using the Table Import Wizard Save Your PowerPivot Workbook
Set up Relationships between Tables Set up New Relationships between Data from Separate Sources
Set up Relationships in Diagram View Set up a Calculated Column
Using DAX (Data Analysis Expressions) Set up a Hierarchy in a Table
Set up a Hierarchy Edit a Hierarchy
Delete a Hierarchy Set up a PivotTable from PowerPivot Data
Delete a PivotTable Set up a PivotChart
Delete a PivotChart Work with Slicers in a PivotTable
Add Slicers to PivotCharts Set up a Measure and KPI
KPIs Add a Perspective
Event Information:
Date: 6th May 2020 at Benvenuto Conference Centre in Randburg

1st June 2020 at Benvenuto Conference in Randburg

25th June 2020 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

4th August 2020 at Benvenuto Conference Centre in Randburg

7th October 2020 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

Map: View map
Duration: 1 Day
Cost: R2 500.00 excl VAT
R2 875.00 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional surcharge

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops: Visit our workshops calendar for more information.

10% discount for two or more delegates

10% discount if you attend two or more workshops

15% discount for four or more delegates

In-house at your offices
discount for 5 or more delegates

30% discount for 8 or more delegates

35% discount for 10 or more delegates

We provide laptops for in-house computer-based training sessions



Contact Adele on
011 867 7299 or email

Bookings and Enquiries
Website | Email

Microsoft workshop presenters are Certified Microsoft Office Specialists
We offer on-going email support after attending any Microsoft workshop for an unlimited period of time

Workbooks and workshops are aligned to the prevailing Unit Standard;
Front Foot provide business training to business people;
Training is held at premium training venues.