Data Page

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search

Mini-Challenge 1: Crowdsourcing for Situational Awareness

Challenge Overview

Data

Interactive Visualization & Reference

Tasks and Comments

 

Introducation of the Data

The dataset countains two parts, image data and text data:
Image data:

  1. Pre-quake Shake Map
  2. Major-quake Shake Map
  3. St. Himark City Map by Location

Text data:
Report data: The dataset contains individual reports of shaking/damage by neighborhood over time, from 6th April to 11th April.
During the data exploration stage, it is observed that there are missing values for damage level. 0 is filled in for the missing values during calculation.

Pre-Analysis Data Processing

1. The timestamp given in the dataset is in 'YYYY-MM-DD hh:mm:ss' format. For easy aggregation, a new column 'Date' is created.

Date creation.png

2. The 'Location' column is identified as a measure when imported to Tableau. It is configured to a dimension for visualization purposes later.

Location-conversion.png