Superstore Dashboard
fellowship assignment
A24’s Next Film
Fellowship Mid-Cycle Project
The team
Krys Rilloraza, Cindy Celedonio, Kabelo Muhammad, and Ramon Quinto.
the business task
Step into the shoes of data consultants for A24 to analyze box office performance data to help them decide the direction of their next film project.
key findings
Horror films consistently yield the highest return on investment (ROI). Certain actors (Suzan Crowley, Shelley Hennig, and Annabelle Wallis) and directors (Levan Gabriadze, William Brent Bell, and John Leonetti) were associated with top returns. A Friday release in the summer proved to be the sweet spot for box office success.
Finding the Formula to Charting on Spotify
personal project
About Spotify
Spotify is a digital music streaming service that offers access to millions of songs, podcasts, and videos. Spotify boasts a library of over 70 million songs from a diverse range of record labels and media companies. Spotify also has a large number of playlists created by users and the Spotify algorithm.
The Business Task
What are the trends in the top 1000 songs of 2023?
How can these trends be applied to future songs?
How can these trends influence Spotify's marketing strategy?
Key Findings
BPM, key, and mode have greater impacts on the performance of the song.
-
BPM: it's best not to slow down too much.
-
Key: the key of C# is the most used key of best-performing songs.
- Mode: songs in a major key tend to perform better.
Analyzing Spotify’s Most Streamed Songs of 2024
personal project
About Spotify
Spotify is a digital music streaming service that offers access to millions of songs, podcasts, and videos. Spotify boasts a library of over 70 million songs from a diverse range of record labels and media companies. Spotify also has a large number of playlists created by users and the Spotify algorithm.
methodology
Cleaned and transformed raw streaming data in MySQL by standardizing formats, removing duplicates, converting data types, and creating a staging table to isolate and analyze Spotify-specific metrics for 2024’s most streamed songs.
Analyzed artist performance, track popularity, playlist metrics, and temporal trends to uncover insights on music release strategies, streaming behavior, and content patterns using advanced SQL queries.
Bellabeat Analysis
Capstone Project
About Bellabeat
Urška Sršen and Sando Mur founded Bellabeat, a high-tech company that manufactures health-focused smart products. Sršen used her background as an artist to develop beautifully designed technology that informs and inspires women around the world. Collecting data on activity, sleep, stress, and reproductive health has allowed Bellabeat to empower women with knowledge about their own health and habits. Since it was founded in 2013, Bellabeat has grown rapidly and quickly positioned itself as a tech-driven wellness company for women.
The Business Task
What are some trends in smart device usage?
How could these trends apply to Bellabeat customers?
How could these trends help influence Bellabeat’s marketing strategy?
Key Findings
Sleep:
- The participants were not receiving the CDC-recommended 7-8 hours of sleep per day on the weekdays.
- More daily sedentary hours may decrease the hours of sleep. Although there is not enough data to confirm this correlation is causation.
-
There is an increased step count and intensity level of activities around 5-7 pm daily.
-
Participants are not reaching the 10,000 daily step count the CDC recommends.
- There are fewer steps taken during the weekdays and on Sundays. Participants are sedentary for an average of 16 hours per day.
© 2025 Rilloraza