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) 

Instruction Files

Related Questions in data mining category


Disclaimer
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.