mongo-to-postgres-etl icon indicating copy to clipboard operation
mongo-to-postgres-etl copied to clipboard

Set up a Cost-Effective Modern Data Stack for a Charity

Analytics La Porte Bleue

Modern Data Stack for a Charity

Get started with a cost-effective modern data stack using this repo. Read more about the project in my blog post here.

This repo helps bootstrap the infrastructure of a charity's modern data stack known as La Porte Bleue.

Architecture

  1. Ingestion: Python (PyMongo & SQLModel)
  2. Orchestration: Prefect
  3. Warehousing: Heroku Postgres
  4. Transform: dbt
  5. Business Intelligence: Preset