Desktop analytics · Windows 10/11 · 100% local

Data to dashboard
in seconds

Drop an Excel or CSV — or connect straight to SQL Server, PostgreSQL, SharePoint and more — and get instant KPIs, AI-recommended charts, forecasting and boardroom-ready PDF reports. Nothing ever leaves your machine.

No signup to run · activates offline after a one-time key check
Why QikAnalytix

Everything between raw data and the boardroom

One tool replaces the spreadsheet gymnastics: load, clean, analyse, visualise, report.

🔒

100% local processing

Parsing, joins, cleaning, forecasting — all on your machine. No cloud, no upload, no data residency questions.

🤖

VizBOT AI assistant

"Donut chart of top 5 revenue by product" — done. Works fully offline with the built-in parser; add an API key for richer conversation.

📊

21 card types

Bar to box plot, heatmap to waterfall, plus tables, pivot tables with totals, text and image cards — on Excel-style sheets.

🔌

8 live connectors

SQL Server, PostgreSQL, ODBC, Google Sheets, REST APIs, remote CSV, SharePoint links and paste — credentials never touch disk.

📈

Forecasting & statistics

Holt smoothing with confidence bands and accuracy scoring, correlation matrices, 21 statistics per column, auto-chart recommendations.

🧮

Formula & quick functions

Calculated columns with math, date and text functions — split, substring, find & replace, concat, trim — safely parsed, never eval'd. Or apply one-click quick functions with no formula at all.

🧹

Data cleaning wizard

Nulls, duplicates, whitespace, case variants, numbers-as-text and dates-as-text — previewed before fixing, one click to fix all, with an option to keep originals and write fixes to new columns.

📄

Reports people can open

Multi-sheet PDF reports with your title banners, Excel + CSV exports, chart PNGs — and .qap workbooks that reopen an entire dashboard with a double-click.

🧬

What-if scenarios

Slide any measure ±% and watch every KPI and chart recompute live. Present the plan and the downside in the same meeting.

🔗

Reshape & combine

Pivot and unpivot between wide and long, and join two datasets on a shared key with auto-matched columns — each producing a new dataset while originals stay put.

♻️

Non-destructive by design

Every transform, clean and calculation runs on an in-memory copy — your source files are never rewritten. Reload or replace a source, or edit a saved connection, anytime.

🪪

Licensing you control

Machine-bound offline licensing with multi-seat keys, an in-app About dialog showing version, key, seats, expiry and org — and one-click key change or transfer.

Product tour

See it work, feature by feature

Real screens from the app — no mockups. Everything here runs on your machine.

VizBOT · AI

Ask for a chart in plain English

Type what you want — “bar chart of revenue by region” — and VizBOT builds it, then adjusts it by phrase: “add data labels”, “make it green”. It works fully offline with the built-in parser; add an API key only if you want richer conversation.

Quick Check

Pivot tables by dragging

Drop fields onto Rows, Columns and Values and a live crosstab builds instantly — subtotals and grand totals included. Pin it to the dashboard as a live-linked card that stays in sync with the data.

Transform

New columns from a formula

Click columns to build a formula — [Profit] / [Revenue] * 100 — and the calculated field lands in your data, KPIs and charts. Formulas are safely parsed, never eval’d.

Transform

Fix messy data in one click

The cleaning wizard scans for blanks, duplicates, stray whitespace, case variants, and numbers or dates stored as text — previews every fix, and clears them all at once. Watch the data-quality score jump from 13% to 91%. Your original file on disk is never touched.

Analytics

Project the next quarters

Run a Holt forecast and see the projection with its 80% confidence band and a MAPE accuracy score — historical, model and forecast on one chart, computed locally in a click.

Scenarios

Model the plan, live

Slide any measure ±% and watch every KPI and chart recompute instantly. Present the plan and the downside in the same meeting — an amber banner shows the scenario, and your underlying data never changes.

Charts

Twenty-one ways to see it

Bar to doughnut, treemap to waterfall, heatmap to box plot — switch any card’s type from its menu and it re-renders instantly, on Excel-style sheets with tables, pivots and text cards alongside.

Add a data source — eight live connectors
Connect

Eight live data sources

Excel and CSV, Google Sheets, SharePoint links, REST APIs, remote CSVs, pasted data — plus native SQL Server, PostgreSQL and ODBC connections. Credentials are held in memory for the session and never touch disk in plain text.

Correlation matrix with a reading guide
Analytics

