Diesi Analytics

Shows a radio station what it plays: dashboards over roughly 337,000 historical song plays expose rotation patterns by song, artist and time of day. SQL aggregations and predictive models explore what may play next.

Implementation Link to heading

• Queried roughly 337,000 play records by artist, song and time window for interactive dashboards.
• Used Redis caching for heavier aggregate queries and ECharts for exploration.
• Explored Markov-chain and time-aware next-song predictions alongside live now-playing data.

Links Link to heading

• Live Demo