Let's talk

Frappe Insights Dashboards and Reports

We set up Frappe Insights so the numbers your managers ask for every week sit on a dashboard that updates itself, built on your ERPNext data, with no BI licence per user.

Frappe Insights

Open-source BI that reads your ERPNext data without an export.
Frappe Insights is the business intelligence app from the makers of ERPNext. Installed on your ERPNext site it sees every ERPNext table, with the links between them already set up, so a sales-by-region chart takes a few clicks instead of a SQL query.
It also connects to MariaDB, MySQL, PostgreSQL and other databases, and takes CSV and Excel uploads, so ERPNext data can sit next to data from other systems.

Where ERPNext reports stop

ERPNext's built-in reports answer one question at a time. Insights is for the questions that cut across modules: margin by customer and item, collections against sales targets, stock age by warehouse. You build them with joins, filters, pivots and calculated columns in a visual query builder, and save them as charts on a dashboard.

Dashboards carry filters, can be shared inside the company or outside it, and can send an alert when a number crosses a limit you set.

What the service covers

Data setup

Your ERPNext tables and any outside databases connected, with the joins your reports need.

KPI dashboards

Dashboards for sales, purchasing, stock, receivables and production, agreed with the people who read them.

Custom queries

Calculated columns, pivots and, where needed, SQL or script queries for the harder questions.

Sharing and permissions

Who sees which dashboard, plus shared links for people outside ERPNext.

Alerts

Notifications when a figure crosses a limit you set.

Training

Your analysts taught to build their own queries and charts.

How we work

  1. Questions first. We list the decisions each manager makes and the numbers each decision needs.

  2. Data check. We check that the ERPNext data behind those numbers is complete enough to trust.

  3. Build. Queries and dashboards built and reviewed with each owner.

  4. Rollout. Permissions, sharing and alerts set up.

  5. Handover. Your team trained to change and add dashboards themselves.

Skills we bring

  • Frappe Insights
  • ERPNext data model
  • SQL on MariaDB and PostgreSQL
  • KPI and dashboard design
  • ERPNext query and script reports

Is this the right fit?

A good fit when

  • Managers wait every week for someone to export ERPNext data to Excel.
  • You want BI without a per-user licence.
  • Your ERPNext data needs combining with another database or spreadsheet.

Probably not, when

  • You already run Power BI or Tableau well and only need an ERPNext connector.
  • Your ERPNext data is incomplete. A dashboard will show the gaps, not fix them.

Frequently Asked Questions

Yes. It is open source under AGPL-3.0, with no per-user licence. You pay for setup, hosting and support.

Yes: MariaDB, MySQL, PostgreSQL, DuckDB and ClickHouse, plus CSV and Excel uploads. Installed on your ERPNext site, it reads ERPNext data with no extra connection.

No. The visual query builder handles joins, filters, pivots and calculated columns. SQL and script queries are there for the cases that need them.

ERPNext reports are fixed views, mostly of one module. Insights combines tables across modules and other sources, and lays the results out on shared dashboards.

Get In Touch

Girish Budhwani, Co-Founder of Girman

Girish Budhwani

Co-Founder, Girman | Ex Microsoft, Khatabook | IIT

Book a free consultation

or send a brief

Girman-logo
frappe-partner

Girman Tech is a Frappe Certified Partner in Bangalore, trusted for delivering tailored ERPNext solutions to businesses of all sizes. As an official Frappe and ERPNext Partner in Bangalore, we help companies to streamline operations and grow with open-source ERPNext solutions.

From seamless implementation to customization and ongoing support, our team ensures businesses unlock the full potential of open-source ERP. Based in Bangalore, we serve clients across India and globally with reliable, scalable, and future-ready ERP solutions.

Recognized By

footer_startupindia

BUSINESS

mail

contact@girmantech.com

phone

(+91) 93801 94282

Accounting ERP Software in Bangalore

Accounting ERP Software in Karnataka

HR Contact

mail

careers@girmantech.com

phone

(+91) 7558354540

FOLLOW US