QQube White Paper
QQube was created in 2010, and is the brain child of founder Chuck Vigeant, M.Ed. who is not only the father of Crystal Reports for QuickBooks, but is widely regarded as the most knowledgeable expert on QuickBooks data extraction.
Chief Engineer and database extraction architect, is Matt Froncek, who designed the QODBC Driver included with QuickBooks Enterprise.
QQube extracts the spaghetti code from QuickBooks, and transforms the data, using traditional data warehouse methodology, into drag and drop columns that can be used out-of-the-box with tools like Excel, PowerPivot, Power BI, Crystal Reports, Access, and Tableau.
There is no need to deal with tables, relationships, mapping documents, reverse engineering, or connection strings. Install, setup, load, and use.
QQube provides a level of granular detail that empowers those who require both summary and drill down reporting, while furnishing ease of use capabilities for users who want visualization for dashboards, and tools for dynamic analysis.
QQube users fall primarily in the following categories:
We have a huge user base, as one of Intuit's largest 3rd party applications, and serve a variety of industries around the globe. Here is a list of our most prevalent business types:
STEP 1. QQube establishes a connection to QuickBooks and auto extracts data periodically - or upon demand - into our proprietary Sybase database.
STEP 2. QQube transforms the raw spaghetti code data, and transforms it into usable pieces. Each analytic is organized as a traditional warehouse "Star Schema", where there is one FACT table containing measures, and links to multiple DIMENSIONS e.g. accounts, items, customers, etc.
STEP 3. Using your tool of choice, open up an existing report - or start from scratch using one of our pre-built shells - and the data will refresh from the QQube database automatically. There are no connection strings or configuration needed.
QQube eliminates up to 90% of the time it traditionally takes to write custom reports.
Creating a report or analysis of any type requires four stages
Stages 2 and 3 represent the greatest pain points in the process, and are virtually eliminated by QQube.
Support Login Issues