Introducing Frappe Insights
summary
A BI tool built in three months that runs on Frappe and connects multiple ERPNEXT instances, letting users build counts, monthly aggregates, joins, and date-difference expressions without writing SQL; demo shows creating a seller count, orders‑per‑month, top‑10 product categories via a left join, and average delivery days by month, all saved to a resizable dashboard and assembled in about five minutes. Claims include no SQL required and joins and expressions with autocomplete, live filtering and sorting, and dashboard drag‑resize; available on Frappe Cloud Marketplace and open‑source on GitHub.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 1:03Overview of features
- 1:59Querying basic metrics
- 4:45Monthly order analysis
- 6:52Product category analysis
- 9:41Complex delivery metrics
- 15:04Building dashboards
- 16:42Future roadmap and conclusion
related talks
21mBuilding Frappe Insights — a FOSS BI tool
06mKeynote: Frappe Insights
18mEmpowering Business Through Data
01h 06mBig Ways Small Businesses are Leveraging Analytics to Gain Insights
48mPower BI for Developers
35mUrungi, Dashboard Builder and Business Intelligence Software
22mBuilding Interactive Grafana Dashboards for Business Intelligence
25mData interpretation for B2B SaaS tools: how to bring informed business decisions