EcoMetrics - A DBT Powered ESG and Supply Chain analysis tool.

:rocket: [Show and Tell] EcoMetrics: Open-Source ESG & Finance Dashboards for Data Nerds :seedling::bar_chart:

Hey Streamlit friends! :waving_hand:

I’m excited to share something I’ve been hacking on: EcoMetrics – an open-source platform for exploring Environmental, Social, and Governance (ESG) data alongside financial analytics. If you’re into data, sustainability, or just love building dashboards, I think you’ll enjoy this!

:glowing_star: What is EcoMetrics?

EcoMetrics is a playground for sustainability and business data. It’s built with Streamlit, dbt, DuckDB, and a bunch of Python data tools. The goal? Make it easy (and fun) to analyze ESG and financial metrics, whether you’re a data engineer, analyst, or just curious.

:desktop_computer: Live Demo

:backhand_index_pointing_right: Check out the live app!

:puzzle_piece: Features

  • Sustainability Analytics: Emissions, renewable energy, water use, and more

  • Financial Dashboards: Revenue, profit, cost breakdowns, trends

  • Supply Chain Insights: Inventory, material flow, operational efficiency

  • Customer Analytics: Segmentation, LTV, sustainability preferences

  • Interactive Visuals: Real-time charts, filters, drill-downs, and exports

:hammer_and_wrench: Under the Hood

  • Streamlit for the UI

  • dbt for data transformation & testing (105+ tests!)

  • DuckDB as the database

  • Pandas, Plotly, NumPy, Scikit-learn for analysis

:man_running: Run It Yourself

Want to poke around or extend it? Here’s how:

git clone https://github.com/connerkup/bi-portfolio.git
cd bi-portfolio
pip install -r requirements.txt
cd dbt && dbt deps && dbt run && dbt test
cd ../ecometrics && streamlit run Home.py

Then head to http://localhost:8501 in your browser.

:thinking: Why Bother?

  • Learn modern data engineering: dbt + DuckDB + Streamlit = :heart:

  • Experiment with ESG analytics: A hot topic in business & tech

  • Portfolio project: Steal ideas, fork it, or use it as a template!

:open_hands: Let’s Collaborate!

This is a portfolio project, but I’d love feedback, questions, or PRs. If you have ideas for new metrics, want to add data sources, or just want to chat about data stuff, let me know!

GitHub: connerkup (Conner Kupferberg) · GitHub


Built with :hot_beverage:, Streamlit, and a lot of pandas :panda:

1 Like