Extract the Titanic dataset and exclude any rows that are missing the Age of the ship passenger(Add filter by the add button in the top-right of the data panel).
data mining
Description
1) Extract the Titanic dataset and exclude any rows that are missing the Age of the ship passenger(Add filter by the add button in the top-right of the data panel).
2) Create a new column in the Titanic dataset that discretized the Age Group, with Age values > 16 reflected as "Adult" and those not > 16 as "Child" (Group the data, or do it in Excel by using the IF function).
3) Create a Mosaic graph (Treemap in Tableau) that depicts the total distribution of passengers across gender, cabin class, and age group.
4) Create a Mosaic graph that depicts the total distribution of survivors across gender, cabin class, and age group.
5) Create a Mosaic graph that depicts the number of passengers from each
combination of gender, cabin class, and age group as a percent of all passengers on board the Titanic. (Show percentage as the label)
6) Create a Mosaic graph that depicts the percentage of passengers that survived from each
combination of gender, cabin class, and age group as the survival rate (consider using AVG(survived) to show the survival rate.
You could also do some math to prove it if you are interested.) for each of those combinations of metrics. (Show percentage as the label)
7) Using each visualization (Mosaic graph) of the Titanic dataset,
create a Tableau story that describes the separate distribution of passengers (may consider using CNT(survived))
across characteristics gender, cabin class, and age group; also include the visualization that describes the
survival experience of Titanic passengers across combinations of gender, cabin class, and age group.
Save the above in a single Tableau Packaged Workbook (with a .twbx file extension)
