analytics: the summary

This is a summary post linking to the series of scrobbling analytics I did in December. Click on the images to jump to the posts:

The Summary: what’s the high level stats on each of the users
Part 2: Which albums have been listened to the most?
Part 3: Obsessions
Part 4: “I was a fan of that band before you”

Hey – make my life easier by hiding things before sending me your TWBX

Do you share your Tableau workbooks with colleagues?

Receiving a TWBX from a colleague requires some mental processing. Deciphering the views/dashboards is the main task. But it is made harder if  I also need to decipher the tabs at the bottom:

Tabs galore
  • How many views are there?
  • How many are relevant to me?
  • How many are dashboards?
  • Which of the views are on the dashboards?
  • Why didn’t they rename every sheet? Grrr.

I often receive TWBX files where the author really only wants me to look at one of two dashboards. But, if they don’t Hide all the worksheets on those dashboards – I have to trawl through every sheet to work out if it’s a separate thing to view or not.

The first thing I do when receiving a multi-tabbed TWBX is go to the slide sorter view and right-click every sheet to work out which ones I can hide.

My working day…

 My recommendation to you? Hide sheets that are on dashboards before sharing a TWBX – it makes your recipients’ lives easier! part 4: Well, *I* was a fan before you!

This is the final post in my scrobbling analysis. (click here for parts one, two  and three) Did you ever have the conversation that went “yeah, I know you like that band, but you know something, *I* was listening to that album way before you”. Well, now we have the data to see if that’s true or not.

In the viz below, I selected some of the albums that everyone in my data listened to. Check out the Feist album: Ben got obsessed with it way back in 2008 and hasn’t listened to it since. The rest of us: we’re playing catch-up.

Compare that to Hot Chip: Ben and HyperMusicX have pretty much listened to it as much as each other.

Click some of the other albums to see other interesting listening trends.

[sb name=”LastFmListeningHistory”]

Want more? Click here for parts onetwo , and three) part 3: obsessions

This is the third part of my analysis. (click here for parts onetwo , and four) In this post, I wanted to look at individual months and analyse how much we got obesessed with an artist in any given month.

This is the hardest viz to decipher. Each dot is a month of a user’s scrobbling history. The x-axis is the number of artists, so dots towards the right are months where the person listened to a larger variety of artists.

The y-axis is the total tracks for that month, so the higher up you go, the more the person listened to that month.

Therefore the dots that are proportionally high and to the left are ones where you had months that focussed on fewer artists. Click on the highlighted dot to see olorton’s Eels’ obsessed December!

You can also see interesting listening patterns. Click on benjaminf in the colour legend: he listens to LOTS of music, but his diversity (number of artists) is generally lower than everyone else. Then click on rich_81 – he has some very diverse months.

[sb name=”LastFmObsessions”]

Want more? Click here for parts onetwo , and four) part 2: Which albums have we listened to the most?

In part 2 of my analyses, we published a summary of 8 lastfm users’ scrobble history (click here for parts onethree and four). This time I want to focus on the albums they’ve listened to. In the dashboard below, the upper chart shows a line for every album each person has listened to. It represents cumulative listens to that album,

The dot plot below shows individual listening sessions to an album. As you can see, my most listened-to album is, ahem, Rolf Harris’ Greatest Hits, and it’s the most listened to by some significant margin! Click the different users to see their different listening habits.

[sb name=”LastFmEveryAlbumEveryPlay”]

Want more? Click here for parts onethree and four)

Really? Is *that* your favourite album? Playing with data (part 1)

Do you scrobble? I do, and my digital listening history is all up on I love having this historic record of all the music I’ve listened to. Using’s API, you can access all your music. Even better, you can get anyone’s listening history. And that means you can compare yourselves.

Thanks to the programming wizardry of my good friend Ben Foxall, I got full scrobbling history of myself and some friends. Here’s the outcome: 4 dashboards.

This is post one of a four post series. Click here for parts two three and four

(BTW – I’m TheGroover on

A summary

Let’s start with an summary of each person’s listening history. How many tracks? What time of day? Diversity? Top 10s? Check them out here:

[sb name=”LastFmOverview”]

Want more? Click here for parts two three and four)

The Economist thinks Chrome is the most popular browser. Well, is it?

In the Summer, The Ecomomist’s Graphic Detail posted a chart showing the growth of Chrome as the world’s most used browser. One of the commenters rubbished the stat by claiming the figures were taken from the wrong source.

Today, Jen Underwoord posted a twipic showing her own Google Analytics analysis:



I wondered what the story was with data from

The results are below. It seems that, yes, Chrome is by far the most popular browser for visitors to my company’s website:

[sb name=”WhichBrowser”]

I’m a Softwareentwickler (according to German TV!)

I was on German TV this week. ZDF’s Elektrischer Reporter did a show about big data. I talked about some of the risks, highlighting the infamous Target/pregnant teenager story. I’ve got a German voice track over my words, so German-speakers only if you want to understand what I’m saying. For the rest of you, click and skip to approx 12minutes 30s for my moment of fame, in a Tables In The East t-shirt!

Here’s the link:

Fullscreen capture 08122013 115759

Andy holding a moving screen