{"repo":"frappe/insights","free":true,"listed":false,"github":"https://github.com/frappe/insights","clone":"git clone https://github.com/frappe/insights.git","description":"Open Source Business Intelligence Tool","language":"Python","stars":1004,"topics":["data-analytics","data-visualization","erpnext","frappe-framework","analytics","business-intelligence","frappe","duckdb","echarts","bi"],"license":"AGPL-3.0","category":"analytics","readme_excerpt":"Frappe Insights Open Source Business Intelligence Tool Live Demo - Website - Documentation Frappe Insights Insights is a 100% open-source BI tool designed to make data analysis and reporting more accessible to technical as well as non-technical users. Screenshots Motivation Building custom apps or creating structured data has been very easy with Frappe Framework. However, extracting information from these apps was not a very good experience. Users needed to know how to write SQL queries to create reports to gain valuable information from the data. So I wanted to improve the experience of building these reports and dashboards for everyone in 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 : You can use the query builder to create queries without any SQL knowledge. The interface provides a step-by-step approach for building queries, allowing 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 dat","default_branch":null,"files":null,"tree":[],"storefront":"/r/frappe","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/frappe/insights/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}