MetallicAnalysis

Heavy Metal Business Intelligence: A Visual Data Exploration of Metallica's 30 Years on the Road

[twitter float="right" size="medium" text="Heavy Metal Business Intelligence: A Visual Data Exploration of @Metallica's 30 Years on the Road" style="vertical"] Little Data Project of mine that has grown considerably since it was launched. Here are all my Tableau visualizations for Metallica Touring and Song Metrics (or whatever you want to call them). It's a big data mash-up built and maintained using Python scripts, Microsoft SQL Server, Excel, some manual research, data warehousing and (of course) Tableau Public - but I'll keep all the tech-y stuff for a different page, this one is all about the data. [box type="tick"]UPDATE: I'm "Smart Filtering" by visitor country using dynamic Tableau parameters now. Looks like you're from [wpgc_country_name]. If that's all you want to see, then please check out the "Shows in Your Country" page below for [wpgc_country_name] shows![/box]

"Bay Area Thrash since 1981""

In the above dashboard you can see a VERY high level overview of Metallica's live career. If you click on a point on the line graph it will change all the other windows to align with shows from that year. [box type="note"]NOTE: All these reports are constantly changing and being added to, this is my attempt at organizing some of them in a more "visual" way so that the more standout and newest reports will be easy to find.[/box]

For other Metallica analytics, reports, setlists and views - see below

[twocol_one]

Song Trending Over Time

Interactive graph showing song trending over time, sliced by album (with calculated trend lines). Note: Only songs that were actually played will show up. [/twocol_one] [twocol_one_last]

Member Timeline

Simple interactive timeline (in gantt chart form) of the different Metallica members and their time with the band. [/twocol_one_last] [hr] [twocol_one]

Historical Setlist Analysis

Interactive graph and cross-tab showing the songs that were performed at a particular show, as well as the historical breakdown of each song. Percentile, probability, and literal "rarity" of that song on that night (based on all previous shows before that night - more info about the calculation here; geek alert). [/twocol_one] [twocol_one_last]

Shows in [wpgc_country_name] (Your Country)

Map of shows (by city) in your country. If your country was incorrect, or you just want to browse the globe, use the "Country" drop-down to change focus. ("your country" calculated by ip address, so it might not be 100% correct in all instances) [/twocol_one_last] [hr] [threecol_one]

Song Frequency

Interactive chart showing how many times each song has been played over Metallica's history of live shows. Filterable by Album, Tour and / or Year of show. [/threecol_one] [threecol_one]

Visual Setlist Analysis

A work in progress - this data will be in a much more useful and user friendly report soon. A drill down map in order to filter to a specific list of shows at a venue. Percentiles calculated for each song on the setlist, showing the "rarity" of that song at that point in time. (For a better explanation see this post on the calculation that was done) [/threecol_one] [threecol_one_last]

Setlist Analysis of Last Show

Another work in progress Setlists analysis of the last show Metallica has played. Percentiles calculated for each song on the setlist, showing the "rarity" of that song at that point in time. (For a better explanation see this post on the calculation that was done) [/threecol_one_last] [hr] [threecol_one]

Showing only the shows that took place in your country, [wpgc_country_name] (by city). Country code figured out automatically using you ip address. [/threecol_one_last] [hr] Looking for Metallica shows in Argentina, Australia, Austria, Belgium, Brazil, Bulgaria, Canada, Chile, Colombia, Costa Rica, Croatia, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Guatemala, Hungary, Iceland, India, Indonesia, Ireland, Israel, Italy, Japan, Latvia, Lithuania, Mexico, New Zealand, Norway, Panama, Peru, Philippines, Poland, Portugal, Puerto Rico, Romania, Russia, Serbia, Singapore, Slovakia, Slovenia, South Africa, South Korea, Spain, Sweden, Switzerland, Thailand, The Netherlands, Turkey, UK, [USA](/archive/metallica-shows-in-united/ states "Metallica Shows In USA"), Venezuela? [hr]

Even More Metallica Reports, Setlist, Analytics:

[threecol_one]

[/threecol_one] [threecol_one] [/threecol_one] [threecol_one_last] [/threecol_one_last] [hr] [fbshare] [digg style="compact" float="left"] [pinterest float="left"]