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	Exclude non-disease blogs from analysis
Determine type of symptoms	Categorise symptoms into water, air or human
Correlate spots with map and time	Animate disease outbreak path by timelapse
Drill down into water-borne	Study the origin, spread and contributing factor
Drill down into air-borne	Study the origin, spread and contributing factor
Drill down into human-transmitted	Study the origin, spread and contributing factor

So that I can suggest containment measures and geo-fencing for each of the transmission type.

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