Tabular IQ

Ad hoc analysis for audit & compliance

Spreadsheet simplicity.
Database power.
AI insight.

Test entire populations, not samples. Pull CSVs, Excel exports, and live SQL Server, MySQL, and PostgreSQL tables into one workspace; filter, join, and pivot millions of rows in seconds. Describe the test in plain English — the answer arrives as a table you can keep working in.

Book a 30-minute call Read the overview

Connects to SQL Server, MySQL, and PostgreSQL · opens CSV, Excel, and HTML tables · runs entirely on your machine

Tabular IQ analysing an AP audit project: Ap_hist joined to Vend_mast with the SQL console open

Ap_hist × Vend_mast → 15-row vendor summary · 0.17 s

0.17 s
Grouped vendor summary across two joined tables
Billions
of rows per table — no file size limitation
5+
formats open at once, linked like one database
0
ETL requests, import projects, or waiting

01 — The reason to switch

AI analysis that runs against your live data

Describe what you want in plain English. Tabular IQ 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.

01 Build filters and formulas from a plain English description
02 Shape pivots and joins across files and databases
03 Reconcile datasets with AI-assisted matching
Console — AI ap_hist · live
> 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.
>

02 — Capabilities

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 are 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.

01 Direct Data Access

Plug and play for data — no staging, no conversion step.

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
02 Instant Analytics

Answers in a snap, against the full population.

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

Turn the finding into a document worth circulating.

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

03 — Performance

Built for heavy lifting

Designed for data usability, not data management. Freedom from file size limitations, with billions of rows per table.

01
Pivot and group millions of rows in seconds
Grouping is interactive, so the next question costs nothing.
02
Join files and exports with live database tables
A CSV, an Excel export, and an Oracle table, treated as equals.
03
Clean and standardize messy fields
Built-in functions for the reformatting every dataset needs first.
04
Automate repeat analysis with scripting
Run the same test next quarter without rebuilding it.

04 — Who it is for

Built for analysts, IT, and internal audit

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
Grouped and pivoted data in Tabular IQ

05 — Feature set

Everything serious data work demands

Open huge tables instantly, relate data across sources, calculate, group, and report — all without waiting on an import project.

01
Access Data from Anywhere
Oracle, SQL Server, MySQL, CSV, XLS and HTML tables.
02
Rich Data Environment
Many tables open at once, kept side by side on one screen.
03
Built-In Database
A local engine for tables that outgrow a spreadsheet.
04
Report Writer
Lay out data as easily as a spreadsheet, then save to PDF.
05
Dynamic Calculations
Ad hoc columns and formulas, evaluated against live data.
06
Group Analyzer
Group and pivot millions of rows in seconds.
07
Data Relationships
Link files, exports and tables like one database.
08
Query Builder
Compose filters and joins without hand-writing SQL.
09
Data Bookmarks
Save the files and connections you come back to.
10
Custom Extensions
Script repeat analysis when you need it automated.
A CSV, an Excel export, and an Oracle table open together in Tabular IQ

06 — Every format

Bring every format into one view

The hardest part of most analysis is not the analysis. It is 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. Pick a 30-minute slot and bring one — we will open it live.

Book a 30-minute call Start with the overview
Or reach us directly
Phone
+49 7031 925 2650
Address
fopen GmbH
Gartenstr. 12, 71155 Altdorf, Germany