IS428 AY2019-20T1 Assign Ronald Lay Data Transformation

VAST Challenge 2019: Mini-Challenge 1

Problem & Tasks

Data Transformation

Interactive Visualization

Answers

Data used for Mini Challenge 1

• mc1-reports-data.csv
• StHimark.shp

Pivoting for categories

Issue

The categories are represented in columns, which is difficult when performing the filters and charts in tableau.

Solution

Using Tableau prep to perform the pivoting of categories - Medical, Power, Road And Bridges, Sewer & Water and shake intensity - into a column called "Category" and "Reported intensity" for the value.

Binning of different intensity level

Issue

The raw data contains categorical data represented by number. However, number representation provides an unclear definition of how each value is perceived by the users.

Solution

To standardize the definition, visual binning is performed by aligning the intensity value with instrumental intensity into a number of distinct categories.

Follow the 2-step process

2 steps process Create Calculated field

Displays Calculation statement as followed

The output is generated below

mc1-clean-data