Top 16 Python Business Intelligence Projects

Business Intelligence

• Add a project

1. MindsDB

   1 95 39,289 9.9 Dockerfile

   General-purpose AI designed for knowledge workers — creators, strategists, and operators — and individuals seeking AI systems they can truly control to help them get work done, with full flexibility to extend and deploy anywhere (VPC, on-prem, or cloud).

   

   Project mention: MindsDB Supercharges Google's MCP Toolbox with Unstructured Data Support | dev.to | 2025-12-29

   We’re happy to announce that we’ve integrated MindsDB with Google's open-source project, MCP (Model Context Protocol) Toolbox. This will make your AI applications very, very smart. This enhancement expands the Toolbox's reach, especially for organizations grappling with lots of siloed data.

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. Redash

   2 41 28,621 8.7 Python

   Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

   

4. WrenAI

   3 11 15,453 9.6 Python

   Give AI agents the context to query business data correctly through the open context layer that gives AI agents grounded, governed memory, context, SQL across 20+ data sources, that helps you build agentic GenBI, text-to-sql, dashboards, and agentic analytics.

   

   Project mention: Revolutionize Your Data Workflow with Wren AI: The Open-Source GenBI Agent | dev.to | 2025-09-01

   View the Project on GitHub

5. metricflow

   4 7 1,615 9.2 Python

   MetricFlow allows you to define, build, and maintain metrics in code.

   

   Project mention: Implementing a Centralized Metrics Layer with dbt and a Semantic Layer | dev.to | 2026-04-21

   Sources: dbt Semantic Layer | dbt Developer Hub - Description of the dbt Semantic Layer and how it centralizes metric definitions and serves downstream tools. About MetricFlow | dbt Developer Hub - Explanation of MetricFlow, its role in query generation and metric definitions, and dbt version requirements. Creating metrics | dbt Developer Hub - Specification for metric YAML definitions, supported metric types, and usage guidance. Consume metrics from your Semantic Layer | dbt Developer Hub - Integrations, APIs (JDBC/GraphQL/Python SDK), and approaches for consuming metrics in BI and downstream tools. Administer the Semantic Layer | dbt Developer Hub - Operational docs for configuring credentials, tokens, and deployment prerequisites for the Semantic Layer. What’s new in dbt - July 2025 | dbt Labs - Notes on recent integration additions (including Power BI preview) and platform updates relevant to semantic layer consumption. Fables and Facts - Kimball Group - Foundational guidance on dimensional modeling and the principle of modeling at atomic grain for flexibility and trust. A Comprehensive Guide to dbt Tests to Ensure Data Quality | DataCamp - Practical guide to dbt schema and custom tests, and how to run and automate them. Use GX with dbt | Great Expectations - Integration patterns and examples for expressive data validations alongside dbt workflows. Ingest Lineage from dbt | OpenMetadata docs - How to extract lineage from dbt artifacts (manifest.json, compiled_code) and requirements for lineage capture. Semantic Layer Guide: Definition, Benefits, & Implementation | Atlan - Practical discussion on semantic layer benefits, governance considerations, and adoption strategies.

6. retentioneering-tools

   5 1 889 0.0 Python

   Retentioneering: product analytics, data-driven CJM optimization, marketing analytics, web analytics, transaction analytics, graph visualization, process mining, and behavioral segmentation in Python. Predictive analytics over clickstream, AB tests, machine learning, and Markov Chain simulations.

   

7. dbt-metabase

   6 1 603 7.5 Python

   dbt + Metabase integration

   

8. panel-graphic-walker

   7 2 353 4.4 Python

   A project providing a Graphic Walker Pane for use with HoloViz Panel.

   

9. datasette-dashboards

   8 2 176 8.9 Python

   Datasette plugin to create interactive dashboards

   

10. prosto

    9 9 93 3.6 Python

    Prosto is a data processing toolkit radically changing how data is processed by heavily relying on functions and operations with functions - an alternative to map-reduce and join-groupby

    

11. datafluent_pg

    10 3 27 5.4 Python

    Build a better understanding of your data in PostgreSQL.

    

12. gitbi

    11 2 14 7.8 Python

    Lightweight BI app based on git repo

    

13. Webtap.ai

    12 0 12 2.5 Python

    AI web scraping python library for efficient and reliable web scraping.

    

14. sdk

    13 1 6 8.7 Python

    Lightfeed SDK to search and filter web data (by lightfeed)

    

15. saisika

    14 1 1 7.7 Python

    Offline supply chain risk analyzer — drop Excel/CSV, get bullwhip detection, risk scoring & action recommendations. No cloud, fully local.

    

    Project mention: Saisca – offline supply chain risk analyzer (Excel/CSV → insights) | news.ycombinator.com | 2026-06-06

16. Tesla_Stock_Analysis

    15 1 0 4.3 Python

    Project Description: This project analyzes Tesla’s financial growth and stock performance from 2015 to 2024 using simulated real-world data. Python was used to generate and clean the dataset, while SQL helped extract key insights like revenue trends and profitability. The final interactive dashboard was built in Power BI,

    

    Project mention: Tesla Financial Analysis Dashboard using Python, SQL & Power BI | dev.to | 2025-08-30

    Check out the full project & GitHub repo here: [https://github.com/Tanu272004/Tesla_Stock_Analysis ]

17. Power-bi-report-visual-monitoring

    16 1 0 6.1 Python

    Power BI monitoring tool for automated report tracking, dashboard status monitoring, and refresh failure alerts with visual analytics

    

    Project mention: Power BI Visual Monitoring: Automatically Detecting Broken Visuals in Power BI Reports | dev.to | 2026-06-05

    GitHub: https://github.com/svergio/Power-bi-report-visual-monitoring Documentation: https://svergio.github.io/Power-bi-report-visual-monitoring/ Wiki: https://github.com/svergio/Power-bi-report-visual-monitoring/wiki

Python Business Intelligence related posts

• Implementing a Centralized Metrics Layer with dbt and a Semantic Layer

  1 project | dev.to | 21 Apr 2026

• Real-Time Data Monitoring Using InfluxDB and Grafana

  6 projects | dev.to | 14 Mar 2026

• Semantic Layer vs. Metrics Layer: What's the Difference?

  1 project | dev.to | 24 Feb 2026

• What's New in dbt 1.10

  1 project | dev.to | 27 Dec 2025

• Dbt Labs open source MetricFlow

  1 project | news.ycombinator.com | 14 Oct 2025

• Dbt no longer open source?

  2 projects | news.ycombinator.com | 4 Dec 2024

• ADA: Accelerate Data Analysis with AI

  3 projects | news.ycombinator.com | 22 Mar 2024
• A note from our sponsor - SaaSHub
  www.saashub.com | 11 Jun 2026

  SaaSHub helps you find the best software and product alternatives Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

Do not miss the trending Python projects with our weekly report!