Take Home Ex 01

Published

February 26, 2023

The Procedures

Steps Screenshot
  1. Load the popdata.csv file into Tableau Desktop.
  1. In order to create the age-sex pyramid, we need the age group,which is the discrete value, instead of continuous value.So, from the ‘data source’ panel, right click on the ‘PA’ and click on ‘create group’. The criteria to make groups is referred to website PopulationPyramid.Net
 Figure 1- Group the ‘Age’ parameter
  1. From ‘Data’ panel, click on the little downside triangle, and click on ‘create parameter’.
  1. Create a new parameter called ‘female’, which is the total population of female.
  1. Create a new parameter called ‘male’,which is the total population of male.
  1. Drag ‘female’and ’male’ to Columns, ‘PA’ and ‘Age (group)’ to Rows, drag ‘Sex’to colour.Then right click on the title ’PA’ and click on ‘sort’, choose sort by ‘Field’, in descending order and field name is ‘pop’ which is the total population.
  1. Then, right click on ‘PA’, click ‘Filter’. Choose the top 9 area with the highest population.
  1. Right click on ‘Age (group)’, then click ‘Filter’. Check ‘Null’ and check ‘Exclude’.
  1. Click on ‘Data’ at the top of the window, then choose ‘Extract Data’.
  1. Click on ‘Extract’
  1. Click on ‘Server’ at the top, choose ‘Tableau Public’,then ‘Save to Tableau Public’.
  1. If not satisfied, click on ‘Color’ under Marks card, click ‘Edit Colors’, then pick more pretty ones.
  1. Click on white space of the ‘PA’ column, click on ‘Format’, and give a shading to this column.
  2. Public again.