Skip to main content

Using Power BI to visualize your music collection

Headshot of article author The Power BI Team

Jeroen Ter Heerdt, Technology Advisor Business Intelligence at Microsoft and part time Power BI Rockstar decided a couple of months ago to use Power BI and visualize his music collection using Power BI and this was the result.

Tapping into the data behind his MP3 collection ID3 tags, he exported a CSV file with all the information. Later, he imported the data using Power Query into Excel, creating new calculated columns such as record cover image paths, date, years and bitrate and changing their data types before even having a spreadsheet. Later, using Power View, he was able to create some interesting visualization to get insights about the music he likes.

Here are some visualizations we has able to put together:

1)      Number of tracks per release year

Count of track by year in a line graph

Apparently most the tracks in his collection were released around 2000, while the oldest track I have has been released in 1930.

2)      Number of tracks per genre over time

This clearly shows that in 1978 the rock genre was most popular (at least in the albums in his collection). However, the Disco songs were the longest on average.

The play axis at the bottom allows us to play through his collection over time.

3)      Number of albums per genre per year

In 1983 the most popular artist was Kajagoogoo and you also get an idea of what the popular genre was

4)      Albums by genre and artist of time

This shows the progressive rock genre and when it was popular. Also it shows which artists released albums categorized as progressive rock and which albums I have of that artist (in this example Yes).

Check Jeroen’s complete step by step guide in his blog

And don’t forget to watch the April 15th Accelerate your insights event live from San Francisco, California –  Hear from CEO Satya Nadella, COO Kevin Turner, and CVP Quentin Clark and learn how to transform data into action by combining the power of SQL Server 2014 with the familiarity of Power BI for Office 365.