BIQ - Power Tools for the Data Analyst
Product Working With Us Articles Partners Company Downloads

A Product Designed for Analysis


Our users enjoy unparalleled capabilities to extract value from their data, and BIQ has become their solution of choice for exploring new datasets and building analysis models. Here's what some BIQ customers tell us they are doing with the tool:

  • A specialty retailer has built an IT dataset to support a major savings initiative;
  • An insurance company has saved seven figures using an AP dataset and a dozen commodity-specific datasets;
  • A financial services firm has combined 11 accounting systems together for an enterprise-wide view of spend;
  • A cable TV provider has used BIQ to analyze repair records and significantly reduce truck rolls;
  • An international publishing firm has used BIQ to rationalize HR policies across its facilities.

And here are some reasons why they've been successful.

Highly-Optimized OLAP Engine

BIQ's engine allows for real-time changes to hierarchies and real-time applications of rules. There is no "publish" phase to worry about — the changes take place immediately. BIQ's engine is hand-crafted for maximum speed, and performs sophisticated shortest-path query analysis. On multi-core machines, BIQ automatically utilizes as many CPUs as it can. The net result is that BIQ makes maximum use of available CPU cycles, allowing it to handle very large datasets on very ordinary desktop and laptop PCs.

Flexible Deployment Options

BIQ can be deployed in three ways: client-server, independent desktop or laptop, or peer-to-peer, where each desktop/laptop is both client and server, and where each user can connect to datasets either on his local machine or on a colleague's machine.

Advanced Modeling Facilities

BIQ analysis models are populated directly from the OLAP engine, at OLAP speeds. Excel models, graphs, pivot tables, and so on can be "booked" down any dimension, creating multi-page reports of deep complexity, with just a few simple commands.

Real-Time Hierarchy and Rules Editing

BIQ provides a drag-and-drop hierarchy editor that enables massive changes to be made in data hierarchies — entire subtrees can be moved or reorganized, new nodes created, and so forth. Making these changes permanent is a one-click, nearly-instantaneous process. The changes can be viewed immediately afterward, and all roll-up quantities are adjusted automatically according to the new hierarchy structure.

BIQ allows rules generation directly from the data viewer. New rules can be applied temporarily or permanently. The results can be viewed immediately, with complete visibility as to the consequences of the changes. Rules groups are executed in a priority order that can be changed at any time. Rules that have dimensional interdependencies can have inter-dimensional priorities set as well. The result is a general-purpose system of enormous capability — capability far beyond a simple commodity mapping system like that of other products.

Built-in Data Loading Facility

BIQ contains a built-in Data Loader that supports dimension derivation either from flattened transaction records, or through the use of external dimensional indexes that can be in hierarchical or flattened format. Fields can be named, referenced, and cross-linked using these BIQ tools. Indexes can be constructed out of "pieces" of multiple fields, concatenated together or otherwise manipulated on-the-fly, within the Data Loader itself. Construction of a useable dataset can take only a few minutes.

The Data Loader is reachable directly from the main BIQ application. If there's something wrong with a dimension, it can be dropped and re-added immediately. The dataset can be viewed incrementally, as dimensions are being created, to ensure that each dimension has been built properly. There is no "publish" process with BIQ; once the Data Loader has read in the files and indexes, and the user has identified the appropriate fields within them, the completion of a working dataset is just a few minutes away.

Powerful Data Viewer

BIQ's Viewer is designed for maximum visibility. BIQ's engine rolls up multiple dimensions simultaneously, which means that all Viewer windows represent the current filter set at all times. Most competitive products are only able to view one dimension at a time — a "keyhole" view that is largely ineffective. There is no "pivot" operation in BIQ, because "pivoting" is automatic.


What is Spend Analysis?

Spend Cube

Usage Example

Usage Example

"You just showed me in five minutes what it normally takes us two months to accomplish."

— BIQ customer