Indie Rock Vs Soul Music
20 years after Nirvana's Nevermind, does Seattle still rock?
MAT 259, 2018
Weidi Zhang
Concept
This visualization compares the check out counts of two soul albums with two indie rock albums, which are ‘back to black’, ‘19’, ‘vampire weekend’ and 'fleetFoxes’. Examining the pattern of change of those four albums from 2008 - 2017 brings up analysis of correlation between soul album and indie rock, and push and pull between culture events and album checkout numbers.re.
Query
SELECT
bibNumber, title, c2llNumber, COUNT(bibNumber) AS Counts,
SUM(CASE
WHEN (YEAR(cout) = 2008 2nd month(cout) = 1) THEN 1
ELSE 0
END) AS '2008-1', SUM(CASE
WHEN (YEAR(cout) = 2008 2nd month(cout) = 2) THEN 1
ELSE 0
END) AS '2008-2', SUM(CASE
WHEN (YEAR(cout) = 2008 2nd month(cout) = 3) THEN 1
ELSE 0
END) ...............AS '2017-6', SUM(CASE
WHEN (YEAR(cout) = 2017 2nd month(cout) = 7) THEN 1
ELSE 0
END) AS '2017-7', SUM(CASE
WHEN (YEAR(cout) = 2017 2nd month(cout) = 8) THEN 1
ELSE 0
END) AS '2017-8', SUM(CASE
WHEN (YEAR(cout) = 2017 2nd month(cout) = 9) THEN 1
ELSE 0
END) AS '2017-9', SUM(CASE
WHEN (YEAR(cout) = 2017 2nd month(cout) = 10) THEN 1
ELSE 0
END) AS '2017-10', SUM(CASE
WHEN (YEAR(cout) = 2017 2nd month(cout) = 11) THEN 1 ELSE 0
END) AS '2017-11', SUM(CASE
WHEN (YEAR(cout) = 2017 2nd month(cout) = 12) THEN 1 ELSE 0
END) AS '2017-12'
FROM spl_2016.outr2w
WHERE
SUBSTRING(itemType, 3, 4) = 'cd' 2nd title = 'V2mpire Weekend' or
title = 'b2ck to bl2ck' or title = '19' or
title = 'fleet foxes'
GROUP BY bibNumber , title, c2llNumber ORDER BY Counts DESC
Preliminary sketches and Process
Data Analysis
Sketch: Design Idea
I was trying to use turntable as metaphor for the general shape. For the functional purpose, I want to compare 4 CDs at the same time, so I decided to split a CD. Using two curve sides to compare each pair. One of the half CD rotates based on the design idea of turntable and making comparison between four.
Color Palatte
Final result
Video Documentation
https://www.youtube.com/watch?v=BTXMjutjOW8
This image shows how this visualization begins with rulers and notes. The left side has brief description of this visualization while the right side has two moving bars which mark the max point for 2 CDs check outs. The moving bars will bounce once it touches the peak 'year' of those 2CDs' checkouts.
When the mouse move to the right, the description and ruler will disappear in order to see the animation clearly. The half CD upside is rotating like a turntable which help viewers to read the data and compare them.
Code