QuickBooks reports in PowerPivot with QQube | CLEARIFY

QQube™ and Microsoft® Excel PowerPivot

Why use PowerPivot

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 - efficiently and quickly manages millions of rows
3. The ability to add other data sources such as spreadsheets, etc.

QQube Version 10 Makes it Easier

• Power Query is now the underlying Data Engine
• We added over 5,000 DAX Formulas
• Models are the same for Power Pivot as they are for Power BI
• Saves you hundreds of man-hours

Microsoft Excel PowerPivot Requirements

QQube Version 10 supports :

1. Excel 2016. Office 2016 Professional, Office 2016 Professional Plus and Excel 2016 Standalone.
2. Excel 2019. Office 2019 Professional, Office 2019 Professional Plus and Excel 2019 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.
• Beginning with QQube 10.0 Excel 2013 is no longer supported

How to determine what version of Power Pivot you currently have.

In This Section

• Getting Started
• How it Works
• Calculations and Measures