QQube Data Models Explained

Overview

The QQube Data Warehouse for QuickBooks contains 40 data models each of which contain a complete set of information to report on a particular business area or subject.

One data model does not depend upon another, and there is no reason to connect one data model with another, unless you are trying to do something that QuickBooks doesn't store underneath the hood or doesn't work as it might appear in the QuickBooks user interface.

For instance, the Job Cost Details Data Model contains information from many sources:

1. All pertinent Sales Transactions
2. All pertinent Cost Transactions
3. Original and Remaining Committed Costs (e.g. Purchase Orders)
4. Estimates
5. Receive Payments
6. Bill Payments
7. Time Tracking
8. Vehicle Mileage
9. General Ledger Details

QQube Connects the Dots

Intuit exposes the QuickBooks Data in hierarchal text format (XML), not as tables.  Raw connectors on the market make this text look like individual tables and lists, but the logic to put them together still requires weeks and months to figure out.

QQube takes the data and puts everything together for you.  It is not necessary to deal with tables, relationships, data dictionaries, reverse engineering.

So all you end up doing is choosing a field that QQube makes available in the tool of your choice and create a report or visualization.  You don't have to worry about where the data came from, or how the logic was constructed.  If you took a QQube report, and - using the same filters - compared it against QuickBooks, it would match to the penny.