Data Analyst / Engineer · projects

Data Analyst / Engineer: projects

Three portfolio projects for SabziSathi, a fictional fresh-vegetable delivery service in Pune, plus the capstone that brings them together. All three use one practice kit that runs entirely on your own computer with Python, DuckDB and dbt, and its tests tell you when each project is finished.

How the capstone relates to the projects: the capstone is not a fourth build. It is the three projects finished in the same kit, all 28 tests passing together, plus design notes, a demo, case studies and an honest self-review. Build the projects in order (the pipeline, then the warehouse, then the dashboard), then complete the capstone self-check.

Before any project: download the starter kit, follow sabzisathi/README.md, and check that python -m pipeline.run --all and dbt build --profiles-dir . (in warehouse/) finish. Everything in the kit is invented: the customers, phone numbers (+91 00000 ...), emails (@example.com) and orders are generated with a fixed seed, and the warehouse is a file on your computer. Passing its tests shows your work handles these cases; it doesn't prove a cloud warehouse, a BI tool or a GitHub schedule is set up correctly.

Starter files for every project: download the zip.