IS428 AY2019-20T1 Assign Teng Jing Wen

Problem and Motivation

St. Himark has been hit by an earthquake, leaving officials scrambling to determine the extent of the damage and dispatch limited resources to the areas in most need. They quickly receive seismic readings and use those for an initial deployment but realize they need more information to make sure they have a realistic understanding of the true conditions throughout the city.

In a prescient move of community engagement, the city had released a new damage reporting mobile application shortly before the earthquake. This app allows citizens to provide more timely information to the city to help them understand damage and prioritize their response. In this mini-challenge, use app responses in conjunction with shake maps of the earthquake strength to identify areas of concern and advise emergency planners. Note: the shake maps are from April 6 and April 8 respectively.

With emergency services stretched thin, officials are relying on citizens to provide them with much needed information about the effects of the quake to help focus recovery efforts.

By combining seismic readings of the quake, responses from the app, and background knowledge of the city, help the city triage their efforts for rescue and recovery.

Transforming and analysing the dataset

<Before the analysis began, the dataset given is analysed to identify its respective format and attributes. There were 6 different zip files provided in the assignment and each has its own unique ways to process and make sense of the data to bring value to the analysis. This section will elaborate on the dataset analysis and transformation process for each dataset in order to prepare the data for import and analysis on an interactive visualization.>

Data Cleaning

Problem 1	Transposing the Data
Issue	The damage reports given contain multiple columns of damage area reported and this will make it difficult for interpretation on Tableau, especially when attempting to plot charts.
Solution

Problem 2	Polygon issue??
Issue
Solution

Issue: .

Solution:

500px|center

Issue:

Solution:

Dataset Import Structure & Process

After performing the data transformation, we will import the datasets into Tableau.

Interactive Visualization

xxx.1

The following shows the HVAC Control System (Chemicals) dashboard:

850px

The following interactive techniques have been employed in this dashboard:

Interactive Technique	Rationale	Brief Implementation Steps
Show different views of the Hazium data in the dashboard	To provide different perspectives for an analyst to conduct his investigation. For example, the line graph allows analysts to view the change in hazium concentration level overtime while the heatmap allow analysts to easily view the concentration levels of hazium based on colours representation.	-
Highlight across different charts	To show the correlation between the same set of data that has been represented in 2 different chart layouts	The implementation steps are similar to the use of highlighting in the “HVAC Control System & Chemical Levels (Heating)” dashboard.
Configure safe range of CO2 level	To provide a clear view for the analysts to see if the level of carbon dioxide concentration exceeds a safe range To provide flexibility for analysts to configure a safe range, as defined by the organization	Switch to the “Analytics” view and choose to add a “Reference Band” into the chart. For the value, choose to add a new custom parameter. The following shows a screenshot of the new parameter created: 250px To create a band, define two parameters that is the typical safe range level to a maximum safe range level. This will help to create a reference band. The following shows the configuration of a reference band: 250px Add both of these parameters onto the dashboard and analysts will be able to configure the values based on the organization’s preference.
Click on data point to explore ventilation elements that might lead to variations in CO2 level	To allow co-referencing of carbon dioxide levels with the ventilation elements and analyse possible reasons that led to the changes in carbon dioxide concentration	To ensure that the filter applied in the dashboard is linked with the “HVAC Control System Ventilation Elements” dashboard, similar steps were taken as mentioned previously to link filters across different dashboards. To allow clicking of the chart to another dashboard, actions were defined based on the following configuration: 350px

xxx.2

The following shows the Power Consumption dashboard:

850px

The following interactive techniques have been employed in this dashboard:

Interactive Technique	Rationale	Brief Implementation Steps
Click on data point to explore possible causes of variations in HVAC power demand	To allow analysts who are interested to identify reasons as to why the HVAC control system is consuming so much power with just a single click on a data point	The implementation steps are similar to the use of linking technique used in the “HVAC Control System & Chemical Levels (Chemicals)” dashboard.

Interesting Observations

Using the dashboard as a platform for emergency response analysis, the following aims to provide answers to the questions posed.

Q1:

data
xxxx

1. xx

xxx

xx:

1. xx

points:

Department	Activities
buildings	xx xx
medical	xx

Q2:

xxx.

Priority	Anomaly/Unusual Events	Possible Danger/Serious Issue
8	xxx [Source: xxx Dashboard]	xx x
8	xxx [Source: xxx Dashboard]	xx x
8	xxx [Source: xxx Dashboard]	xx x

Q3:

xx

points:

• xxxx

Priority	Anomaly/Unusual Events	Possible Danger/Serious Issue
8	xxx [Source: xxx Dashboard]	xx x
8	xxx [Source: xxx Dashboard]	xx x
8	xxx [Source: xxx Dashboard]	xx x

Q4:

xxx:

points:

1. xx
2. xx

xxx

References

The following references have been useful in the completion of the analysis process:

• <title> (url)