Difference between revisions of "IS428 AY2019-20T1 Assign Teng Jing Wen"
Jwteng.2017 (talk | contribs) |
Jwteng.2017 (talk | contribs) |
||
Line 138: | Line 138: | ||
|} | |} | ||
− | == Interesting Observations == | + | == Insights from dashboards == |
+ | === Q1 === | ||
+ | Emergency responders will base their initial response on the earthquake shake map. Use visual analytics to determine how their response should change based on damage reports from citizens on the ground. How would you prioritize neighborhoods for response? Which parts of the city are hardest hit? Limit your response to 1000 words and 10 images. | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! No. !! Observations | ||
+ | |- | ||
+ | | 1 || The people from the facilities department are always around the building 24/7. They are located mostly in level 1. It appears that they work in shifts and they ensure that there is always someone from the department around ay anytime of the day. | ||
+ | [[Image:Tan Kee Hock MA3 Slide41.JPG|800px|center]] | ||
+ | |- | ||
+ | | 2 || [[Image:Tan Kee Hock MA3 Slide42.JPG|800px|center]] | ||
+ | |- | ||
+ | | 3 || [[Image:Tan Kee Hock MA3 Slide43.JPG|800px|center]] | ||
+ | |- | ||
+ | | 4 || [[Image:Tan Kee Hock MA3 Slide44.JPG|800px|center]] | ||
+ | |- | ||
+ | | 5 || [[Image:Tan Kee Hock MA3 Slide45.JPG|800px|center]] | ||
+ | |- | ||
+ | | 6 || [[Image:Tan Kee Hock MA3 Slide46.JPG|800px|center]] | ||
+ | |- | ||
+ | | 7 || [[Image:Tan Kee Hock MA3 Slide47.JPG|800px|center]] | ||
+ | |- | ||
+ | | 8 || [[Image:Slide48.JPG|800px|center]] | ||
+ | |- | ||
+ | | 9 || The offices of the employees are arranged by position. The higher position the employee is, it is likely that his/her office will be at the higher floor. The executive departments are mainly located on the 3rd floor, while people from the facility and security department comes from the 1st and 2nd floor. | ||
+ | |- | ||
+ | | 10 || Floor 2 is where the bulk of the employees are. Most of the employee's offices are on the 2nd floor. Although their offices are located on the 2nd floor, they still move about the building as frequently. Also, as seen in the floor map and the employee proximity card data, floor 1 is where meetings and front desk offices are located. Thus, the reduced employee presence in floor 1 also suggests that the meeting rooms in floor 1 are likely to be used to host guests/events | ||
+ | |} | ||
+ | <p> Implications: | ||
+ | |||
+ | == Other Interesting Observations == | ||
Using the dashboard as a platform for emergency response analysis, the following aims to provide answers to the questions posed. | Using the dashboard as a platform for emergency response analysis, the following aims to provide answers to the questions posed. | ||
Line 168: | Line 198: | ||
=== Q2: === | === Q2: === | ||
xxx. | xxx. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- |
Revision as of 13:16, 10 October 2019
Contents
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:
Issue:
Solution:
Dataset Import Structure & Process
After performing the data transformation, the data from 3 data sources will be imported into Tableau.
As there are 3 different datasets to import, we will need to perform inner joins on the tables together with a common attribute. The relationship between each data source is as follow:
- Between reports data and StHimark Features
- Between StHimark Features and StHimark Points
After joining the data by common attribute, additional processing to the data sources still has to be done.
Additional Processing: Emergency Reports Data
No. | Brief Implementation |
---|---|
1. |
Under the data source tab, we will rename the "Time" field into Date and create an additional Time field. The following formula will be used: “MAKETIME(DATEPART('hour',[Date]), DATEPART('minute',[Date]),0)” |
2. |
|
3. | Under a new Worksheet, perform the following actions:
|
4. | Example |
Additional Processing: St.Himark Points and St.Himark Features
No. | Brief Implementation |
---|---|
1. | Example |
2. | Example |
Interactive Visualization
Home Dashboard
The following shows the HVAC Control System (Chemicals) dashboard:
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
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. |
- | |
The implementation steps are similar to the use of highlighting in the “HVAC Control System & Chemical Levels (Heating)” dashboard. | ||
|
| |
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: |
xxx.2
The following shows the Power Consumption dashboard:
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
The implementation steps are similar to the use of linking technique used in the “HVAC Control System & Chemical Levels (Chemicals)” dashboard. |
Insights from dashboards
Q1
Emergency responders will base their initial response on the earthquake shake map. Use visual analytics to determine how their response should change based on damage reports from citizens on the ground. How would you prioritize neighborhoods for response? Which parts of the city are hardest hit? Limit your response to 1000 words and 10 images.
No. | Observations |
---|---|
1 | The people from the facilities department are always around the building 24/7. They are located mostly in level 1. It appears that they work in shifts and they ensure that there is always someone from the department around ay anytime of the day. |
2 | |
3 | |
4 | |
5 | |
6 | |
7 | |
8 | |
9 | The offices of the employees are arranged by position. The higher position the employee is, it is likely that his/her office will be at the higher floor. The executive departments are mainly located on the 3rd floor, while people from the facility and security department comes from the 1st and 2nd floor. |
10 | Floor 2 is where the bulk of the employees are. Most of the employee's offices are on the 2nd floor. Although their offices are located on the 2nd floor, they still move about the building as frequently. Also, as seen in the floor map and the employee proximity card data, floor 1 is where meetings and front desk offices are located. Thus, the reduced employee presence in floor 1 also suggests that the meeting rooms in floor 1 are likely to be used to host guests/events |
Implications:
Other 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
- xx
xxx
xx:
- xx
points:
Department | Activities |
---|---|
| |
|
Q2:
xxx.
Priority | Anomaly/Unusual Events | Possible Danger/Serious Issue |
---|---|---|
xxx
[Source: xxx Dashboard] |
xx
| |
xxx
[Source: xxx Dashboard] |
xx
| |
xxx
[Source: xxx Dashboard] |
xx
|
References
The following references have been useful in the completion of the analysis process:
- <title> (url)