Excel Power Pivot and Power Query

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

Power Pivot and Power Query 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 PivotTables and interactive displays such as PowerMap or PowerView (not the main focus of the course). Using PowerPivot for SharePoint you can share your workbooks across your team or publish them to the Web (not covered).

Objectives

Learn to utilise aspects of Power Pivot and Query as a BI tool

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 for this workshop, it is your responsibility to ensure that you are competent with the topics covered in the prerequisite workshop.

Notes

PC only. Mac Excel 2011 or 2016 does not support this feature. Excel 2013 is used. Also suitable for 2010 users. Power Query is an additional download for 2013.

Cost

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