Part 1: Creating a Simple Dashboard with Bokeh

Layouts

For the US Census Income dataset, create a dashboard that shows:

• Age Distribution

Marital status Distribution

Working Class Distribution

• Education Distribution

Your Dashboard Should:

1. Use Bokeh Library with Layouts.

2. Select proper color, opacity and width for the bar charts.

3. Space the four figures evenly on the html page.

4. Maximize Data-Ink Ratio for each plot./nPART 2 - Need to use Tableau for below

In this set of activities, we will see how calculated fields can be used to perform simple

data processing, mainly for data slicing & dicing for visualization purposes.

All activities are done on the US Census Income DatasetLinks to an external site..

Activity 1: Visualizing Income by Age Group

We want to create a visualization to show the income within different age groups. The

age groups are defined as follows:

●

People younger than 20 years

People in their 20's

People in their 30's

People in their 40's

People in their 50's

People older than 60 years.

To create these age groups in tableau, we will create a calculated field. The final

visualization should look like this:/nActivity 2: Summarizing Marital Statuses

The US Census dataset contains a categorical attribute: marital status that can take one

of these values:

• Married-civ-spouse,

Divorced,

Never-married,

Separated,

Widowed,

Married-spouse-absent,

• Married-AF-spouse.

There are three different types of married statuses. We would like to create one married

category for the three types. Essentially, we want to summarize the marital status

attribute into these categories:

• Never Married

• Married

Divorced

Widowed/nPart 3: Creating Interactive Dashboards using

Parameters & Calculated Fields

Part 3: Guidelines:

For each problem below, submit the following:

A brief explanation of what you did.

Screenshots of any parameters and/or calculated fields that you have

created, showing the actual code for the calculated fields.

• The final dashboard with maximized data ink ratio:

o Text/values on top of marks

o No unnecessary axes

o

No repeated axis labels

o

No repeated axis values

Problem 1: Using a Parameter to Create a Top-N

Filter

Suppose that you have a bar chart that contains many bars. You would like to allow the

user to have the option of showing the top-n bars only, for some value n that the user

specifies. This will make the dashboard interactive, meaning that the user can change

what is displayed.

In this activity we will show how parameters can be used to create a top-N filter and add

interactivity to a dashboard.

Create a Top-N Filter for a bar chart

For the U.S. Census Income datasetLinks to an external site., create a visualization for

the different countries of origin, excluding the U.S.. Then create a top-n filter that allows

the user to select the number of countries they want to show, starting with the country/nActivity 4: Using a Parameter to Filter Multiple

Views

The World Population dataset file shows the population of different countries and

regions of the world over multiple years.

In this lab, you will create a dashboard that compares the populations of the different

regions for the years 2011 vs 2020.

You will create a dashboard that contains two visualizations, one for each year.

The dashboard should contain a control that allows the user to filter the views to show

the numbers for a certain country.

The dashboard should also allow the user to show the complete data for all countries.

Follow these steps:

1. Download the dataset file.

2. Open the dataset file in tableau.

3. Create a new sheet. Name it "2011". Create a bar chart that shows the

populations for the different countries in 2011.

4. Create a new sheet. Name it "2020". Create a bar chart that shows the

populations for the different countries in 2020.

5. Create a parameter "Country" as a string and load it with the country values

from the data source.

6. Make sure to show the parameter control by right clicking on the parameter

and selecting that option.

7. For the "2011" sheet, create a filter that filters the view based on the "Country"

parameters.

8. Repeat the same and create a filter for the "2020" sheet.

9. Create a new dashboard.

10. Drag both sheets into the dashboard.