ISSS608 2017-18 T1 Assign DENG CHUNLING

Disease Outbreak Investigation

Objective

In light of the serious situation that Smartpolis faces (several deaths reported!), I need to:

1. Determine origin of disease outbreak

2. Find out medium of transmission

3. Suggest measures to contain spread

Methodology

My approach to this problem is:

To Do	Result
Filter blog text for spots of flu	Non-disease blogs are excluded from analysis
Determine type of symptoms	Categorise into water, air or human
Correlate spots with map and time	Animate disease outbreak path
Drill down into water-borne	Example
Drill down into air-borne	Example
Drill down into human-transmitted	Example

Data Preparation

Efforts are needed to transform the "Microblog" dataset into a format that is conducive for visualization.

Variable	Treatment	Tool	Remark
Location	Break into "Lat" and "Lon" respectively	SAS Enterprise Guide	Make Lat/Lon numeric
Text	Find meaningful terms	Example	Example
Example	Example	Example	Example

First, break the "Location" variable into "Lat" and "Lon" respectively.

Link to Tableau Page

Here