See what drives what

A colour-coded correlation matrix and 21 statistics per column surface the relationships hiding in your data — green for positive, red for negative — with a plain-English guide to reading them.

Pivot / Unpivot reshape dialog
Reshape

Pivot, unpivot, combine

Reshape wide↔long, or join two datasets on a shared key with auto-matched columns. Each transform produces a new dataset while your originals stay exactly as they were.

Export PDF report dialog
Report

Boardroom-ready reports

Export a multi-sheet PDF that mirrors your dashboard — title banners, KPI strip and charts included — plus Excel, CSV and shareable .qap workbooks that reopen an entire dashboard with a double-click.

Use cases

Built for the people who own the numbers

Finance & operations reviews

Month-end without the deck-building marathon: connect the ERP export or the finance database, and the pack builds itself.

  • KPI cards with min/max alert thresholds
  • Waterfall bridges and variance-ready pivot tables
  • Multi-sheet PDF that mirrors your dashboard, title banners included
Finance & operations professional
Finance & OperationsThe month-end ownerCloses the books, builds the board pack
Sales & revenue professional
Sales & RevenueThe pipeline driverRuns the forecast, works the deals live

Sales & pipeline reviews

Ask VizBOT for "top 10 accounts by revenue, highest first" mid-meeting. Filter by region, quarter or rep — everything updates live.

  • Funnels, rankings and trend lines in one view
  • Top-N and date-range filters built for reviews
  • Forecast next quarter with confidence bands and accuracy

Consulting & client deliverables

Land at a client, load their extract, and hand back cleaned data plus a branded dashboard — before the second coffee.

  • Cleaning wizard with previewed fixes and quality score
  • Joins, pivot/unpivot and calculated columns without code
  • Share the whole workbook as a single .qap file
Consulting professional
ConsultingThe client delivererCleans the extract, ships the dashboard
Enterprise

The security story is the architecture

QikAnalytix isn't a SaaS with a privacy policy — it's a desktop app with no data path to leave your network in the first place.

🖥️

Data never leaves the machine

All computation is local. Works in restricted and air-gapped environments after a one-time activation.

🔑

OS-encrypted secrets

API keys are stored via Windows DPAPI in the privileged process — never in the UI layer, never in plain text.

🗄️

Direct database access, no middleware

SQL Server, PostgreSQL and ODBC connect natively. Credentials are held in memory for the session only.

📜

Offline licensing with machine binding

One key check at activation, then a signed local license. Multi-seat keys, revocation and transfers supported.

📤

Shareable without servers

.qap workbooks bundle dashboards and data into one file colleagues open in their own installation.

🧾

Volume licensing

Team and site licenses with per-seat control. Talk to us about pilots and rollout.

Download

Get QikAnalytix

Tell us where it's headed and the download starts immediately.

Windows 10 / 11 · 64-bit

Installer, no admin rights needed for per-user install.

  • Runs fully offline after activation
  • Sample dataset included — explore before connecting anything
  • Free trial; license keys delivered by email
  • Latest version:
We use this only to send release and license information. No spam, no resale.

Your download is ready

Thanks! Starting the download…

Download installer
Version history

What's new

Loading…
FAQ

Common questions

Is my data uploaded anywhere?

No. Files and database results are processed and stay on your machine. The only optional external call is the AI assistant (aggregates and column names only, never rows) — and it works offline without it.

Does it need internet?

Once, to activate your license key. After that it runs fully offline, with a silent re-check about every 30 days that never locks you out while offline.

What can I load?

CSV and Excel files, Google Sheets, SharePoint/OneDrive share links, REST APIs, remote CSVs, pasted data — and live SQL Server, PostgreSQL or any ODBC source.

Can I move my license to a new machine?

Yes — licenses are machine-bound but transferable. Change the key in-app from About → Change license key, or contact support to release a binding.

Does it modify my source files?

No. Every clean, join, pivot and calculated column runs on an in-memory copy — your CSV, Excel and database data are never written back. The cleaning wizard can even keep originals and add the fixes as new columns.

How do the connectors handle credentials?

Database and API credentials are encrypted with Windows DPAPI in the privileged process and held in memory for the session — they never reach the interface layer or touch disk in plain text.

Contact

Talk to us

Questions, a live demo, or volume licensing — reach us the way that suits you. We usually reply within a business day.

Goes straight to our team. Prefer to talk now? Use WhatsApp or call above.