Scribd
Upload
5 views3 pages

Module 2

The document outlines a training module for Tableau Prep focused on data preparation for a ship crash analysis. It includes a series of tasks such as renaming fields, changing data types, filtering null values, and creating calculated fields. The final step involves exporting the cleaned data as a Tableau extract and saving the flow in .tfl format.

Uploaded by

Utkal Tripathy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views3 pages

Module 2

The document outlines a training module for Tableau Prep focused on data preparation for a ship crash analysis. It includes a series of tasks such as renaming fields, changing data types, filtering null values, and creating calculated fields. The final step involves exporting the cleaned data as a Tableau extract and saving the flow in .tfl format.

Uploaded by

Utkal Tripathy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Tableau training and certification

Module 1: Data Preparation Using


Tableau Prep
Case Study II- Problem Statement

© Brain4ce Education Solutions Pvt. Ltd.


Module 1- Data Preparation Using Tableau Prep

Problem Statement:

You are a Tableau BI Developer working in the Forensics department. Your


assignment is to analyse the data of a ship crash but unfortunately, the data is in a
very raw format. Using a data cleaning tool, prepare the data for analysis.
Refer to the dataset: Ship Crash [Link]
Q1. Connect to the data. In the Input step, change Sex to Gender, Sibsp to Siblings
or Spouse and Parch to Parent or Children.
Q2. Add a Cleaning step and change the data type of Survived as String and
rename the values as follows:
• 0 as Died
• 1 as Survived.
• Name the Clean 1 Step as Renaming of fields.

Q3. Similarly, Rename Pclass as Passenger Class and change its data type to String.
Also change its values as follows: -
• 1 as First Class
• 2 as Second Class
• 3 as Economy class

Q4. Add another cleaning step and name it as Filter. Under this step, apply a filter
on Age to remove all the null values.
Q5. Add another Step and rename it as Calculated field. Create a Calculated field to
identify the number of fathers on board. The criteria to judge an adult is: -
Gender = Male
Age > 18
Parent or Children > 0
Note: Name this step as “Calculated field”.
Q6. Add another step and name it as Splitting. Split the name field into 3 columns
namely Surname, Title, First/Middle name. After splitting, remove any punctuation
from First/Middle name card and remove the name field from the data entirely.
Q7. Export the data as Tableau extract and save the flow in .tfl format.

©Brain4ce Education Solutions Pvt. Ltd Page 1


Module 1- Data Preparation Using Tableau Prep

©Brain4ce Education Solutions Pvt. Ltd Page 2

You might also like