Excel Power Pivot

Learn to utilise the features of Power Pivot to summarise large amounts of data and streamline the process of presenting the results.

Power Pivot for Excel supports BI (Business Intelligence) functionality by allowing large amounts of data from various sources to be prepared and stored in an Excel workbook. Once there, data can be
integrated using relationships and analysed in a number of ways including the use of Pivot Tables and interactive displays such as Power Map or Power View (not the main focus of the course). 

Key content

  • Deal with large data sets from a variety of sources in Power Pivot
  • Review the Data Model to build relationships between tables of information
  • Begin to explore the Data Analysis Expressions (DAX) formulas Power Pivot uses

Objectives

  • Learn to utilise aspects of Power Pivot as a BI tool       
  • Use the data model to create a series of Pivot Tables and Power View graphs

Prerequisite

Excel Pivot Tables

Suitable for

This is an advanced level workshop which is suitable for those who have completed the prerequisite or who are competent with the topics covered in that workshop.

Before registering, it’s your responsibility to ensure that you are competent with the topics covered in the prerequisite workshop, including understanding how Pivot Tables are created, formatted and customised using filters and slicers. 

Notes

PC only. Mac Excel 2011 or 2016 does not support this feature. Excel 2016 is used. Also suitable for 2013 users.

Cost

Free for University of Auckland and UniServices staff
Free for University of Auckland postgraduate students
$125+GST for others

Registration

Visit our Registration page to learn about registering, withdrawing and our cancellation policy.

Dates, times and venues for 2017

July - September 2017

Monday 31 July 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Tuesday 29 August 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Friday 15 September 2017, 9am-12pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

October - December 2017

Thursday 12 October 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Monday 13 November 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus