ISSS608 2017-18 T1 Assign DENG CHUNLING
Contents
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.
Origin and Spread
Transmission and Containment
Transmission Medium - Water, Air or Human Interaction?
Containment Suggestions
Link to Tableau Page
Here