Insights is a completely open-source Business Intelligence (BI) tool aimed at making data analysis and reporting accessible to both technical and non-technical users. The Frappe Framework simplifies the process of creating structured models and gathering data. However, users still need to write SQL queries to generate reports and extract information. Frappe Insights was developed to address this challenge and enhance the overall experience of building reports and dashboards for everyone on our team.

Key Features

• Connect Multiple Sources: You can integrate data from multiple databases, files and spreadsheets. Getting all your data into one place helps you analyse interconnected data.
• Query Builder: Frappe Insights has a user-friendly query builder interface that allows users to create queries without any SQL knowledge. The interface provides a step-by-step approach for building queries, empowering users to easily select tables, add joins, apply filters, perform calculations, and more.
• Visualizations and Dashboards: You can visualize the query results using a variety of charts and graphs. Frappe Insights also suggests the best chart for a given result set. You can create dashboards using a drag-and-drop interface and add filters on the dashboard to apply to the charts.
• Database Support: Frappe Insights currently supports MySQL, PostgreSQL, DuckDB, and BigQuery databases. More database integrations are planned for the future.