Chinook Digital Music Store
Data Analysis Project
Executed advanced SQL queries (MySQL) and Excel modeling to analyze a digital media store's multi-year sales performance, customer distribution, and catalog utilization.
- 43.4% of the 1,519-track catalog never generated a single sale
- 73.5% of revenue concentrated in just 4 genres
- Recommended acquisition pushes in Chile & Ireland + cross-sell to unlock dead inventory