DataMill

Contoso Coffee pipeline

Python ETL pipeline: messy CSV, Excel, and API data into a tested star schema with data-quality gates.

extract land validate quarantine transform load dq publish manifest

Runs

30

Rows processed

3095

Rows quarantined

399

DQ pass rate

7/8

Period 2026-09-01 to 2026-09-30. Stores 12. Elapsed seconds 55.272. Peak RSS bytes 152363008.

Store-day revenue

2026-09-01 2026-09-02 2026-09-03 2026-09-04 2026-09-05 2026-09-06 2026-09-07 2026-09-08 2026-09-09 2026-09-10 2026-09-11 2026-09-12 2026-09-13 2026-09-14 2026-09-15 2026-09-16 2026-09-17 2026-09-18 2026-09-19 2026-09-20 2026-09-21 2026-09-22 2026-09-23 2026-09-24 2026-09-25 2026-09-26 2026-09-27 2026-09-28 2026-09-29 2026-09-30

Weekly top products

LAT-002 ESP-001 MOC-001 COL-002 LAT-001 CAP-001 TEA-002 COL-001