QQube - Excel PowerPivot | 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.   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 2019. Office 2019 Professional, Office 2019 Professional Plus and Excel 2019 Standalone.
4. 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