Goal (Sprint outcome)

Deliver a Listening History MVP: Takeout history → BigQuery raw → Spotify enrichment (genres) → dbt models + tests → Power BI dashboard.

User value

Enable quick answers to:

• “How has my listening evolved over time?” (trends, seasonality)
• “What do I replay vs discover?” (repeat listening patterns)
• “When do I listen?” (weekday/hour dimensions)
• “What genres dominate my listening (not just my saved library)?”

Sprint scope

Included Epics:

• B1 Parse & Load Google Takeout History
• B2 Spotify Enrichment for History
• B3 dbt Transformations for History
• B4 Listening Dashboard MVP

Listening History data flow (Sprint 2)

Google Takeout watch-history.json → raw_history

Spotify API enrichment → raw_spotify_genres_history (+ reuse genre_lookup)

dbt → staging + intermediate → fact_listening (+ tests + docs)

Power BI → Listening dashboard MVP