3 min read

Aug 1, 2025

This data contains a spotify user’s complete music streaming history data, including timestamps, track, artist, and album names, and reasons for playing and ending each track. For the Maven Music Challenge, I analyzed this user’s streaming data to uncover listening habits, top artists and so on, Let’s dive into how this data story.

The dataset includes data on playback timestamps, platforms used, track names, artist names, album names, play durations, playback start and end reasons, shuffle mode, and whether tracks were skipped.

Before diving into analysis, thorough data cleaning and transformation were necessary to ensure accuracy and consistency. Here’s what was done:

Adjusted data types for key columns such as Track Name, Artist Name, and Album Name to text.

Divided the Milliseconds column by 1,000 to convert it into seconds, then added another column for play durations in minutes by dividing the seconds by 60.

Split the Timestamp column into separate Date and Time columns to facilitate time-based analysis.

Ensured data types were correctly assigned across all columns.

. The Beatles lead in this category by number of tracks.

. Other top artists include The Killers and John Mayer.

. The most-streamed albums include The Beatles and Past masters.

. The Beatles’ albums dominate the top three.

. The most streamed tracks include Ode to the moon and In the blood which was sang by The Strokes and John Mayers.

. The top skipped tracks are parasio and Photograph

This project revealed our listener’s deep connection to timeless classics and their love for music as a constant companion. From legendary artists like The Beatles and John Mayer, the data reflects personal tastes shaped by nostalgia.

The insights show how music brings comfort, joy, and peace, proving that great tracks remain timeless. The impact music has in our lives cannot be overemphasized.

Microsoft Excel: For initial data cleaning and preparation.

Microsoft Power BI: For advanced cleaning, transformation, analysis, and creating dynamic visualizations.

Figma: Designed the sleek dashboard background.