QQube - Microsoft PowerPivot (Excel) | CLEARIFY

QQube™ and Microsoft® Excel PowerPivot

Why use PowerPivot

PowerPivot for Excel started as a free download from Microsoft for Excel 2010, and is now included with Excel 2013/2016/365 'Plus' Editions.

There are three advantages of PowerPivot over a regular pivot table:

1. The ability to filter information as a column (called Measures)
2. Increased capacity - up to millions of rows in the blink of an eye
3. The ability to add other data sources such as srpeadsheets, etc.

The technology behind PowerPivot is actually a version of SQL Server INSIDE of the Excel spreadsheet.

Microsoft Excel PowerPivot Requirements

The following versions that are supported:

1. Excel 2013. Only available in the Office Professional Plus version and you will need to enable the Add-In.   Download the latest update to Microsoft PowerPivot Excel 2013.  If you already have Office - and NOT the Professional Plus version, you can purchase just the Professional Plus version and install it - without affecting your current implementation.
2. Excel 2016. Office 2016 Professional, Office 2016 Professional Plus and Excel 2016 Standalone.
3. Excel 365.  Available in the Office 365 ProPlus as a subscription.  Also available in the E3 and E4 versions.

NOTES:

• Beginning with QQube 6.1, Excel 2010 is no longer supported.
• PowerPivot created in Excel 2013 will work in Excel 2016 and vice-versa.

How to determine what version you currently have.

In This Section

• Getting Started with PowerPivot
• Refreshing PowerPivot Data
• Adding/Removing Fields to your Data Model
• Creating a Measure
• Working with Custom Fields
• Using Slicers (Filters)
• Case Study