This project is delivered as 4 connected data products, each broken down into Epics → Tasks, tracked in Notion + Jira with an iteration/backlog workflow.

The delivery sequence follows the pipeline: Extract & Load (Python) → Raw (BigQuery) → Transform (dbt + tests) → BI (Power BI), with automation (n8n / dbt Cloud jobs).

Scope of the moment

✅ Included: Sprint 1 (A1–A4) + Sprint 2 (B1–B4)

⏸ Not covered here (planned next): Sprint 3 automation (C1–C4) + Sprint 4 (DX)

Milestones (high-level)

Milestone 1 — Library MVP shipped (Sprint 1)

• Takeout library loaded to BigQuery (raw_library)
• Spotify enrichment for genres (raw_spotify_genres_library + genre_lookup)
• dbt models + tests → mart_library
• Power BI Library dashboard MVP

Milestone 2 — Listening History enrichment baseline (Sprint 2 up to B2)

• Takeout history parsed + loaded (raw_history)
• Spotify enrichment reused for history (raw_spotify_genres_history, reuse genre_lookup)
• dbt models + tests → mart_library