{"id":3150,"date":"2020-04-07T16:22:48","date_gmt":"2020-04-07T21:22:48","guid":{"rendered":"http:\/\/bluegalaxy.info\/codewalk\/?p=3150"},"modified":"2020-04-10T08:47:11","modified_gmt":"2020-04-10T13:47:11","slug":"tableau-how-to-recreate-a-data-graphic-found-on-the-web","status":"publish","type":"post","link":"https:\/\/bluegalaxy.info\/codewalk\/2020\/04\/07\/tableau-how-to-recreate-a-data-graphic-found-on-the-web\/","title":{"rendered":"Tableau: How to recreate a data graphic found on the web"},"content":{"rendered":"\n

One good way to get familiar with how to use a BI (business intelligence) tool such as Tableau <\/strong>is to start with a simple example of a data graphic and then attempt to replicate that graphic using Tableau. In this article I will describe step by step how to create the data display below in Tableau. <\/p>\n\n\n\n

I found this graphic on the internet and thought it would make a good graphic to attempt in Tableau. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The first thing that is required is a data set<\/strong> that contains Active cases, Deaths, and Recovered. This was found on the internet in .csv format. For example: (11k lines long)<\/p>\n\n\n\n

SNo,ObservationDate,Province\/State,Country\/Region,Last Update,Confirmed,Deaths,Recovered\n1,01\/22\/2020,Anhui,Mainland China,1\/22\/2020 17:00,1.0,0.0,0.0\n2,01\/22\/2020,Beijing,Mainland China,1\/22\/2020 17:00,14.0,0.0,0.0\n3,01\/22\/2020,Chongqing,Mainland China,1\/22\/2020 17:00,6.0,0.0,0.0\n4,01\/22\/2020,Fujian,Mainland China,1\/22\/2020 17:00,1.0,0.0,0.0\n5,01\/22\/2020,Gansu,Mainland China,1\/22\/2020 17:00,0.0,0.0,0.0\n6,01\/22\/2020,Guangdong,Mainland China,1\/22\/2020 17:00,26.0,0.0,0.0<\/pre>\n\n\n\n
When you first open Tableau, you will see a dialog that looks like this, where you can select your csv data:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
In the blue pane on the left, under Connect -> To a File -> click More… Then you can import the csv. For example:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Then you will see the data loaded in the Data Source tab in Tableau like so:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Next, switch over to the Sheet 1 tab and drag the Observation Date Dimension to the Columns list at the top. For example:<\/p>\n\n\n\n
\"\"
 <\/figcaption><\/figure>\n\n\n\n
 Note: The Columns and Rows fields can be thought of as the X and Y axis of the graph we are building.  <\/p>\n\n\n\n
Next click on the Observation Date drop down arrow and select “Exact Date” from the menu. This should also automatically change the selection to “Continuous” from “Discrete”. This is going to provide the X-axis shape of the graph. <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Here is what it will look like:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Next, move “Measure Values” from under Measures, to the Rows at the top. For example:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
When moving Measure Values to Rows, Tableau will automatically generate some kind of graph in the main graph area (blue jagged lines).  This will also automatically place Measure Names in the Filters box.<\/p>\n\n\n\n
Now, under Marks below Filters, change the setting from Automatic to Area. For example:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Now the graph should look like this:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Next, drag Measure Names into the bottom of the Marks dialog. <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Next we need to get rid of the Measure Values we don’t need.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
All we need is Confirmed, Deaths, and Recovered. We can get rid of the ones we don’t need by right clicking the green buttons and selecting Remove. <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Once that is done, we are left with the three values we want for our graph. For example:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Next, let’s change the colors so they match the graphic we are trying to emulate. Active cases (Confirmed) should be yellow, deaths should be brown, and recovered should be green. Click on the little symbol next to Measure Names in the Marks box and change it to Color.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Tableau will apply some default colors to the graph. For example:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
To change colors, double click on the Measure Names in the upper right box and a dialog will appear. For example:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Select the desired color and click OK. Do this for each of the three. It should now look like this:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Once done editing colors, you can select Hide Card to remove the little box at the upper right hand corner.<\/p>\n\n\n\n
Notice that the Deaths and Recovered areas are out of order. We want Deaths on the bottom, so we will need to reorder these in the graph.

This can be done by simply grabbing the SUM(Deaths) green button under Measure Values and dragging it to the bottom to reorder them. <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Which yields:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
All that is left is to change the title of the graph, and change the X and Y labels. <\/p>\n\n\n\n
To edit the title, double click “Sheet 1” and an Edit Title dialog will pop up.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
To edit the dates at the bottom so they just say “Jan”, “Feb” and “Mar”, double click the bottom axis and an “Edit Axis” dialog box will pop up. 

On the Tick Marks tab, choose Fixed under  Major Tick Marks and None for Minor Tick Marks. Also set the Unit to Months, as shown here:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Then right click on one of the dates, such as “Feb 26” and select Format.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Then on the left there will be a “Format Observation Date” pane. In the Axis tab, click the Dates drop down under Scale.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
This will allow you to set the date format. In this menu, click “Custom”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
After clicking “Custom”, type ‘mmm’ in the input box. This will change the date to “Mar”.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Now the labels in the X axis look like this:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The tick marks themselves can be made more visible by editing the color in the Format Observation Date pane.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The final step is to change the labels on the Y axis. This can be done the same way edits were made to the X axis labels. <\/p>\n\n\n\n
This time instead of editing a Date format, we are editing the Numbers type. Choose “Number (Standard)”.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
All we have left now is to get rid of the Y axis label and change the increments to 200,000. Do these by double clicking the Y axis. <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
That’s it! The data has been successfully displayed in Tableau!<\/p>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
One good way to get familiar with how to use a BI (business intelligence) tool such as Tableau is to start with a simple example of a data graphic and then attempt to replicate that graphic using Tableau. In this article I will describe step by step how to create the data display below in … Continue reading Tableau: How to recreate a data graphic found on the web<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[218],"tags":[8,219],"class_list":["post-3150","post","type-post","status-publish","format-standard","hentry","category-bi-dashboards","tag-csv","tag-tableau"],"_links":{"self":[{"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/posts\/3150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/comments?post=3150"}],"version-history":[{"count":27,"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/posts\/3150\/revisions"}],"predecessor-version":[{"id":3213,"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/posts\/3150\/revisions\/3213"}],"wp:attachment":[{"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/media?parent=3150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/categories?post=3150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluegalaxy.info\/codewalk\/wp-json\/wp\/v2\/tags?post=3150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}