Overview

Open Source Business Intelligence Tool An easy-to-use, open-source business analytics tool designed to help businesses make the most of their data. It enables you to connect data across multiple sources, analyse them, and derive valuable insights to make informed decisions for faster growth. The project has 877 GitHub stars and is licensed under AGPL-3.0.

Key Features

Source: GitHub README

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 databases. More database integrations are planned for the future.

Getting Started

Source: GitHub README

    mkdir frappe-insights
    cd frappe-insights

    # Download the docker-compose file
    wget -O docker-compose.yml https://raw.githubusercontent.com/frappe/insights/develop/docker/docker-compose.yml

    # Download the setup script
    wget -O init.sh https://raw.githubusercontent.com/frappe/insights/develop/docker/init.sh
    ```

docker compose up -d


## Normalized Features

*Source: tool-features-normalized.json*

docker, docker compose, mysql, postgresql.

<DeploymentOptions slug={frontmatter.slug} />

Replaces

Related Analytics & Business Intelligence Tools

View all 176 →

Superset

71K

Apache Superset is an open-source data exploration and visualization platform — connect to any SQL database, build interactive dashboards, and run ad-hoc queries.

analytics Apache-2.0

OpenBB

63K

The open-source AI workspace for finance — connect proprietary and public data, build custom analytics apps, and deploy AI agents on your own infrastructure.

analytics

Metabase

46K

Open-source business intelligence that lets anyone in your company ask questions and learn from data. Build dashboards, run queries, and share insights without SQL.

analytics

ClickHouse

46K

Ultra-fast column-oriented database for real-time analytics. Process billions of rows per second with SQL. Open-source alternative to Snowflake and BigQuery.

analytics Apache-2.0