Project field note
Spotify Billboard Analytics
A project pairing Spotify audio features with Billboard Hot 100 chart data, backed by PostgreSQL 16 on AWS RDS with a Node/Express API, a React + Recharts frontend, and a Python/pandas cleaning pipeline.
A music analytics application built as a database systems course project, joining Spotify audio features with Billboard Hot 100 chart history to explore how a song's characteristics relate to its chart performance.
The backend runs PostgreSQL 16 on AWS RDS with a Node/Express API, and a Python and pandas pipeline cleans and loads the raw data. The schema normalizes four core tables to 3NF and uses GiST/GIN indexes, pg_trgm for fuzzy text search, materialized views for heavy aggregates, and a k-NN similarity query for finding songs with similar audio profiles.
The frontend is built in React with Recharts. I owned the Trends and Analytics visualizations, turning the query results into interactive charts.
As a graded course assignment, the source code cannot be shared publicly under course policy.