thinkNXG Insights — FLOSS Business Analytics & BI
100% FLOSS — AGPL-3.0

Bring your data alive
with open BI

thinkNXG Insights is a powerful, FLOSS business analytics tool. Connect multiple data sources, build complex queries without writing SQL, visualise with beautiful charts, and organise into live dashboards — all in one place.

Business Performance — Q2 2025
Live
Total Revenue
₹48.2L
+14.3% vs last Q
New Orders
1,284
+8.7% vs last Q
Customer Churn
2.1%
−0.4pp improvement
Avg Deal Size
₹37.5K
−2.1% vs last Q
Monthly Revenue — Last 6 months
Revenue by Segment
Enterprise 40%
SMB 24%
Mid-Market 16%
Startup 9%
Top ProductsRevenueStatus
thinkNXG ERP₹18.4LGrowing
thinkNXG HR₹11.2LStable
thinkNXG CRM₹9.8LGrowing
thinkNXG Helpdesk₹5.1LWatch
Data Sources
Query Builder
Chart Builder
Dashboards
Filters & Alerts
Share & Export
Data Models
Scheduled Reports
939+
GitHub Stars
18+
Contributors
12+
Chart Types
100%
FLOSS
Why Insights

Stop flying blind on your own data

Most businesses struggle with scattered data, expensive BI tools, and analysts who need SQL expertise just to answer basic questions. Insights changes that.

01
No SQL required
Visual query builder lets business users — not just developers — create complex reports with filters, joins, and pivot tables without writing a line of code.
02
All data in one place
Connect ERPNext, spreadsheets, PostgreSQL, MySQL, and more. Merge datasets and create calculated columns to get a unified view of your business.
03
Live dashboards
Build dashboards that update automatically as your data changes. Set alerts for anomalies and share with your entire team — no login required for viewers.
04
Fraction of the cost
Replace Tableau, Power BI, or Looker with a fully FLOSS alternative. Self-host on your own infrastructure for complete data sovereignty .
Data Sources

Connect to multiple sources

One of the biggest challenges organisations face is scattered data. Insights makes connecting your various data sources a breeze — integrate spreadsheets, databases, and your thinkNXG apps into a single unified model.

Multiple databases Connect PostgreSQL, MySQL, MariaDB, SQLite, and more with one click
Spreadsheet imports Upload CSV and Excel files, merge with other sources, and build calculated columns
Native ERPNext integration Analyse your thinkNXG ERP, CRM, HR data without any export or pipeline
Reusable data models Build once, reuse across teams — no more duplicate reports or conflicting numbers
Connected Data Sources
ERPNext
Built-in
PostgreSQL
Database
MySQL
Database
CSV / Excel
File Upload
REST APIs
HTTP Source
Google Sheets
Spreadsheet
Connect a new data source...
Query Builder — Sales Analysis
Tables
Sales Order
Customer
Item
Employee
Saved
Q2 Revenue
Churn Report
customer_name
territory
SUM(grand_total)
Add
status = "Completed"
date >= Q2 2025
Add
Customer
Territory
Revenue
Zara Textiles
South India
₹4.2L
Mehta Traders
West India
₹3.8L
GreenLeaf Co.
North India
₹3.1L
Query Builder

Build complex queries with ease

Data is only useful when you can extract meaningful insights from it. Insights simplifies this for all users through its intuitive visual query builder — no SQL expertise needed.

Visual column & filter picker Choose exactly what data you need with intuitive point-and-click controls
Joins & pivot tables Combine data from multiple sources for a complete business picture
Built-in functions & formulas SUM, AVG, COUNT, DISTINCT, custom expressions — all available visually
Reusable reports Save queries as reports that refresh automatically on new data
Chart Builder

Analyse with insightful charts

Insights picks the best chart for your data automatically — or you choose from a dozen chart types. Customise colours, reference lines, and data points, then share or add to a dashboard instantly.

12+ chart types Bar, line, pie, scatter, funnel, trend, area, heatmap and more
Smart suggestions Insights recommends the best chart type based on your data shape
Full customisation Change colours, add reference lines, configure axis labels and data points
One-click sharing Share charts externally, download snapshots, or push to any dashboard
Chart Builder
Chart Type
Bar
Line
Pie
Area
Dot
Heat
X Axis
month
Y Axis
SUM(revenue)
Theme: Default
Reference line
Share
Operations Dashboard
Auto-refresh
Open Tickets
142
+12 today
Resolved Today
38
On track
Avg Response
2.4h
−18min
CSAT Score
4.7
Excellent
Tickets by Priority
Critical
22
High
45
Medium
58
Low
17
Volume — Last 7 Days
Dashboards

Organise with powerful dashboards

Once your charts are ready, organise them into dashboards that track your most important metrics. Apply filters, receive change alerts, and share internally or externally to drive data-driven decisions across your entire organisation.

Drag-and-drop layout Arrange charts, KPI cards, and tables into beautiful, custom dashboards
Auto-refresh & alerts Set data change alerts and receive notifications when metrics cross thresholds
Public sharing Share dashboards with anyone — no login required for external stakeholders
Time & dimension drill-down Click into any chart to explore data further across time periods and dimensions
How It Works

From raw data to live dashboard in minutes

No data engineering background needed. Insights is built for business users and developers alike.

1
Connect a source
Link your ERPNext instance, database, or spreadsheet with a single click. No pipelines or ETL needed.
2
Build a query
Use the visual query builder to filter, group, join, and summarise your data — no SQL required.
3
Create charts
Turn query results into beautiful bar, line, pie, or scatter charts with smart type suggestions.
4
Publish dashboard
Arrange charts into a live dashboard and share with your team or external stakeholders instantly.
Origin Story

Why we built Insights

"

Building custom apps or creating structured data has been very easy with the thinkNXG Framework. However, extracting information from these apps was not a great experience. Users needed to know SQL to get valuable insights from their data. At our company, we had scattered revenue data — tracking renewals was challenging. Our renewal team had to depend on developers just to understand upcoming renewals and churn. I wanted to improve the experience of building reports and dashboards for everyone. That idea transformed into thinkNXG Insights — a generic business intelligence tool that gives a bird's eye view of overall performance. Today we use it to track sales, conversions, renewals, churn, support metrics, customer ratings, and much more. It has completely changed how we make decisions at all scales.

User Stories

Loved by data-driven teams

Business owners, finance teams, and operations managers use Insights daily to make faster, better decisions.

thinkNXG Insights has significantly enhanced our understanding of our business. It enables us to create complex SQL queries effortlessly, generating detailed reports that offer deep insights into our operations. One standout feature is the flexibility in joining data from multiple document types — eliminating repeated effort in Excel. It is crucial for our data-driven decision making.

VS
Vishhal Siingh
Banaraswala Wire Mesh Pvt. Ltd.

The ability to create and share interactive dashboards has been a game-changer. We can monitor key performance indicators in real-time, set up alerts for important changes, and ensure our team is always informed about the latest trends. This has significantly improved our operational efficiency and data security by centralising all our reporting in one place.

RN
Ramakrishnan Nataraj
Frutter Software Labs Pvt. Ltd.
FLOSS Forever

Ready to make the best use
of your data?

Deploy thinkNXG Insights on our cloud in minutes, or self-host for complete data sovereignty. No credit card required.

No credit card required
Self-host anytime
AGPL licensed
thinkNXG-native