DataViz Makeover 1

This is my DataViz Makeover 1.

Liu Jie
01-27-2021

1. Critiques of the graph

Please see the graph and critiques from clarity and aesthetics aspects below. alt text here Clarity

Aesthetics

2. Sketch of the proposed design

Concerning the critics above, I would like to suggest an alternative graphical presentation to improve the current design. Please see below for the sketch of the proposed design.

alt text here The proposed design has four main improvements and advantages.

  1. It has a clearer header and telling the audience that the graph is a comparison between 2009 and 2019.

  2. There is clear Y-axis and X-axis to show the differences and age group.

  3. The dot graph is per category not continuous which is clearer and not misleading.

  4. The colors to be used to present 2009 and 2019 data will be with strong contrast in vibrate colors.

3. Proposed data visualization designed in Tableau

Please see below for the proposed data visualization. https://public.tableau.com/profile/liu.jie5917#!/vizhome/SingaporeLabourForcePariticipationRateForAgeGroups2009VS2019/2009VS2019?publish=yes

4. A step-by-step description of how the data visualization was prepared

The steps of creating the visualization shown above in the Tableau are as following: 1. Extract the defined age group data to an excel file named Labour Force participation rate, keeping the age group defined for 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70&over

  1. Load the data to Tableau and enable Data Interpreter to interpret the column name

  2. Select column 2009 to 2019 and pivot table

  3. Rename the pivot field names to Year and data type to Date. Rename pivot field values to participation rate

  4. Drag [Age (Years)] to the Rows shelf

  5. Drag [Participation rate, %] to the Columns shelf

  6. Drag [Year] to Color on the marks card

  7. Drag [Year] to the Filter shelf

  8. In the Filter Field dialog, select Years and click Next >

  9. In the Filter dialog, check only 2009 and 2019 and click OK

  10. On the marks card, in the drop-down, select Circle

  11. Create a calculated field with the name “2009 Participation rate” with the calculation as the following: alt text here

  12. Create a calculated field with the name “Difference” with the calculation as the following:

  1. Drag [2009 Participation rate] to the Columns shelf

  2. Click [2009 Participation rate] on the Columns shelf to open the SUM (2019 Participation rate) marks card

  3. In the SUM (2009 Participation rate) marks card, do the following:

  1. Right-click [2009 Participation rate] on the Columns shelf and select Dual Axis

  2. Right-click the Sales axis at the bottom of the view and select Move marks to front

  3. Right-click [2009 Participation rate] on the Columns shelf and un-check Show Header

  4. Add it to the dashboard and add text boxes for header, description and source

5. Three major observations revealed by the data visualisation prepared

  1. All the labour force participation rate for each age group has increased from 2009 to 2019 except for the age group 20-24 with a decrease of 2.50%.

  2. The labour force participation rate for younger age groups did not increase as much as the older age groups. The age group below 44 increased less than 5.00% and age groups above have increased more than 5.00% for most of them.

  3. There is a trend of increment of differences in the labour force participation rate starting age group 50-54 until age group 65-69 from 2009 to 2019, and age group 65-69 with the most increase of 16.20%.

Thank you very much for reading my blog.