Loading ...

About QQube | CLEARIFY

About QQube™

QQube White Paper

QQube™ Data Warehouse for QuickBooks

QQube Logo

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.

 

What You Can Do With QQube

TRADITIONAL REPORTING

QQube Traditional Reporting

DYNAMIC ANALYSIS

QQube Dynamic Analysis

VISUALIZATION

QQube Visualization

 

What Comes with QQube

  • Over 45 Analytics in the areas of Customers, Operations, Finance, and Audting
  • 7,000 + fields of information
  • 250 out-of-the-box examples for Excel, PowerPivot, Access, Crystal Reports, Tableau
  • Unparalleled Microsoft Power BI visualizations of QuickBooks data - a first in the industry
    • 75 + Analytic examples
    • 350 + out-of-the-box individual metrics
  • Excel Add-In

 

Target Users

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:

  • Those that need advanced reporting, dynamic analysis or visualization with drill down detail
  • Small Business needing a single complex report not available in QuickBooks
  • Companies with multi-level needs e.g. owner, bookkeeper, inventory manager
  • Franchise or multi-company operations
  • Professionals who provide reporting and analysis services for their clients
  • Developers and database experts who provide data services but know very little about QuickBooks

 

Target Companies

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:

  • Construction
  • Manufacturing
  • Retail
  • Wholesale
  • Professional Services
  • Real Estate
  • Medical/Dental/Health Services
  • Not For Profit
  • Franchise Restaurant Operations

 

How It Works

STEP 1.  QQube establishes a connection to QuickBooks and auto extracts data periodically - or upon demand - into our proprietary Sybase database.

QQube Synchronizer Process

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.

QQube Transformation Process

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. 

Creating QQube Analytics

 

How QQube Saves Time

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

  1. Fomulate a Question
  2. Determine and Access a Data Source(s)
  3. Gathering, Transform, and Organize your data
  4. Format it and Consume it

Stages 2 and 3 represent the greatest pain points in the process, and are virtually eliminated by QQube.

Report Stages