SQL WORk examples
Executed over 200 professional-grade SQL queries across diverse datasets throughout the semester. Projects included advanced use of joins, subqueries, and data filtering techniques. Worked with databases containing medical, sales, and human resources data.
Power BI Dashboards
This project visualizes over a century of global book sales and publishing trends using interactive data dashboards. Drawing on data from 1900–2016, the analysis highlights patterns in gross sales, publishing language, genre performance, and author popularity.
Insights
Genre comparison: Fiction far exceeds nonfiction and children’s literature in total revenue.
Interactive filters compare favorite authors (e.g., Agatha Christie, Stephen King, Sarah J. Maas) across sales, ratings, and publishing languages.
Amazon Digital Services and Penguin Group lead in total units sold, revealing market dominance of digital distribution.
A focused analysis of Nicholas Sparks’ top ten titles visualizes how average book ratings and sales evolved by year and publisher.
The Information flow of the CU Student AMbassadors
As part of the Information Ecosystems capstone project, I collaborated in a team to analyze the information ecosystem of CU Boulder's Student Ambassadors. We conducted 30-minute interviews with ambassadors and leaders to examine how information is collected, shared, and utilized within their organization. We synthesized findings using a Miro board to map workflows, identify bottlenecks, and visualize communication patterns. We delivered a final presentation with strategic recommendations aimed at improving organizational efficiency and enhancing internal information flow.
Data JourneyS
Analysis
The Tortured Data Scientists Department
A final project data analysis of Spotify Taylor Swift data of her different songs/albums and their overall valence/tempo/feeling, and their individual popularity. I utilized web scraping on Kworb.net to get a daily update for Taylor’s songs. I was most motivated by Red (Taylor’s Version), having the highest overall valence (happiest-sounding), which is her most brutal breakup album (excluding The Tortured Poets Department).
How might we investigate which of Taylor Swift’s albums/songs are the most popular, and how does that vary over time?
This Taylor Swift data analysis project provided insights into how different metrics influence perceptions of popularity. While Red (Taylor’s Version) appeared to be her most popular album based on cumulative streams at the time, further analysis revealed that Lover holds a stronger position in terms of sustained popularity. Additionally, tracking daily streaming trends highlighted the rapid rise of her latest release, The Tortured Poets Department, which led in daily stream volume. Based on these patterns, I predict TTPD may surpass Red (Taylor’s Version) in long-term popularity.
Self Collected Data and Habit Analysis
Collected and analyzed self-tracked data on my listening habits of artist Renée Rapp in the weeks leading up to her concert. The project explored patterns in frequency, timing, and context of music engagement to better understand personal listening behavior. Insights from this analysis informed reflections on music consumption trends and the emotional and situational factors that influence media habits.
