Showcase
Everything below runs on your own desktop against files, exports, and live database tables at the same time. Five of them have a short demo you can watch here.
01 — Get data in
No staging table, no conversion step, no import project. Files, exports, and live database connections all open the same way.
Open CSV, Excel and Parquet files where they are, or connect a whole folder of them. Connect to SQL Server, PostgreSQL, MySQL, Oracle and Db2, or to Snowflake, BigQuery and Databricks, then join them all in a single query.
Build SQL without writing it: drag in tables, draw the joins, pick the fields, criteria and sort order, and run. The query writes its own SQL, ready to read, change or reuse.
Bookmark data from the web, local files, and database systems. Organize bookmarks in folders on your toolbar and click one to open a data file.
02 — Work the data
The part of the job that usually means waiting on someone else. Every operation here runs against the whole population, interactively.
Work with your data in an environment designed exactly for this purpose. Sort, filter, and reformat with a single click, and cut through the clutter of an unfamiliar data set quickly.
A local database engine for tables that have outgrown a spreadsheet: industry-standard SQL on your own desktop, hundreds of millions of rows, no file size limit, no server to provision. Your data never leaves your infrastructure, which keeps GDPR and hosting policies simple.
Create calculations instantly across a full data set and see the resulting values as you type. Reformat data, extract embedded values, and test and edit regular expressions interactively.
Organize and analyze data by groups of records. Summarize groups to generate statistics, or keep the detail records together to identify duplicates and find groups that meet your criteria.
Interactively combine data from different files. Hook them together, drag columns from one into the other, then compare across related files and find matching records.
03 — Report and extend
An answer on your screen is only half the job. Reporting and scripting close the loop.
Develop reports directly from your tables, whether they live in local files or a database. Flip between the pages and the design as you work, group and subtotal, print, and save to PDF. Creating a report is as simple as using a spreadsheet.
Tabular IQ includes a data-enabled version of JavaScript with built-in support for SQL and other data manipulation functions. Write new extensions or plug in existing ones built by the community.
The demos are short and generic. Thirty minutes with your own hardest file tells you far more.