Frappe Insights

Frappe Insights is an open-source business intelligence tool. It provides a web-based interface for connecting disparate data sources, performing complex analysis, and creating visual reports to support business decision making.

The software is deployed as a server-side application and can be hosted via Frappe Cloud or self-hosted using Docker and the Frappe Framework. It is designed for both technical users who prefer writing SQL and non-technical users who require a visual interface for data extraction and reporting. This makes it suitable for teams that need to democratize data access across different skill levels within an organization.

Key features

• Integration of data from multiple databases, files, and spreadsheets
• Visual query builder for creating queries without SQL knowledge
• Step-by-step interface for selecting tables, adding joins, and applying filters
• Data visualization using a variety of charts and graphs
• Automated suggestions for the best chart type based on the result set
• Drag-and-drop dashboard creation with applicable filters
• Support for MySQL, PostgreSQL, DuckDB, and BigQuery databases

The application is built on the Frappe Framework, a full-stack web application framework, and uses Frappe UI, a Vue-based library, for its user interface. It utilizes the Ibis library to compose SQL queries through dataframe APIs and employs eCharts for interactive data visualization. This architecture allows the tool to integrate closely with other Frappe-based applications, such as ERPNext, simplifying the process of extracting information from structured data apps that previously required manual SQL reporting.

Frappe Insights serves as a flexible BI layer for organizations seeking a self-hosted solution for data analytics and reporting. It positions itself as a bridge between raw database storage and actionable business insights.