The Data Analyst's Power Tool

Big Data, Every Format, One Screen

Tabular IQ is a power tool for BI and data analysts. Open files, exports, and live databases side by side, then pivot, filter, and process millions of rows in seconds. Built-in AI analysis turns plain English into filters, formulas, and pivots, working right against your live data.

Tabular IQ application displaying a data table

Spreadsheet Simplicity, Database Power

Real analysis rarely starts with clean data in one system. It starts with a CSV from one department, an Excel export from another, and a database you're only allowed to read. Tabular IQ opens them all side by side, links them like tables in a single database, and lets you filter, group, and pivot across the whole population instead of a sample. No import project, no waiting, and AI assistance when you want it.

Direct Data Access

Plug and Play for Data

Open CSV files directly from the web
Import HTML tables with a single click
Link to data in MySQL and Oracle
Bookmark data files for easy access

Instant Analytics

Get answers in a snap

Create ad hoc calculations instantly
Match related records from different files
Integrate data dynamically
Filter or search for data with a click

Simple Reporting

Turn data into documents

Lay out data as easily as with a spreadsheet
Create "quick reports" in a single step
Print directly from MySQL and Oracle
Save reports in a PDF format

Built for Heavy Lifting

Pivot and group millions of rows in seconds

Join files and exports with live database tables

Clean and standardize messy fields with built-in functions

Automate repeat analysis with scripting when you need it

Our Commitment to an Enjoyable Data Experience

AI Analysis, Built In

AI analysis in Tabular IQ works like a conversation with your data. Describe what you want in plain English. It builds the query, runs it against your live data, and puts the result on screen. Not quite right? Say so, and watch it adjust. Each answer is a starting point for the next question.

Build filters and formulas from a plain English description

Shape pivots and joins across files and databases

Reconcile datasets with AI-assisted matching

Show me payments where the same amount went to two different vendor IDs in the same week

Done. I joined the payment table to itself on amount and week, kept rows where the vendor IDs differ, and put the result on screen. 14 pairs found.

Pivot those by vendor and month

Here is the pivot. Two vendors account for 11 of the 14 pairs, all in March.

Built for Business Analysts and IT Pros

Tabular IQ™ is an ad hoc data analysis and reporting tool built for people who work with, manipulate, and analyze structured data, from business analysts and IT professionals to internal auditors.

Access data from anywhere (Oracle, SQL Server, CSV, XLS, etc.)
Freedom from file size limitations (billions of rows per table)
Speed, flexibility, and agility (designed for data usability, not data management)

Features

Tabular IQ comes packed with the features serious data work demands: open huge tables instantly, relate data across sources, calculate, group, and report, all without waiting on an import project.

Access Data from Anywhere

Rich Data Environment

Built-In Database

Report Writer

Dynamic Calculations

Group Analyzer

Data Relationships

Query Builder

Data Bookmarks

Custom Extensions

Bring Every Format Into One View

The hardest part of most analysis isn't the analysis. It's that the data lives in five places and four formats. Tabular IQ treats a CSV, an Excel export, and an Oracle table as equals: open them together, match and reconcile records across them, and summarize the result. The work that used to mean an ETL request and a week of waiting happens in one afternoon, on your own desktop.

See Tabular IQ Against Your Own Data

The fastest way to judge a power tool is to hand it your hardest file. Get in touch for a demo and a trial.

Prefer to explore first? Start with the overview.