Computer Science

profilestevenoh893
IntroductiontoTableau-MusicSales3.twbx
Home>Computer Science homework help>Computer Science

Data/Introduction to Tableau - Music Sales - TfT.twb Files/Music Sales (Music Store.xlsx).tde

TwbxExternalCache/TwbxResultsCacheV3/1395811905/.bin

TwbxExternalCache/TwbxResultsCacheV3/1395811905/.key

2123622863593910 <pack class='dataengine' dbname='Data/Introduction to Tableau - Music Sales - TfT.twb Files/Music Sales (Music Store.xlsx).tde' ec-abstract-query='&lt;aq-cache-key are-all-local-sorts-supported=&apos;true&apos; has-agg-measure-filters=&apos;false&apos; has-lod-calcs=&apos;false&apos; has-user-reference=&apos;false&apos; ind-join-semantics=&apos;false&apos; start-of-week=&apos;sunday&apos; version=&apos;10.2&apos;&gt;&#10; &lt;query aggregation=&apos;true&apos; caching=&apos;normal&apos; hierarchize-rows=&apos;false&apos; include-empty=&apos;true&apos;&gt;&#10; &lt;fields&gt;&#10; &lt;output column=&apos;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&apos; /&gt;&#10; &lt;/fields&gt;&#10; &lt;/query&gt;&#10; &lt;relation-xml&gt;&amp;lt;relation name=&amp;apos;Extract&amp;apos; table=&amp;apos;[Extract].[Extract]&amp;apos; type=&amp;apos;table&amp;apos; /&amp;gt;&amp;#10;&lt;/relation-xml&gt;&#10; &lt;relation-names&gt;&#10; &lt;relation-name key=&apos;[Album]&apos; value=&apos;[Extract].[Album]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Artist]&apos; value=&apos;[Extract].[Artist]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Bytes]&apos; value=&apos;[Extract].[Bytes]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Calculation_1800807123004051]&apos; value=&apos;[Extract].[Calculation_1800807123004051]&apos; /&gt;&#10; &lt;relation-name key=&apos;[City]&apos; value=&apos;[Extract].[City]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Company]&apos; value=&apos;[Extract].[Company]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Composer]&apos; value=&apos;[Extract].[Composer]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Country]&apos; value=&apos;[Extract].[Country]&apos; /&gt;&#10; &lt;relation-name key=&apos;[CustomerID]&apos; value=&apos;[Extract].[CustomerID]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Email]&apos; value=&apos;[Extract].[Email]&apos; /&gt;&#10; &lt;relation-name key=&apos;[FirstName]&apos; value=&apos;[Extract].[FirstName]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Genre]&apos; value=&apos;[Extract].[Genre]&apos; /&gt;&#10; &lt;relation-name key=&apos;[InvoiceDate]&apos; value=&apos;[Extract].[InvoiceDate]&apos; /&gt;&#10; &lt;relation-name key=&apos;[InvoiceID]&apos; value=&apos;[Extract].[InvoiceID]&apos; /&gt;&#10; &lt;relation-name key=&apos;[LastName]&apos; value=&apos;[Extract].[LastName]&apos; /&gt;&#10; &lt;relation-name key=&apos;[MediaType]&apos; value=&apos;[Extract].[MediaType]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Milliseconds]&apos; value=&apos;[Extract].[Milliseconds]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Number of Records]&apos; value=&apos;[Extract].[Number of Records]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Phone]&apos; value=&apos;[Extract].[Phone]&apos; /&gt;&#10; &lt;relation-name key=&apos;[PostalCode]&apos; value=&apos;[Extract].[PostalCode]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Quantity]&apos; value=&apos;[Extract].[Quantity]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Region]&apos; value=&apos;[Extract].[Region]&apos; /&gt;&#10; &lt;relation-name key=&apos;[State]&apos; value=&apos;[Extract].[State]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Track]&apos; value=&apos;[Extract].[Track]&apos; /&gt;&#10; &lt;relation-name key=&apos;[UnitPrice]&apos; value=&apos;[Extract].[UnitPrice]&apos; /&gt;&#10; &lt;/relation-names&gt;&#10; &lt;bindings&gt;&#10; &lt;binding key=&apos;[cnt:TEMP(row count)(290714814)(0):qk]&apos; value=&apos;cnt:TEMP(row count)(290714814)(0):qk&apos; /&gt;&#10; &lt;/bindings&gt;&#10; &lt;lod /&gt;&#10; &lt;measure-filter-lod /&gt;&#10; &lt;output&gt;&#10; &lt;column&gt;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&lt;/column&gt;&#10; &lt;/output&gt;&#10; &lt;aggregates /&gt;&#10; &lt;slicers /&gt;&#10; &lt;filtered /&gt;&#10; &lt;local-filters /&gt;&#10; &lt;unnamed-calcs /&gt;&#10; &lt;calculations&gt;&#10; &lt;calculation column=&apos;[excel.41483.051647499997].[TEMP(row count)(290714814)(0)]&apos; formula=&apos;1&apos; /&gt;&#10; &lt;calculation column=&apos;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&apos; formula=&apos;COUNT([TEMP(row count)(290714814)(0)])&apos; /&gt;&#10; &lt;/calculations&gt;&#10; &lt;agg-types&gt;&#10; &lt;agg-type column=&apos;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&apos; type=&apos;Count&apos; /&gt;&#10; &lt;/agg-types&gt;&#10; &lt;data-types&gt;&#10; &lt;data-type column=&apos;[excel.41483.051647499997].[TEMP(row count)(290714814)(0)]&apos; type=&apos;integer&apos; /&gt;&#10; &lt;data-type column=&apos;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&apos; type=&apos;integer&apos; /&gt;&#10; &lt;/data-types&gt;&#10; &lt;current-user display-name=&apos;&apos; name=&apos;&apos; short-domain-qualified-name=&apos;&apos; type=&apos;user&apos; /&gt;&#10;&lt;/aq-cache-key&gt;&#10;' ec-data-ts='2123622587410000' schema='Extract' tablename='Extract'> </pack>

