Data Visualization about Labor Force in Singapore.
1 Critiques and Suggestion for the current visualization
The current visualization can be found at Chart 6 Resident labour force by age in MOM’s Report: Labour Force in Singapore 2019 to indetify possible areas of improvement. Clarity Issues
1) The current visualization analysis only uses the data of 2009 and 2019, and lacks the data of 2010-2018, so it is impossible to know the changes of each age group in these intermediate years, so it is impossible to analyze the continuous changes of the age distribution of the labor force over the years in a more specific and detailed way.
Suggestions: Add each year data into the visualization and see the changing trend.
2) The original percentage of each age group in the excel report is the percentage of the population in that age group in the labor force, so it cannot be calculated as the percentage of whole ammount of labor force.
Suggestions: use the original data.
3) The current visualization donot have Y axis. It is not clear for readers to know what exactly the chart want to show. Actually it can highlight the number of each point, which would be easy to let the reader know the difference between 2009 and 2019.
Suggestions: add Y axis.
4) The median line could not be the specific age. It cannot calculate a median age from discrete variables.
Suggestions: remove the median line.
Aesthetics Issues
1) Title is not accurately express the chart. It seems like this chart only tell us the number of labor force of each age group.
Suggestions: Change the title.
2) Line chart does not fit this visualization, due to the X axis is age group in different intervals.
Suggestions: Use Bar chart.
3) Font size and title location. Title should be right in the middle above the chart and all the font should be in same size.
Suggestions: Move the title middle above the chart and change all the font into same size.
2 Proposed design
The first butterfly chart is going to show the difference of labor force by genders in a selected year from 2009 to 2019. The second line chart is the trend of labor force by different age groups from 2009 to 2019.
3 Proposed Data Visualization
Please view the interactive visualization on Tableau Public here
4 Step by Step Guide
As we can see, there are three data sheets which are Males, Females and Total.
In order to make the data more conducive to the subsequent visualization operations, we processed the original data in Excel, and the processed data is shown in the following figure.
Then Import the data into Tableau Butterfly Chart–% Labor Force of Different Age Group by Gender in
1) Create calculated fields
2) Build the chart
Then make X axis reversed and hide the Y axis.
After that, drag the Gender1 and drop into color under Males and Females.
And now the chart would be like this
Then change the 0 axis type into text and drag the Age1 into Text.
Now, drag the Year1 into filter, select all and show the filter. Make the filter single value.
For the title, remember to insert Year1.
Finally, show mark lables for both gender and the chart is finished.
Line chart-Labor Force Trend by Age Group from 2009 to 2019
Finally, the chart is finished and shows like this.
5 Insights
1) Percentage of labor force in females decreased from 30 while from 44 for males.
2) Percentage of labor force in males are almost same in the 30 years from 25 to 55.
3) The increased percentage of labor force above 55 is obviously higher than other age group.
Distill is a publication format for scientific and technical writing, native to the web.
Learn more about using Distill at https://rstudio.github.io/distill.