IDL Performance Analytics β Data Engineering & Music Analysis
Turning dance competition data into something you can actually explore.
A data pipeline and analytics workflow around International Dance League performances, connecting competition results with song-level metadata to understand performance and music-selection patterns.
- Engineered a Python/Pandas pipeline that validated and normalized 45 verified performances and 68 songs into BigQuery tables
- Designed a 10-table BigQuery warehouse: song and performance dimensions and facts, MusicBrainz enrichment, and derived tables for team genre mix, music strategy, and event trends
- Wrote 4 SQL analytical views using joins, aggregations, and window functions to analyze team scores, song usage, and competition-level music trends
- Enriched 57 of 68 songs (84%) with MusicBrainz release date, genre, and artist metadata
- Shipped 2 BigQuery-connected Tableau dashboards (so far) covering team performance and song-selection patterns