TwbxExternalCache/TwbxTimestampsCacheV3/2322457020/.bin

TwbxExternalCache/TwbxTimestampsCacheV3/2322457020/.key

<pack class='dataengine' dbname='Data/Introduction to Tableau - Music Sales - TfT.twb Files/Music Sales (Music Store.xlsx).tde' ec-abstract-query='&lt;aq-cache-key are-all-local-sorts-supported=&apos;true&apos; has-agg-measure-filters=&apos;false&apos; has-lod-calcs=&apos;false&apos; has-user-reference=&apos;false&apos; ind-join-semantics=&apos;false&apos; start-of-week=&apos;sunday&apos; version=&apos;10.2&apos;&gt;&#10; &lt;query aggregation=&apos;true&apos; caching=&apos;normal&apos; hierarchize-rows=&apos;false&apos; include-empty=&apos;true&apos;&gt;&#10; &lt;fields&gt;&#10; &lt;output column=&apos;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&apos; /&gt;&#10; &lt;/fields&gt;&#10; &lt;/query&gt;&#10; &lt;relation-xml&gt;&amp;lt;relation name=&amp;apos;Extract&amp;apos; table=&amp;apos;[Extract].[Extract]&amp;apos; type=&amp;apos;table&amp;apos; /&amp;gt;&amp;#10;&lt;/relation-xml&gt;&#10; &lt;relation-names&gt;&#10; &lt;relation-name key=&apos;[Album]&apos; value=&apos;[Extract].[Album]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Artist]&apos; value=&apos;[Extract].[Artist]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Bytes]&apos; value=&apos;[Extract].[Bytes]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Calculation_1800807123004051]&apos; value=&apos;[Extract].[Calculation_1800807123004051]&apos; /&gt;&#10; &lt;relation-name key=&apos;[City]&apos; value=&apos;[Extract].[City]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Company]&apos; value=&apos;[Extract].[Company]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Composer]&apos; value=&apos;[Extract].[Composer]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Country]&apos; value=&apos;[Extract].[Country]&apos; /&gt;&#10; &lt;relation-name key=&apos;[CustomerID]&apos; value=&apos;[Extract].[CustomerID]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Email]&apos; value=&apos;[Extract].[Email]&apos; /&gt;&#10; &lt;relation-name key=&apos;[FirstName]&apos; value=&apos;[Extract].[FirstName]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Genre]&apos; value=&apos;[Extract].[Genre]&apos; /&gt;&#10; &lt;relation-name key=&apos;[InvoiceDate]&apos; value=&apos;[Extract].[InvoiceDate]&apos; /&gt;&#10; &lt;relation-name key=&apos;[InvoiceID]&apos; value=&apos;[Extract].[InvoiceID]&apos; /&gt;&#10; &lt;relation-name key=&apos;[LastName]&apos; value=&apos;[Extract].[LastName]&apos; /&gt;&#10; &lt;relation-name key=&apos;[MediaType]&apos; value=&apos;[Extract].[MediaType]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Milliseconds]&apos; value=&apos;[Extract].[Milliseconds]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Number of Records]&apos; value=&apos;[Extract].[Number of Records]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Phone]&apos; value=&apos;[Extract].[Phone]&apos; /&gt;&#10; &lt;relation-name key=&apos;[PostalCode]&apos; value=&apos;[Extract].[PostalCode]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Quantity]&apos; value=&apos;[Extract].[Quantity]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Region]&apos; value=&apos;[Extract].[Region]&apos; /&gt;&#10; &lt;relation-name key=&apos;[State]&apos; value=&apos;[Extract].[State]&apos; /&gt;&#10; &lt;relation-name key=&apos;[Track]&apos; value=&apos;[Extract].[Track]&apos; /&gt;&#10; &lt;relation-name key=&apos;[UnitPrice]&apos; value=&apos;[Extract].[UnitPrice]&apos; /&gt;&#10; &lt;/relation-names&gt;&#10; &lt;bindings&gt;&#10; &lt;binding key=&apos;[cnt:TEMP(row count)(290714814)(0):qk]&apos; value=&apos;cnt:TEMP(row count)(290714814)(0):qk&apos; /&gt;&#10; &lt;/bindings&gt;&#10; &lt;lod /&gt;&#10; &lt;measure-filter-lod /&gt;&#10; &lt;output&gt;&#10; &lt;column&gt;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&lt;/column&gt;&#10; &lt;/output&gt;&#10; &lt;aggregates /&gt;&#10; &lt;slicers /&gt;&#10; &lt;filtered /&gt;&#10; &lt;local-filters /&gt;&#10; &lt;unnamed-calcs /&gt;&#10; &lt;calculations&gt;&#10; &lt;calculation column=&apos;[excel.41483.051647499997].[TEMP(row count)(290714814)(0)]&apos; formula=&apos;1&apos; /&gt;&#10; &lt;calculation column=&apos;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&apos; formula=&apos;COUNT([TEMP(row count)(290714814)(0)])&apos; /&gt;&#10; &lt;/calculations&gt;&#10; &lt;agg-types&gt;&#10; &lt;agg-type column=&apos;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&apos; type=&apos;Count&apos; /&gt;&#10; &lt;/agg-types&gt;&#10; &lt;data-types&gt;&#10; &lt;data-type column=&apos;[excel.41483.051647499997].[TEMP(row count)(290714814)(0)]&apos; type=&apos;integer&apos; /&gt;&#10; &lt;data-type column=&apos;[excel.41483.051647499997].[cnt:TEMP(row count)(290714814)(0):qk]&apos; type=&apos;integer&apos; /&gt;&#10; &lt;/data-types&gt;&#10; &lt;current-user display-name=&apos;&apos; name=&apos;&apos; short-domain-qualified-name=&apos;&apos; type=&apos;user&apos; /&gt;&#10;&lt;/aq-cache-key&gt;&#10;' ec-data-ts='2123622587410000' schema='Extract' tablename='Extract'> </pack>

