97|TABLEAU – CensusViz Challenge

BYU Student Author: @Erick_Sizilio
Reviewers: @Nate, @IWillyerd
Estimated Time to Solve: 60 Minutes

We provide the solution to this challenge using:

• Tableau

Overview
Welcome to the CensusViz Challenge, where you’ll have the opportunity to showcase your data visualization skills using Tableau!

Your task is to create a tool that will help you quickly see the relationship between different demographic characteristics, such as gender, age, nativity, and more. You are provided a data set containing this information below, and it will be up to you to use Tableau to create multiple histograms that showcase the relationships between these characteristics.

But that’s not all—you’ll also need to create a series of graphs that display the average income by these measures. And to really showcase your skills, you’ll need to put all these visualizations into a dashboard that is both visually appealing and easy to navigate.

This challenge is perfect for anyone who loves working with data and wants to demonstrate their ability to use Tableau to create meaningful and impactful visualizations.

So what are you waiting for? Get started on the CensusViz Challenge today and see just how far your data visualization skills can take you!

Instructions

2. Histograms can often be useful for understanding how data is distributed. Create histograms for the following fields: Age, Industry, Household Income, Education, Marriage Status, Hours worked, and Gender. Combine these histograms into a dashboard and add an “Action” so that whenever the user clicks at one category from any of the histograms it will filter the other histograms.
3. Let’s now prepare household income for analysis. In this dataset, household incomes are provided in ranges (E.g., \$100,000 To 150,000). Extract the lowest number from each range (I.e., if it is “150,000 or More” extract 150,000. If it is Less than 5,000, use 0, etc.)
4. Time for analysis! Create different sheets that show the average household incomes (using the field you created in the previous step) for the following fields: Education, Industry, Hours Worked, Marital Status, Age, and Gender. Put these into a dashboard and format it nicely.
5. Create three other sheets with the following: average income by occupation, average income by native country, average income by father’s nativity, and average income my mother’s nativity.
6. Share in the comments below one thing that you found interesting in the data using the dashboards that you created.

Data Files

Suggestions and Hints

You can use the code below to extract the lowest number from the household income range. You will need to create a calculated field and paste the code below.

``````if zn(find([Household income],"To"))<>0 then
int(left([Household income],FIND([Household income],"To")-2))

elseif zn(find([Household income],"or"))<>0 then
int((left([Household income],FIND([Household income],"or")-2)))

elseif zn(find([Household income],"Than"))<>0 then 0
end
``````

Solution

IF CONTAINS([Household income], ‘To’) THEN
INT(LEFT([Household income], FIND([Household income], ‘To’) - 2))
ELSEIF CONTAINS([Household income], ‘or’) THEN
INT(LEFT([Household income], FIND([Household income], ‘or’) - 2))
ELSEIF CONTAINS([Household income], ‘Than’) THEN
0
END