Day 4: Interactive Dashboards
Tableau In-class Assignment:
Use the UK Bank Customers data set to answer Questions
Q1 Create a donut chart showing the relationship between average
age distribution.
Q2 Create a Calculation ‘Net Worth’ to segregate customers into 3
categories. Plot a table to display the Net Worth of each customer. The
conditions for calculating Net Worth are as below
a. Low Net Worth – Balance less than £50,000
b. Medium Net Worth – Balance between £50,000 - £100,000
c. High Net Worth – Balance greater than £100,000
Q3 Create a Tree Map to display the split of Province, Gender, and Job
Classification. Add colors using Province and Gender. The visualization
should include data labels to showcase the number of people in each
of these buckets.
Q4 Create a histogram based on Age. The bin size should be 5. Plot a
chart to display the number of customers
in each bin.
Q5 Create a Customer Segmentation Dashboard using the UK Bank
Customers dataset.
a. Plot the Province in a Filled Map chart. Display the data
labels for the average balance in each of the provinces. The
data label should be displayed should be rounded off to
thousands.
b. A Pie chart to display the split of gender. The dashboard
should be interactive such that if a particular region is
selected the Pie Chart updates.
c. A histogram based on Age Bin. The bin should be dynamic
such that the user can choose between the bin size of 5 or
10.
Day 4: Interactive Dashboards
Q6. Using UK Bank Customer dataset - Create a story with the
following worksheets and use the geographical map worksheet
as a master filter
a. Geographical map showing the number of customers
across the UK (Use it as a master filter) with respective
insights using the following worksheets
i. Age group distribution of customers
ii. Balance group distribution of customers
iii. Job classification
iv. Gender Classification