Image/Music Sales Dashboard v4.png

Image/Tableau_CMYK.jpg

Image/2017-05-23_12-14-37.png

Introduction to Tableau - Music Sales - TfT.twb

Album 129 [Album] [Extract] Album 0 'Music Sales$' string Count 301 1 1073741823 false "...And Justice For All" "Zooropa" "en_US_CI" true "heap" true 4294967292 18 "asc" 2 "str" Artist 129 [Artist] [Extract] Artist 1 'Music Sales$' string Count 163 1 1073741823 false "AC/DC" "Zeca Pagodinho" "en_US_CI" true "heap" true 4294967292 17 "asc" 2 "str" Bytes 5 [Bytes] [Extract] Bytes 2 'Music Sales$' real Sum 1900 false 211997.0 1059546140.0 8 23 "asc" "double" Calculation_1800807123004051 5 [Calculation_1800807123004051] [Extract] Calculation_1800807123004051 3 real Sum 10 false 0.98999999999999999 9.9499999999999993 true "array" true 8 5 "asc" 1 "double" City 129 [City] [Extract] City 4 'Music Sales$' string Count 53 1 1073741823 false "Amsterdam" "Yellowknife" "en_US_CI" true "heap" true 4294967292 10 "asc" 2 "str" Company 129 [Company] [Extract] Company 5 'Music Sales$' string Count 11 1 1073741823 true "Apple Inc." "Woodstock Discos" "en_US_CI" true "heap" true 4294967292 6 "asc" 1 "str" Composer 129 [Composer] [Extract] Composer 6 'Music Sales$' string Count 558 1 1073741823 true "A. F. Iommi, W. Ward, T. Butler, J. Osbourne" "Wright, Waters" "en_US_CI" true "heap" true 4294967292 20 "asc" 2 "str" Country 129 [Country] [Extract] Country 7 'Music Sales$' string Count 24 1 1073741823 false "Argentina" "USA" "en_US_CI" true "heap" true 4294967292 7 "asc" 2 "str" CustomerID 4 [CustomerID] [Extract] CustomerID 8 'Music Sales$' real Sum 59 false 1.0 59.0 true "array" true 4 13 "asc" 1 "float" Email 129 [Email] [Extract] Email 9 'Music Sales$' string Count 59 1 1073741823 false "[email protected]" "[email protected]" "en_US_CI" true "heap" true 4294967292 14 "asc" 2 "str" FirstName 129 [FirstName] [Extract] FirstName 10 'Music Sales$' string Count 55 1 1073741823 false "Aaron" "Wyatt" "en_US_CI" true "heap" true 4294967292 11 "asc" 2 "str" Genre 129 [Genre] [Extract] Genre 11 'Music Sales$' string Count 24 1 1073741823 false "Alternative" "World" "en_US_CI" true "heap" true 4294967292 8 "asc" 2 "str" InvoiceDate 135 [InvoiceDate] [Extract] InvoiceDate 12 'Music Sales$' datetime Year 354 false #2008-01-01 00:00:00# #2012-12-22 00:00:00# true "array" true "asc" 8 0 "asc" 2 "datetime" InvoiceID 4 [InvoiceID] [Extract] InvoiceID 13 'Music Sales$' real Sum 412 false 1.0 412.0 true "array" true 4 19 "asc" 2 "float" LastName 129 [LastName] [Extract] LastName 14 'Music Sales$' string Count 60 1 1073741823 false "Almeida" "Zimmermann" "en_US_CI" true "heap" true 4294967292 16 "asc" 2 "str" MediaType 129 [MediaType] [Extract] MediaType 15 'Music Sales$' string Count 5 1 1073741823 false "AAC audio file" "Purchased AAC audio file" "en_US_CI" true "heap" true 4294967292 2 "asc" 1 "str" Milliseconds 4 [Milliseconds] [Extract] Milliseconds 16 'Music Sales$' real Sum 1774 false 6373.0 5286953.0 4 21 "asc" "float" Number of Records 16 [Number of Records] [Extract] Number of Records 17 integer Sum 1 false 1 1 "asc" 1 "sint8" Phone 129 [Phone] [Extract] Phone 18 'Music Sales$' string Count 59 1 1073741823 true "+1 (204) 452-6452" "+91 080 22289999" "en_US_CI" true "heap" true 4294967292 15 "asc" 2 "str" PostalCode 129 [PostalCode] [Extract] PostalCode 19 'Music Sales$' string Count 56 1 1073741823 true "00-358" "X1A 1N6" "en_US_CI" true "heap" true 4294967292 12 "asc" 2 "str" Quantity 4 [Quantity] [Extract] Quantity 20 'Music Sales$' real Sum 5 false 1.0 5.0 true "array" true 4 3 "asc" 1 "float" Region 129 [Region] [Extract] Region 21 'Music Sales$' string Count 5 1 1073741823 false "Asia" "South America" "en_US_CI" true "heap" true 4294967292 4 "asc" 1 "str" State 129 [State] [Extract] State 22 'Music Sales$' string Count 26 1 1073741823 true "AB" "WI" "en_US_CI" true "heap" true 4294967292 9 "asc" 1 "str" Track 129 [Track] [Extract] Track 23 'Music Sales$' string Count 1807 1 1073741823 false "?" "Zooropa" "en_US_CI" true "heap" true 4294967292 22 "asc" 2 "str" UnitPrice 5 [UnitPrice] [Extract] UnitPrice 24 'Music Sales$' real Sum 2 false 0.98999999999999999 1.99 true "array" true 8 1 "asc" 1 "double" "American Idiot" "Barulhinho Bom" "Cássia Eller - Coleção Sem Limite [Disc 2]" "Da Lama Ao Caos" "Fireball" "Houses Of The Holy" "Led Zeppelin I" "Mais Do Mesmo" "Nevermind" "Plays Metallica By Four Cellos" "Riot Act" "Speak of the Devil" "The Colour And The Shape" "UB40 The Best Of - Volume Two [UK]" "Warner 25 Anos" "20th Century Masters - The Millennium Collection: The Best of Scorpions" "Ao Vivo [IMPORT]" "Battlestar Galactica, Season 3" "Cafezinho" "Dark Side Of The Moon" "Frank" "In Step" "Led Zeppelin III" "Master Of Puppets" "News Of The World" "Powerslave" "Rock In Rio [CD2]" "Stormbringer" "The Doors" "Unplugged" "Zooropa" "A Real Dead One" "Arquivo II" "Beethoven: Symphony No. 6 'Pastoral' Etc." "Carry On" "Diary of a Madman (Remastered)" "Garage Inc. (Disc 2)" "Instant Karma: The Amnesty International Campaign to Save Darfur" "Live [Disc 2]" "Miles Ahead" "No Security" "Purcell: Music for the Queen Mary" "Santana - As Years Go By" "Szymanowski: Piano Works, Vol. 1" "The Number of The Beast" "Use Your Illusion II" "Album Of The Year" "BackBeat Soundtrack" "Body Count" "Come Taste The Band" "Faceless" "Heart of the Night" "Kill 'Em All" "LOST, Season 4" "Muso Ko" "Pearl Jam" "Restless and Wild" "Slaves And Masters" "The Best of Ed Motta" "The World of Classical Favourites" "Vs." "Acústico MTV [Live]" "Bach: Orchestral Suites Nos. 1 - 4" "Black Sabbath Vol. 4 (Remaster)" "Chronicle, Vol. 1" "Elis Regina-Minha História" "Green" "Jagged Little Pill" "Load" "MK III The Final Concerts [Disc 1]" "Out Of Exile" "Radio Brasil (O Som da Jovem Vanguarda) - Seleccao de Henrique Amaro" "Serie Sem Limite (Disc 2)" "The Beast Live" "The Return Of The Space Cowboy" "Virtual XI" "Acústico" "Axé Bahia 2001" "Black Album" "Chill: Brazil (Disc 2)" "Duos II" "Greatest Hits II" "IV" "Live On Two Legs [Live]" "Minha Historia" "Original Soundtracks 1" "Quanta Gente Veio Ver (Live)" "Seek And Shall Find: More Of The Best (1963-1981)" "Ten" "The Police Greatest Hits" "Vinícius De Moraes - Sem Limite" "A Real Live One" "Arquivo Os Paralamas Do Sucesso" "Berlioz: Symphonie Fantastique" "Cesta Básica" "Diver Down" "Get Born" "International Superhits" "Live After Death" "Milton Nascimento Ao Vivo" "O Samba Poconé" "Purcell: The Fairy Queen" "Santana Live" "Tangents" "The Office, Season 1" "Van Halen" "Angel Dust" "Battlestar Galactica (Classic), Season 1" "Cássia Eller - Sem Limite [Disc 1]" "Dance Of Death" "For Those About To Rock We Salute You" "How To Dismantle An Atomic Bomb" "Led Zeppelin II" "Maquinarama" "New Adventures In Hi-Fi" "Pop" "Rock In Rio [CD1]" "St. Anger" "The Cream Of Clapton" "Un-Led-Ed" "Weill: The Seven Deadly Sins" "...And Justice For All" "Appetite for Destruction" "BBC Sessions [Disc 1] [Live]" "Californication" "Deep Purple In Rock" "From The Muddy Banks Of The Wishkah [Live]" "In Through The Out Door" "Let There Be Rock" "Mendelssohn: A Midsummer Night's Dream" "Nielsen: The Six Symphonies" "Prenda Minha" "Roda De Funk" "Supernatural" "The Essential Miles Davis [Disc 1]" "Unplugged [Live]" "Alcohol Fueled Brewtality Live! [Disc 2]" "Bark at the Moon (Remastered)" "Brave New World" "Contraband" "Fauré: Requiem, Ravel: Pavane & Others" "Hot Rocks, 1964-1971 (Disc 1)" "King For A Day Fool For A Lifetime" "Lulu Santos - RCA 100 Anos De Música - Ã�lbum 02" "My Way: The Best Of Frank Sinatra [Disc 1]" "Physical Graffiti [Disc 2]" "Revelations" "South American Getaway" "The Best Of R.E.M.: The IRS Years" "Transmission" "Walking Into Clarksdale" "Ace Of Spades" "Bach: The Brandenburg Concertos" "Blizzard of Ozz" "Chronicle, Vol. 2" "Emergency On Planet Earth" "Grieg: Peer Gynt Suites & Sibelius: Pelléas et Mélisande" "Jorge Ben Jor 25 Anos" "Lost, Season 1" "Morning Dance" "Out Of Time" "Rattle And Hum" "Seventh Son of a Seventh Son" "The Best Of 1980-1990" "The Singles" "Volume Dois" "Acústico MTV" "B-Sides 1980-1990" "Black Sabbath" "Chopin: Piano Concertos Nos. 1 & 2" "Elgar: Cello Concerto & Vaughan Williams: Fantasias" "Greatest Kiss" "J.S. Bach: Chaconne, Suite in E Minor, Partita in E Major & Prelude, Fugue and Allegro" "Living After Midnight" "Misplaced Childhood" "Os Cães Ladram Mas A Caravana Não Pára" "Quanta Gente Veio ver--Bônus De Carnaval" "Serie Sem Limite (Disc 1)" "The Battle Rages On" "The Real Thing" "Vinicius De Moraes" "Alcohol Fueled Brewtality Live! [Disc 1]" "Balls to the Wall" "Bongo Fury" "Compositores" "Facelift" "Heroes, Season 1" "Killers" "Lulu Santos - RCA 100 Anos De Música - Ã�lbum 01" "My Generation - The Very Best Of The Who" "Physical Graffiti [Disc 1]" "Retrospective I (1974-1980)" "Somewhere in Time" "The Best Of Men At Work" "The X Factor" "Wagner: Favourite Overtures" "A TempestadeTempestade Ou O Livro Dos Dias" "As Canções de Eu Tu Eles" "Beyond Good And Evil" "Chemical Wedding" "Djavan Ao Vivo - Vol. 1" "Greatest Hits" "Into The Light" "Live At Donington 1992 (Disc 1)" "Minas" "Olodum" "Pure Cult: The Best Of The Cult (For Rockers, Ravers, Lovers & Sinners) [UK]" "Scheherazade" "Tchaikovsky: 1812 Festival Overture, Op.49, Capriccio Italien & Beethoven: Wellington's Victory" "The Office, Season 2" "Van Halen III" "All That You Can't Leave Behind" "Bartok: Violin & Viola Concertos" "By The Way" "Core" "Fear Of The Dark" "House of Pain" "Knocking at Your Back Door: The Best Of Deep Purple in the 80's" "Machine Head" "Na Pista" "Piece Of Mind" "Ride The Lightning" "Sozinho Remix Ao Vivo" "The Best Of Van Halen, Vol. I" "Tribute" "War" "Achtung Baby" "Bach: The Cello Suites" "Blood Sugar Sex Magik" "Cidade Negra - Hits" "English Renaissance" "Handel: The Messiah (Highlights)" "Jota Quest-1995" "Lost, Season 2" "Motley Crue Greatest Hits" "Outbreak" "Raul Seixas" "Sex Machine" "The Best Of Billy Cobham" "The Song Remains The Same (Disc 1)" "Voodoo Lounge" "Afrociberdelia" "Back to Black" "Blue Moods" "Coda" "Every Kind of Light" "Haydn: Symphonies 99 - 104" "Judas 0: B-Sides and Rarities" "Lost, Season 3" "Mozart: Symphonies Nos. 40 & 41" "Pachelbel: Canon & Gigue" "ReLoad" "Sibelius: Finlandia" "The Best Of Buddy Guy - The Millenium Collection" "The Song Remains The Same (Disc 2)" "Vozes do MPB" "[1997] Black Light Syndrome" "Aquaman" "BBC Sessions [Disc 2] [Live]" "Carnaval 2001" "Deixa Entrar" "Górecki: Symphony No. 3" "In Your Honor [Disc 1]" "Liszt - 12 Études D'Execution Transcendante" "Meus Momentos" "No More Tears (Remastered)" "Presence" "Rotten Apples: Greatest Hits" "Surfing with the Alien (Remastered)" "The Essential Miles Davis [Disc 2]" "Up An' Atom" "A-Sides" "Audioslave" "Big Ones" "Chill: Brazil (Disc 1)" "Djavan Ao Vivo - Vol. 02" "Greatest Hits I" "Iron Maiden" "Live At Donington 1992 (Disc 2)" "Minha História" "One By One" "Purpendicular" "Schubert: The Late String Quartets & String Quintet (3 CD's)" "Temple of the Dog" "The Office, Season 3" "Vault: Def Leppard's Greatest Hits" "A Matter of Life and Death" "Are You Experienced?" "Beethoven Piano Sonatas: Moonlight & Pastorale" "Carried to Dust (Bonus Track Version)" "Demorou..." "Garage Inc. (Disc 1)" "In Your Honor [Disc 2]" "Live [Disc 1]" "Mezmerize" "No Prayer For The Dying" "Prokofiev: Romeo & Juliet" "Sambas De Enredo 2001" "Synkronized" "The Final Concerts (Disc 2)" "Use Your Illusion I" "Asia" "North America" "Europe" "South America" "Oceania" "TV Shows" "Alternative & Punk" "Science Fiction" "Comedy" "Pop" "Latin" "Heavy Metal" "Classical" "Rock And Roll" "Sci Fi & Fantasy" "Alternative" "Soundtrack" "Rock" "Hip Hop/Rap" "Electronica/Dance" "R&B/Soul" "Drama" "Reggae" "Metal" "Jazz" "Blues" "Easy Listening" "Bossa Nova" "World" Most Popular Genre in < [excel.41483.051647499997].[none:Region:nk] > Which genre sells the most? To help determine next year's budget, you are asked to create a visualization to determine which genre sells the most to our customers in Europe and Asia. 1. Æ Drag the Genre dimension to Rows. 2. Drag the Quantity measure to Columns. Notice this will automatically aggregate quantity using SUM. 3. Æ Drag the Genre dimension to Color. Remember that you have to use color with caution, but in our case, we will use this color to relate to another worksheet we'll build in the next exercises. 4. Click on the Descending bars icon on the toolbar (right beside the paper clip). 5. Click on the "Abc" icon on the toolbar to turn on labels, located between the paper clip icon and the presentation icon. 6. Drag the Region dimension to the Filters shelf. Choose Europe and Asia. 7. Right click the Region pill in the Filters shelf to show the dropdown. Choose Apply to Worksheets > All Using This Data Source. 8. Right click the Region pill in the Filters shelf to show the dropdown. Select "Show Quick Filter". Notice this will display another card that has all the Region values with checkboxes right beside them. Your users can use this to interact with this worksheet. 9. Right click on the bar of the top selling genre, and choose Annotate > Mark. Type the following in the Annotation editor. For anything in angled bracket, use the "Insert" dropdown menu to select the actual fields. Top Selling Genre: < Genre> Quantity Sold: < SUM(Quantity)> Æ Click OK when you are done 9. Adjust the location of the mark annotation so it's visible in the view. Top 20 Artists in < [excel.41483.051647499997].[none:Region:nk] > Which artists sell the most? Now that you know the most popular genres in Europe and Asia, you are asked to determine which artists sell the most. You are also asked to show if the artists produced tracks only on one genre, or if they have music across multiple genres. 1. Drag the Artist dimension to Rows. 2. Drag the Quantity measure to Columns. Notice this will automatically aggregate quantity using SUM. 3. Drag the Genre dimension to the Color shelf. Notice this places a Genre pill in the Marks shelf with a color icon right beside it. 4. Drag the Quantity measure to the Label shelf. Notice this places a Quantity pill in the Marks shelf with an "Abc" icon right beside it. 5. Click on the SUM(Quantity) pill in the Marks shelf to show the dropdown and choose Format. In the Default section, click on the Numbers dropdown. Choose Number (Standard). Click OK when done. 6. Click on the right side of the Artist pill in the Rows shelf. This will show the dropdown. Choose Filter. In the Filters window, choose the Top tab (4th tab). Choose By Field: Top 20 by Quantity Sum. Click OK when done. Sales Distribution by Region How do our region sales compare to each other? We are then asked to assess which regions in Europe and Asia sell the most records, but we quickly find that we aren't able to answer this information given the fields already defined in our data set. 1. Click on the dropdown icon beside the magnifying lens in the Dimensions window and select "Create Calculated Field". Name your calculated field Sales. In the Formula, use the following. Note you can also double click the field names from the Fields pane. [Quantity] * [UnitPrice] Click OK when done. This new Sales field will show up under Measures, and will have an icon that starts with an equal (=) sign. 2. Drag the Sales calculated field from Measures to the Size shelf. Notice this places a Sales pill in the Marks shelf with circle icon right beside it. 3. Drag Region dimension to the Color shelf. Notice this places a Region pill in the Marks shelf with color icon right beside it. 4. Drag Country dimension to the Detail shelf. Notice this places a Country pill in the Marks shelf with no icon right beside it. 5. Click on the space beside the Country dimension you just added to the Detail shelf and select the color icon. 6. Right click the Country dimension you added to the Detail shelf and select Sort. In Sort order, choose Descending. In Sort by, choose Field: Quantity and Aggregation: Sum. Click OK when done. 7. Drag the Country dimension to the Label shelf (beside the Size shelf in the Marks card). 8. Drag the Sales calculated field from Measures to the Label shelf. 9. Click on the Sales pill in the Marks shelf to show the dropdown, and choose Quick Table Calculation > Percent of Total. Sales in < [excel.41483.051647499997].[none:Region:nk] > What does our geographic sales distribution look like? You want to expand sales to more countries. To do this, you need to know first how our sales looks like in the countries we are currently catering. 1. Double click the Country dimension pill. This creates a geospatial map in the view. You should also notice that latitude and longitude are automatically placed in the rows and columns shelves respectively. 2. In the Marks shelf, change the type from Automatic to Filled Map. 3. Drag the Sales measure to Color. This adds a SUM(Sales) pill in the Marks card with a color icon beside it. 4. Drag the Sales measure again to Label. This adds a SUM(Sales) pill in the Marks card with an "Abc123" icon beside it. 5. Click the SUM(Sales) pill in the Marks card to show the dropdown. Choose Format. Under the Default group, choose Currency (Custom), with zero (0) decimal places. Keep the thousands separator checked. 6. Drag the Country dimension to Label. 7. Click on the Label shelf to open the Label editor. Format the label so that Country is - placed above Sales - a slightly bigger font than Sales - is Bold 8. Edit the color legend by clicking on the top right side of the legend border. Choose the Red Green Diverging color palette. Click OK when done. Rock vs Alternative vs Heavy Metal in < [excel.41483.051647499997].[none:Region:nk] > How does the sales trend of Rock tracks compare against Alternative and Heavy Metal tracks? One of your market researchers needs to find out the sales trend of Rock, Alternative and Heavy Metal tracks. You offered to help her out. 1. Right click drag InvoiceDate dimension to the Columns shelf. A right click drag opens a menu as soon as the field is placed on the shelf. Choose the continuous (green) MONTH(InvoiceDate) from the dropdown. This has a green calendar icon beside it. Continuous (green) fields produce axes, which is what we want. Discrete (blue) fields produce headers. 3. Drag the Sales measure to the Rows shelf. This produces a line graph for you. 4. Drag the Genre dimension to Color to keep the color theme consistent with other worksheets. 5. We have too much information on our view to be able to answer our original question. Drag the Genre dimension to Filters, and choose Rock, Alternative and Punk, and Heavy Metal. 6. Go to the Analysis menu and select Trend Lines > Show Trend Lines. Now it's time to put all your worksheets together into a single dashboard. You have freedom to design the dashboard and add components as you see fit. Below is an example dashboard that you can use as a starting point. The "Music Sales Dashboard" is set up as a blank dashboard for you to be able to work with. Once you are finished with your dashboard, upload it to Tableau Public (instructions are on "Dashboarding Instructions P2"). Dashboarding Æ To create a more cohesive view, you can bring multiple worksheets into a dashboard. For this dashboarding exercise, you have the freedom to arrange the worksheets and add additional components such as images, text, blank spaces as you see fit. You can also add interactivity so that the people who are using your dashboard can explore the data and get insights without having to re-design the worksheets. Here are some items to consider: Additional Instructions Make your dashboard and its interactivity components as easy to understand as possible by adding additional instructions. You can do this by adding "text" components in your dashboard Floating Dashboard Elements You can add dashboard items such as worksheets as floating elements. These elements are useful for overlaying other parts of visualizations, allowing you to be efficient with your use of space. To make an element floating, click on an element's top right border arrow to reveal a dropdown menu, and select "Floating". Alternatively, you can hold shift and drag an element to make it floating. Global Filters / Quick Filters You can make any of the local filters you created at the worksheet level visible at the dashboard level. While in the dashboard, click on that worksheet's dropdown menu and select "Quick Filters". Filters are most often optimally placed near the worksheet or worksheets they filter to make it as easy for your audience to understand as possible. A quick filter in a dashboard can apply to one worksheet, specific worksheets, or all worksheets that use the same data source. To set this up, click on that quick filter's dropdown menu and choose "Apply to Worksheets". Choose which level you want this filter applied to. Worksheet Title You can enhance your dashboard is to change the title of each worksheet so it reflects the values selected in the global filter. You can right click on the worksheet Title > Edit Title. You can set an appropriate title that incorporates the field used in the global filter, for example: Most Popular Genre in <Region> Sharing your dashboard When you are ready, you can share your worksheets and dashboard several ways: 1. By uploading your workbook to Tableau Server (if it's available to you in your organization), or uploading it to Tableau Public (see below for instructions). 2. By sending a packaged workbook (.twbx) to someone who has access to Tableau Reader, or Tableau Desktop. 3. By exporting the worksheets and dashboards as image, or printing these as PDF. Tableau Public To upload to Tableau Public, you must first create a Tableau Public account at https://public.tableausoftware.com . This is separate from your regular Tableau account. When ready, you can go to the Server menu and select Tableau Public > Save to Web. Visualizing Music Store Sales This workbook is intended to introduce you to the basics of data visualization by exploring a fictional music store's online sales from 2008 to 2012. This data set was adapted from the Chinook database offered at codeplex ( http://chinookdatabase.codeplex.com/ ). This data set was adjusted for purposes of visualizing using Tableau. When you go through the exercises in this workbook, you will acquire skills and familiarity that you can use when visualizing other data sets. Directions Before you proceed, check out the "Terminology and Interface" dashboard. This will help you with some of the common Tableau terminology and Tableau Desktop interface components. You can always come back to this dashboard for reference at any time during your exercise. Directions for each exercise are contained in a caption. If the caption is long, you can click on the caption area and scroll down to see the rest of the instructions. You can also hide the caption to increase your workspace by clicking on the Caption title dropdown and selecting Hide Card. If you wish to show the caption again, you can bring it back by clicking on the the Worksheet menu > Show Caption. Terminology and Interface As you go through the exercises, you will encounter terminologies that may not be familiar to you. Below is a typical Tableau interface with some of the components labeled. You can use this image as reference as you complete the tutorial. You can also click on the image below to go to the official documentation on Tableau workspaces, or check out the Tableau Product Help for additional topics at this URL: http://tabsoft.co/2rNo38k Æ [excel.41483.051647499997].[none:Genre:nk] [excel.41483.051647499997].[none:Region:nk] [excel.41483.051647499997].[none:Artist:nk] [excel.41483.051647499997].[none:Genre:nk] [excel.41483.051647499997].[none:Track:nk] [excel.41483.051647499997].[none:Country:nk] [excel.41483.051647499997].[none:Region:nk] [excel.41483.051647499997].[none:Country:nk] [excel.41483.051647499997].[mn:InvoiceDate:ok] [excel.41483.051647499997].[none:Genre:nk] [excel.41483.051647499997].[none:Region:nk] [excel.41483.051647499997].[tmn:InvoiceDate:qk] [excel.41483.051647499997].[yr:InvoiceDate:ok]