IS428 AY2019-20T1 Assign Kelvin Chia Sen Wei

From Visual Analytics for Business Intelligence
Revision as of 17:55, 8 October 2019 by Kelvin.chia.2017 (talk | contribs)
Jump to navigation Jump to search

Problem & 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.

Tasks and Questions:

  • 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.
  • Use visual analytics to show uncertainty in the data. Compare the reliability of neighborhood reports. Which neighborhoods are providing reliable reports? Provide a rationale for your response. Limit your response to 1000 words and 10 images.
  • How do conditions change over time? How does uncertainty in change over time? Describe the key changes you see. Limit your response to 500 words and 8 images.

Dataset Analysis & Transformation Process

Data Analysis

Dataset XXX

xxx.

Pivot Data:

XXX.

Issue: WHY.

Solution: SOLVE.

  1. Online Help
  2. Like this

  3. Then:
  4. Then

    Pivot.png

  5. Then

  6. After the completion of this process, the issue of lacking individual zone coordinates will be resolved.


Binning on values:

XXX.

Issue: WHY.

Solution: SOLVE.

  1. Online Help
  2. Like this

  3. Then:
  1. Then

  2. Then

  3. After the completion of this process, the issue of lacking individual zone coordinates will be resolved.


XXX:

Output.png

XXX.

Issue: WHY.

Solution: SOLVE.

  1. Online Help
  2. Like this

  3. Then:
  1. Then

  2. Then

  3. After the completion of this process, the issue of lacking individual zone coordinates will be resolved.


Dataset Import Structure & Process

With the dataset analysis and transformation phase completed, the following files will have to be imported into Tableau for analysis:

RELATIONS.

ADDITIONAL DATASET.

  • Import
  • Add new data connections to XXX.
  • Perform a left join between the XXX and the XX to correlate the XXX together. XXX The following shows the configuration of the join:

To process and display XXX

The formula used is as follows:

STR(DATEPART('day', [Date/Time])) + " " + DATENAME('month',[Date/Time]) + " (" + DATENAME('weekday', [Date/Time]) + ")"

Interactive Visualization

The interactive visualization can be accessed here: TABLEAU LINK

Throughout all the different dashboards, useful guides/tips are provided to help users navigate through the different filters and actions so that their analysis can be performed smoothly. The following interactivity elements are also used throughout all the dashboards to maintain consistency:

Interactive Technique Rationale Brief Implementation Steps
XXX
WHY.
  1. Step 1
  2. Step 2
XXX
WHY.
  1. Step 1
  2. Step 2
XXX
WHY.
  1. Step 1
  2. Step 2

The following sections elaborates on other interactivity techniques are integrated into each of the individual dashboard.

Dashboard X

The following shows the XX dashboard:

The following interactive techniques have been employed in this dashboard:

Interactive Technique Rationale Brief Implementation Steps
XX
XX
XX

Dashboard X

The following shows the XX dashboard:

The following interactive techniques have been employed in this dashboard:

Interactive Technique Rationale Brief Implementation Steps
XX
XX
XX

Dashboard X

The following shows the XX dashboard:

The following interactive techniques have been employed in this dashboard:

Interactive Technique Rationale Brief Implementation Steps
XX
XX
XX

Dashboard X

The following shows the XX dashboard:

The following interactive techniques have been employed in this dashboard:

Interactive Technique Rationale Brief Implementation Steps
XX
XX
XX

Dashboard X

The following shows the XX dashboard:

The following interactive techniques have been employed in this dashboard:

Interactive Technique Rationale Brief Implementation Steps
XX
XX
XX

Dashboard X

The following shows the XX dashboard:

The following interactive techniques have been employed in this dashboard:

Interactive Technique Rationale Brief Implementation Steps
XX
XX
XX

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.

ZZ'
Ans

  1. Ans1
  2. Ans2

Ans

Ans1:

  1. Ans2
  2. Ans3
Col1 Col2 Col3
1
Row Row


Row

2
Row Row


Row

3
Row Row


Row

4
Row Row


Row

5
Row Row


Row

6
Row Row


Row

7
Row Row


Row

8
Row Row


Row

Q2: Use visual analytics to show uncertainty in the data. Compare the reliability of neighborhood reports. Which neighborhoods are providing reliable reports? Provide a rationale for your response. Limit your response to 1000 words and 10 images.

Ans:

Col1 Col2 Col3
1
Row Row


Row

2
Row Row


Row

3
Row Row


Row

4
Row Row


Row

5
Row Row


Row

6
Row Row


Row

7
Row Row


Row

8
Row Row


Row

Q3: How do conditions change over time? How does uncertainty in change over time? Describe the key changes you see. Limit your response to 500 words and 8 images.

Ans:

Col1 Col2 Col3
1
Row Row


Row

2
Row Row


Row

3
Row Row


Row

4
Row Row


Row

5
Row Row


Row

6
Row Row


Row

7
Row Row


Row

8
Row Row


Row

Comments

Please input your comments here!