Building Frappe Insights — a FOSS BI tool

on YouTube ↗21m

" summary

An open-source BI tool called Frappe Insights gets built end-to-end: a query doctype that generates SQL from selected tables, columns and conditions, a charting/dashboard layer that previews rows and columns, and a backend using SQLAlchemy which lets users run native SQL, joins across three or four tables, and import Excel into a local SQLite store. Cross-database joins work by materializing datasets into a local store today and move toward a virtual database that runs identical queries across sources; it runs in production internally and powers a Marketplace app.

AI-written summary · about

" chapters (5)

1. 0:00Introduction
2. 0:22Who am I
3. 5:43Charts
4. 11:42Query Builder
5. 13:54Cross Database Joins

" related talks

• 18mIntroducing Frappe InsightsSaqib Ansari, Hussain Nagaria · ERPNext Conference 2022
• 06mKeynote: Frappe InsightsShazeel Ansari · Frappeverse India 2025
• 14mThe FOSS JourneyPrssanna Desai · FOSS Hack 2020
• 13mThe FOSS Superpower Kit: Build, Ship & Grow with FrappeHussain Nagaria · ERPNext Conference 2022
• 35mUrungi, Dashboard Builder and Business Intelligence SoftwarePaul Poulain · DevOps D-DAY 2019
• 11mProjects at FrappeShivam Mishra · IndiaOS 2020
• 22mBuilding Interactive Grafana Dashboards for Business IntelligenceChris Shih · GrafanaCON 2024
• 59mA pragmatic approach to turn your data into actionable insightsIrina Dragunova · NDC London 2021