Difference between revisions of "IS428 AY2019-20T1 Assign Nurul Khairina Binte Abdul Kadir InteractiveVisualization"
(59 intermediate revisions by the same user not shown) | |||
Line 36: | Line 36: | ||
== Dashboard Overview == | == Dashboard Overview == | ||
− | The interactive visualization can be accessed here: | + | The interactive visualization can be accessed here: https://public.tableau.com/views/AssignmentVA_15709028039740/Overview?:embed=y&:display_count=yes&:origin=viz_share_link |
For the best experience, adjust your screen resolution to 1366x768 and enable full screen on the browser. Adjust the dashboard so that all elements can be clearly visible without the need to scroll up/down. | For the best experience, adjust your screen resolution to 1366x768 and enable full screen on the browser. Adjust the dashboard so that all elements can be clearly visible without the need to scroll up/down. | ||
Line 77: | Line 77: | ||
|} | |} | ||
− | + | A summary of the breakdown of the visualizations created for Question 3 is as shown below. | |
+ | |||
+ | {| class="wikitable" align = "center" | ||
+ | |- | ||
+ | ! No. !! Dashboard Name !! Purpose | ||
+ | |- | ||
+ | | 1 || Uncertainty in Change Over Time || Use research on earthquakes to explore the uncertainty in the data throughout the entire period. Insights for key changes will be derived from other charts listed above. | ||
+ | |- | ||
+ | |} | ||
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: | 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: | ||
Line 157: | Line 165: | ||
|} | |} | ||
− | The following sections elaborate on the dashboard design and other interactivity techniques that are integrated into each of the individual | + | The following sections elaborate on the dashboard design and other interactivity techniques that are integrated into each of the individual dashboards. |
== Overview == | == Overview == | ||
− | |||
'''Purpose / Description''' | '''Purpose / Description''' | ||
− | The Overview is the landing page you will see when you open the workbook/link. This is considered the home page for this visualization. Icons are used to explain how crowdsourcing works and how it will used by the emergency response team. The visualization goals are also started here to give the user | + | The Overview is the landing page you will see when you open the workbook/link. This is considered the home page for this visualization. Icons are used to explain how crowdsourcing works and how it will used by the emergency response team. The visualization goals are also started here to give the user an idea of what to expect from the dashboards. </br> |
[[File:0 OverviewMarks.jpg|center|700px]] | [[File:0 OverviewMarks.jpg|center|700px]] | ||
== Shake Map Analysis == | == Shake Map Analysis == | ||
− | + | '''Dashboard Design''' | |
'''Purpose / Description | '''Purpose / Description | ||
''' | ''' | ||
− | Before we begin | + | Before we begin analyzing the reports, we will first analyze the shake maps that were captured on 6 April and 8 April 2020. This is a crucial step since the shake maps will be used to check the reliability of the reports made by citizens through the Rumble app - Do the reports reveal the same key observations? The shake maps indicate the corresponding earthquakes' epicenters and how much shaking can be felt across the city. This is critical for emergency decision making. Insights gained from the shakemap are also displayed here. |
[[File:1 Shakemap design.jpg|700px|center]] | [[File:1 Shakemap design.jpg|700px|center]] | ||
== Time Of Earthquake == | == Time Of Earthquake == | ||
− | + | '''Dashboard Design | |
− | + | ''' | |
+ | </br> | ||
'''Purpose / Description''' | '''Purpose / Description''' | ||
− | <p>The aim of the dashboard is to | + | <p>The aim of the dashboard is to analyze the number of reports made by each neighbourhood throughout the entire period and identify the time of the earthquake. The charts are placed side by side to allow for easier analysis. The filters are consistently placed at the right side of the dashboard and the tips will help the user to explore the chart on their own. The line chart is used since the objective is to show the trend in reports made over time. </p> |
[[File:Time earthquake design.jpg|700px|center]] | [[File:Time earthquake design.jpg|700px|center]] | ||
− | + | '''Interactive Technique''' | |
<p>The following interactive techniques have been employed in this dashboard:</p> | <p>The following interactive techniques have been employed in this dashboard:</p> | ||
Line 192: | Line 200: | ||
|- | |- | ||
! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | Interactive Technique | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | Interactive Technique | ||
− | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: | + | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 60%" | Rationale |
! style="font-weight: bold;background: #536a87;color:#fbfcfd;" | Brief Implementation Steps | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;" | Brief Implementation Steps | ||
Line 204: | Line 212: | ||
# On an individual worksheet, right-click an empty area of the Data pane on the left and select Create Parameter. | # On an individual worksheet, right-click an empty area of the Data pane on the left and select Create Parameter. | ||
# In the Create Parameter dialog box, do the following: Enter the name that will appear above the menu like 'Show/Hide Annotations'. For Data type, select String. For Allowable Values, select List. Click ok. [[File:Show or hide parameter settings.jpg|center|200px]] </br> | # In the Create Parameter dialog box, do the following: Enter the name that will appear above the menu like 'Show/Hide Annotations'. For Data type, select String. For Allowable Values, select List. Click ok. [[File:Show or hide parameter settings.jpg|center|200px]] </br> | ||
− | # Create a calculated field to trick Tableau into seeing the Mark as a new one when the parameter changes. Here is the calculation. [[File:Show or Hide Annotations Calculated Field.jpg|center]] </br> | + | # Create a calculated field to trick Tableau into seeing the Mark as a new one when the parameter changes. Here is the calculation. [[File:Show or Hide Annotations Calculated Field.jpg|200px|center]] </br> |
# Add it to the view | # Add it to the view | ||
# Add annotations for the current parameter | # Add annotations for the current parameter | ||
Line 228: | Line 236: | ||
== Hardest Hit Areas == | == Hardest Hit Areas == | ||
− | + | '''Dashboard Design''' </br> | |
+ | |||
'''Purpose / Description''' | '''Purpose / Description''' | ||
− | <p>The aim of the dashboard is to | + | <p>The aim of the dashboard is to analyze the average shake intensity and the number of shake intensity reports made for each neighbourhood throughout the entire period. A heatmap is used to show the average shake intensity as it allows the user to quickly identify areas that are more affected by the earthquake. The gaps in the chart indicate that no reports (for all damage types) were made. Null impact scores are not filtered out in this chart. Therefore, if the user hover over the data points and the average shake intensity is empty, it means that the impact score is Null. </p> |
For the Shake Intensity By Impact Level chart, the purpose is to show the variation in impact levels reported and to identify cities that are hardest hit. There are 2 options to view this chart – Horizontal or Vertical. A grouped bar chart is used since it allows for easy comparison and identification of patterns and anomalies. | For the Shake Intensity By Impact Level chart, the purpose is to show the variation in impact levels reported and to identify cities that are hardest hit. There are 2 options to view this chart – Horizontal or Vertical. A grouped bar chart is used since it allows for easy comparison and identification of patterns and anomalies. | ||
</br> | </br> | ||
Line 237: | Line 246: | ||
The Maximum Shake Intensity By Neighbourhood chart can be used to observe the number of records made over time as well as the intensity of the shaking. A line chart is used to show the trend over time. However, it shouldn't be relied upon completely since there could be outlier/false reports with high impact scores and this will not reflect the true extent of the damage. </p> | The Maximum Shake Intensity By Neighbourhood chart can be used to observe the number of records made over time as well as the intensity of the shaking. A line chart is used to show the trend over time. However, it shouldn't be relied upon completely since there could be outlier/false reports with high impact scores and this will not reflect the true extent of the damage. </p> | ||
− | [[File:Hard | + | [[File:Hard confirmed.jpg|700px|center]] |
− | + | '''Interactive Technique''' | |
<p>The following interactive techniques have been employed in this dashboard:</p> | <p>The following interactive techniques have been employed in this dashboard:</p> | ||
Line 256: | Line 265: | ||
Note: There are 2 separate sheets used for this visualization - Horizontal and Vertical | Note: There are 2 separate sheets used for this visualization - Horizontal and Vertical | ||
− | # On an individual worksheet, right-click an empty area of the Data pane at left | + | # On an individual worksheet, right-click an empty area of the Data pane at left and select Create Parameter. |
# In the Create Parameter dialog box, do the following: Enter the name that will appear above the menu like 'Select View'. For Data type, select String. For Allowable Values, select List. | # In the Create Parameter dialog box, do the following: Enter the name that will appear above the menu like 'Select View'. For Data type, select String. For Allowable Values, select List. | ||
# Under the List of values, type Horizontal and Vertical in the Value and Display As column respectively. Click Ok. The parameter is created. [[File:Parameter Settings.png|250px|center]] | # Under the List of values, type Horizontal and Vertical in the Value and Display As column respectively. Click Ok. The parameter is created. [[File:Parameter Settings.png|250px|center]] | ||
# Show the Parameter in the worksheet/dashboard. | # Show the Parameter in the worksheet/dashboard. | ||
# Create a Calculated field. Give the calculation a descriptive name like Select A View [H/V]. In the formula text box, enter the name of the parameter you created above which is 'Select View'. Click OK. [[File:Select View Calculated Field.jpg|200px|frameless|center]] | # Create a Calculated field. Give the calculation a descriptive name like Select A View [H/V]. In the formula text box, enter the name of the parameter you created above which is 'Select View'. Click OK. [[File:Select View Calculated Field.jpg|200px|frameless|center]] | ||
− | # One by one, open each sheet you plan to add to your dashboard and drag the new calculation to the Filters shelf. Then do the following in the Filter dialog box, and click OK. [[File:Adding Filter Process.jpg| | + | # One by one, open each sheet you plan to add to your dashboard and drag the new calculation to the Filters shelf. Then do the following in the Filter dialog box, and click OK. [[File:Adding Filter Process.jpg|300px|center]] |
# Create a Dashboard. Drag a Vertical or Horizontal layout container to the dashboard. Now drag each sheet to the layout container, identified by the dark blue outline. [[File:Drag Sheets.jpg|200px|center]] | # Create a Dashboard. Drag a Vertical or Horizontal layout container to the dashboard. Now drag each sheet to the layout container, identified by the dark blue outline. [[File:Drag Sheets.jpg|200px|center]] | ||
# Right-click the title area of each view in the dashboard, and select Hide Title. If the titles are visible, they prevent selected views from filling the dashboard. | # Right-click the title area of each view in the dashboard, and select Hide Title. If the titles are visible, they prevent selected views from filling the dashboard. | ||
Line 278: | Line 287: | ||
|- | |- | ||
| <center>'''Dashboard Action: Hightlight'''</center> <br> | | <center>'''Dashboard Action: Hightlight'''</center> <br> | ||
− | [[File:Dashboard Hover Hard Hit.jpg| | + | [[File:Dashboard Hover Hard Hit.jpg|200px|center]] |
|| | || | ||
* When the user is interested in a specific data point, he/she can simply place the cursor over the data point. | * When the user is interested in a specific data point, he/she can simply place the cursor over the data point. | ||
Line 293: | Line 302: | ||
== Emergency Response Planning == | == Emergency Response Planning == | ||
− | + | '''Dashboard Design'''</br> | |
'''Purpose / Description''' | '''Purpose / Description''' | ||
− | The emergency response can be determined by the mode of the damages. The blank map makes it easy for users to see the change in size of the circle marks which denotes the number of reports over time. The bigger the size, the greater the number of reports made by a specific neighbourhood. The mode chart is represented by the maximum number of reports made by impact score for each damage type and neighbourhood. It is better to use mode instead of average and maximum since they are prone to be affected by outliers. An area that is hardest hit may not always have a very high number of reports since there are other factors that could influence the number of reports like the size of the population in a neighbourhood. | + | The emergency response can be determined by the mode of the damages. The blank map makes it easy for users to see the change in the size of the circle marks which denotes the number of reports over time. The bigger the size, the greater the number of reports made by a specific neighbourhood. The mode chart is represented by the maximum number of reports made by the impact score for each damage type and neighbourhood. It is better to use mode instead of average and maximum since they are prone to be affected by outliers. An area that is the hardest hit may not always have a very high number of reports since there are other factors that could influence the number of reports like the size of the population in a neighbourhood. |
Therefore, using the mode of the impact score seems to be a better option in assessing the extent of the damage. The overview table will also provide the emergency responders with a breakdown of the reports by impact scores if they prefer to look at the details. The maps would allow them to get the information they are looking for at a glance. | Therefore, using the mode of the impact score seems to be a better option in assessing the extent of the damage. The overview table will also provide the emergency responders with a breakdown of the reports by impact scores if they prefer to look at the details. The maps would allow them to get the information they are looking for at a glance. | ||
− | [[File:Emergency design.jpg| | + | [[File:Emergency design.jpg|700px|center]] |
− | + | '''Interactive Techniques''' | |
<p>The following interactive techniques have been employed in this dashboard:</p> | <p>The following interactive techniques have been employed in this dashboard:</p> | ||
Line 313: | Line 322: | ||
|- | |- | ||
− | | <center>'''Traverse through a daily/hourly/5 min time series by clicking on the arrows'''</center>[[File:Time Choices.jpg|center| | + | | <center>'''Traverse through a daily/hourly/5 min time series by clicking on the arrows'''</center>[[File:Time Choices.jpg|center|250px]] <br> |
|| | || | ||
* To analyze changes in mode and number of reports over a period of time | * To analyze changes in mode and number of reports over a period of time | ||
− | * The user | + | * The user has more options on which timeframe to use when viewing the animation without having to change the filters manually. However, analysis is usually done on the hourly/daily time frame. |
* It is helpful in analyzing time-series data | * It is helpful in analyzing time-series data | ||
|| | || | ||
Line 338: | Line 347: | ||
|- | |- | ||
| <center>'''Dashboard Action: Highlight'''</center> <br> | | <center>'''Dashboard Action: Highlight'''</center> <br> | ||
− | [[File:Hover action - emergency.jpg| | + | [[File:Hover action - emergency.jpg|300px|center]] |
|| | || | ||
* Easier to se the relevant data points on other charts in the dashboard like the Number of Reports By Neighbourhood | * Easier to se the relevant data points on other charts in the dashboard like the Number of Reports By Neighbourhood | ||
Line 349: | Line 358: | ||
|} | |} | ||
− | == Prioritization - | + | == Prioritization - Building, Medical, Power == |
− | + | '''Dashboard Design''' </b> | |
'''Purpose / Description''' | '''Purpose / Description''' | ||
− | <p>The aim of the dashboard is to identify neighborhoods to prioritize based on the damage reports and shake maps. Having maps for each damage type will allow users to see an overview of the damages across types and the heatmap makes it easy to identify areas that require more immediate attention than others. The relevant information like maintenance work and building information is strategically placed below the chart so that the team can refer to it and take that into consideration when making critical decisions. < | + | <p>The aim of the dashboard is to identify neighborhoods to prioritize based on the damage reports and shake maps. Having maps for each damage type will allow users to see an overview of the damages across types and the heatmap makes it easy to identify areas that require more immediate attention than others. The relevant information like maintenance work and building information is strategically placed below the chart so that the team can refer to it and take that into consideration when making critical decisions. </p> |
− | An assumption made is that the emergency response team comprise of different divisions and responders are specialized or trained to deal with a specific damage type. The Amenities filter can also come in handy when it comes to transporting the injured to the hospitals and the school can be turned into a temporary shelter if needed. | + | An assumption made is that the emergency response team comprise of different divisions and responders are specialized or trained to deal with a specific damage type. The Amenities filter can also come in handy when it comes to transporting the injured to the hospitals and the school can be turned into a temporary shelter if needed. |
− | |||
− | + | [[File:Priority 1.jpg|700px|center]] | |
+ | |||
+ | '''Interactive Techniques''' | ||
<p>The following interactive techniques have been employed in this dashboard:</p> | <p>The following interactive techniques have been employed in this dashboard:</p> | ||
Line 380: | Line 390: | ||
# The tooltip can be formatted depending on your preferences | # The tooltip can be formatted depending on your preferences | ||
[[File:Tooltip Guide.jpg|300px|center]] | [[File:Tooltip Guide.jpg|300px|center]] | ||
+ | |||
+ | |- | ||
+ | | <center>'''Filter By Maintainance Or Hospitals Using A Multiple Value List '''</center> <br> | ||
+ | [[File:Multi list .jpg|250|center]] | ||
+ | |||
+ | || | ||
+ | * Allow users to identify neighbourhoods with maintenance work or with hospital facilities located within the neighbourhood | ||
+ | * User don't have to manually hover over each data point in the map | ||
+ | || | ||
+ | |||
+ | # Set the filter type to Multiple Value list | ||
+ | |||
|} | |} | ||
Line 385: | Line 407: | ||
== Prioritization - Roads and Bridges, Sewer and Water == | == Prioritization - Roads and Bridges, Sewer and Water == | ||
− | + | '''Dashboard Design''' </br> | |
+ | |||
+ | '''Purpose / Description''' | ||
+ | |||
+ | The aim of the dashboard is to identify neighborhoods to prioritize based on the damage reports and shake maps. Having maps for each damage type will allow users to see an overview of the damages across types and the heatmap makes it easy to identify areas that require more immediate attention than others. The relevant information like maintenance information is strategically placed below the chart so that the team can refer to it and take that into consideration when making critical decisions. | ||
− | + | Possible implications of maintenance work: Repair work on some roads will result in delays in traffic. This can also mean that rescue efforts may be affected. | |
+ | |||
+ | [[File:Prioritization 2.jpg|700px|center]] | ||
+ | |||
+ | '''Interactive Techniques''' | ||
<p>The following interactive techniques have been employed in this dashboard:</p> | <p>The following interactive techniques have been employed in this dashboard:</p> | ||
Line 397: | Line 427: | ||
|- | |- | ||
− | | <center>'''Hover over the data points of each map to find out more information about the neighbourhood'''</center>[[File: | + | | <center>'''Hover over the data points of each map to find out more information about the neighbourhood'''</center> <br> |
− | + | [[File:Power Tooltip Info.jpg|250px|center]] | |
− | || | + | || |
* When the user is interested in a specific data point, he/she can simply place the cursor over the data point. | * When the user is interested in a specific data point, he/she can simply place the cursor over the data point. | ||
− | * A tooltip will instantly appear with the relevant details (eg. | + | * A tooltip will instantly appear with the relevant details (eg. Building information, Neighbourhood with Hospitals, Power Maintainance Work, etc) which is critical for analysis. |
|| | || | ||
# Drag the relevant fields into the Tooltip in the Marks card | # Drag the relevant fields into the Tooltip in the Marks card | ||
+ | # The tooltip can be formatted depending on your preferences | ||
+ | [[File:Tooltip Guide.jpg|300px|center]] | ||
+ | |||
+ | |- | ||
+ | | <center>'''Filter By Maintainance Or Hospitals Using A Multiple Value List '''</center> <br> | ||
+ | [[File:Multi list .jpg|250|center]] | ||
+ | |||
+ | || | ||
+ | * Allow users to identify neighbourhoods with maintenance work or with hospital facilities located within the neighbourhood | ||
+ | * User don't have to manually hover over each data point in the map | ||
+ | || | ||
+ | |||
+ | # Set the filter type to Multiple Value list | ||
+ | |||
|} | |} | ||
Line 410: | Line 454: | ||
== Reliability of Reports #1: Damage Reports Over Time == | == Reliability of Reports #1: Damage Reports Over Time == | ||
− | [[File: | + | '''Dashboard Design''' </br> |
+ | |||
+ | '''Purpose / Description''' | ||
+ | |||
+ | <p>The aim of the dashboard is to analyze reports made before the earthquake and understand more about the delay in reports in some of the neighbourhoods. The charts used in this dashboard is similar to the Time of Earthquake dashboard described above. </p> | ||
+ | |||
+ | One of the differences is that was a mode chart was added in and it has its own filter for Damage Type. This will allow the user to make comparisons between the average impact score for a specific damage type and time with the mode for Power damages etc. The mode chart will also allow users to identify anomalies in the data easily. This chart instead of a map since the user can make comparisons across the different neighbourhoods and see the mode clearly without having to hover over the data point or look at how dark the color is in the heat map. | ||
+ | |||
+ | Furthermore, if there is 1 mode for each neighborhood, we can check if there is a big variation in impact levels reported. For example, if a neighbourhood has a mode of Weak and a mode of Severe at a specific timing for a specific damage type, it shows the uncertainty and inaccuracy in the data. When using a map, if there are 2 modes, the mode that is displayed on the map is the maximum value and this suggests that we will not be able to detect the difference in impact levels. | ||
+ | |||
+ | A maintenance/hospital column is also added to this dashboard and it will indicate if there is maintenance work or hospitals within the neighborhood based on the selected damage type. The description will be displayed when the user hovers over the data point. | ||
+ | |||
+ | Dashboard Tip: Analyse the number of reports chart first and identify the timeframe where there is a surge in reports. Next, explore the Average Impact Score chart, followed by the Mode chart. Filter the Mode chart by Damage Type to analyze the severity of the damage and detect outliers in the data. | ||
+ | |||
+ | [[File:Reliability design latest.jpg|center|700px]] | ||
− | + | '''Interactive Techniques''' </br> | |
<p>The following interactive techniques have been employed in this dashboard:</p> | <p>The following interactive techniques have been employed in this dashboard:</p> | ||
Line 446: | Line 504: | ||
The parameter is used for filtering the records and the steps are slightly different as compared to the one on Hardest Hit Areas dashboard (Change View) which is for sheet swapping. | The parameter is used for filtering the records and the steps are slightly different as compared to the one on Hardest Hit Areas dashboard (Change View) which is for sheet swapping. | ||
− | + | # Create a parameter | |
# In the Create Parameter dialog box, do the following: Enter the name that will appear above the menu like 'Select Impact Level (Preset)'. For Data type, select Integer. For Allowable Values, select List. <br> [[File:Impact Level Preset Settings.jpg|250px|center]] | # In the Create Parameter dialog box, do the following: Enter the name that will appear above the menu like 'Select Impact Level (Preset)'. For Data type, select Integer. For Allowable Values, select List. <br> [[File:Impact Level Preset Settings.jpg|250px|center]] | ||
# Show the Parameter in the worksheet/dashboard. | # Show the Parameter in the worksheet/dashboard. | ||
Line 453: | Line 511: | ||
|- | |- | ||
− | | <center>'''Hover over the data points in the line chart to find out more about the proportion of reports made by each neighbourhood'''</center> [[File:Tooltip Proportion .jpg| | + | | <center>'''Hover over the data points in the line chart to find out more about the proportion of reports made by each neighbourhood'''</center> [[File:Tooltip Proportion .jpg|250px|center]] <br> |
|| | || | ||
* When a user hovers over a mark, the tooltip displays relevant data and details from a separate and related visualization (The proportion of reports chart) filtered to that mark. | * When a user hovers over a mark, the tooltip displays relevant data and details from a separate and related visualization (The proportion of reports chart) filtered to that mark. | ||
Line 463: | Line 521: | ||
|- | |- | ||
− | | <center>'''Hover over the data points of each map to find out more information about the neighbourhood'''</center>[[File:Maintainence or hospital info.jpg| | + | | <center>'''Hover over the data points of each map to find out more information about the neighbourhood'''</center>[[File:Maintainence or hospital info.jpg|250px|center]] |
<br> | <br> | ||
|| | || | ||
Line 476: | Line 534: | ||
== Reliability of Reports #2: Comparison of Maximum Impact Scores Over Time == | == Reliability of Reports #2: Comparison of Maximum Impact Scores Over Time == | ||
− | + | '''Dashboard Design''' </br> | |
+ | |||
+ | '''Purpose / Description | ||
+ | ''' | ||
− | + | The aim of the dashboard is to compare the maximum impact scores before, during and after the earthquake and it can be used to detect anomalies in the data. The Earthquake Period preset also helps the user to speed up the time taken to analyze between 2 periods. We are assuming that there is no earthquake after the one on 8 April for this analysis. | |
+ | |||
+ | [[File:Comparison 2.jpg|700px|center]] | ||
+ | |||
+ | '''Interactive Techniques | ||
+ | ''' | ||
<p>The following interactive techniques have been employed in this dashboard:</p> | <p>The following interactive techniques have been employed in this dashboard:</p> | ||
Line 502: | Line 568: | ||
== Reliability of Reports #3: Variation In Impact Scores == | == Reliability of Reports #3: Variation In Impact Scores == | ||
− | + | '''Dashboard Design''' </br> | |
− | + | '''Purpose / Description | |
+ | ''' | ||
+ | |||
+ | The aim of the dashboard is to explore the differences in the reported impact scores by citizens who live in the same region / within the neighborhood. Based on the shakemap on 8 April, we can estimate how close or far a neighbourhood is from the epicenter. A map of St. Himark is added to the dashboard so that users can see that neighborhoods like Palace Hills are very far away from the earthquake. We can see if there are discrepancies/false reports made through the Variation in the Impact Scores chart. A stacked bar chart is used since we want to see the proportion of reports made for each impact level group and compare it with other neighborhoods in the same region. | ||
+ | |||
+ | For instance, since Old Town and Safe Town are close to the epicenter, it is unlikely for shake intensity reports with an impact score of 1 to 3 to be made since the impact should be the strongest. Furthermore, it is easy to see if there is a big difference in impact levels reported across the region and within the neighbourhood itself at a specific timing. | ||
+ | |||
+ | [[File:Variation 3.jpg|700px|center]] | ||
+ | |||
+ | '''Interactive Techniques | ||
+ | ''' | ||
<p>The following interactive techniques have been employed in this dashboard:</p> | <p>The following interactive techniques have been employed in this dashboard:</p> | ||
+ | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Line 514: | Line 591: | ||
|- | |- | ||
− | | <center>'''Filter by Estimated Distance to Epicenter Using A Drop-Down List'''</center>[[File: | + | | <center>'''Filter by Estimated Distance to Epicenter Using A Drop-Down List'''</center>[[File:Distance_filter.jpg|200px|center]] |
− | + | </br> | |
|| | || | ||
− | * Users will able to focus on a specific region (eg. cities that are close to the epicenter) to identify patterns/anomalies or make comparisons between the region to check the reliability of the data. | + | * Users will able to focus on a specific region (eg. cities that are close to the epicenter) to identify patterns/anomalies or make comparisons between the region to check the reliability of the data. |
− | * A multi-select drop-down list will be useful since we can see the data across neighbourhoods and narrow down if needed | + | * A multi-select drop-down list will be useful since we can see the data across neighbourhoods and narrow down if needed |
|| | || | ||
Line 526: | Line 603: | ||
|- | |- | ||
− | | <center>'''Highlight Neighbourhoods Based On Estimated Distance to Epicenter'''</center>[[File: | + | | <center>'''Highlight Neighbourhoods Based On Estimated Distance to Epicenter'''</center>[[File:Highlight_distance_to_epicenter.jpg|200px|center]] |
− | + | </br> | |
|| | || | ||
* To highlight neighbourhoods that are of interest to the analyst based on its proximity to the earthquake | * To highlight neighbourhoods that are of interest to the analyst based on its proximity to the earthquake | ||
Line 533: | Line 610: | ||
This is one of the ways to highlight a dimension. | This is one of the ways to highlight a dimension. | ||
− | # Drag the Neighbourhood file to the Filters shelf. | + | |
− | # Right-click on Neighbourhood and select Show Highlighter | + | # Drag the Neighbourhood file to the Filters shelf. |
− | [[File: | + | # Right-click on Neighbourhood and select Show Highlighter |
+ | |||
+ | [[File:Highlight_neighbourhood_step.jpg|200px|center]] | ||
|- | |- | ||
− | | <center>'''Reliability Check Presets For Faster Filtering'''</center> | + | | <center>'''Reliability Check Presets For Faster Filtering'''</center>[[File:Reliability_Check_(Extremes).jpg|200px|center]] |
− | [[File: | + | </br> |
|| | || | ||
− | * This preset | + | * This preset allows users to quickly explore the extreme ends of the impact scores by region and identify anomalies |
− | * It eliminates the need of having to manually select the impact score to make comparisons | + | * It eliminates the need of having to manually select the impact score to make comparisons |
|| | || | ||
+ | |||
+ | This is one of the ways to highlight a dimension. | ||
# Follow the same steps as mentioned in the Reliability of Reports #1: Damage Reports Over Time dashboard (Impact Level Preset) | # Follow the same steps as mentioned in the Reliability of Reports #1: Damage Reports Over Time dashboard (Impact Level Preset) | ||
Line 552: | Line 633: | ||
== Reliability of Reports #4: Damage Uncertainty == | == Reliability of Reports #4: Damage Uncertainty == | ||
− | + | '''Dashboard Design''' </br> | |
− | + | '''Purpose / Description | |
+ | ''' | ||
+ | |||
+ | The aim of this dashboard is to explore the relationship between shake intensity and other damage types to show uncertainty in the data. If a neighbourhood have a high shake intensity but the other damage types seem to experience less damages, it could possibly be an anomaly. To analyse this chart, look at the Y axis which is the range for shake intensity. Find the rectangle which is darker in color since it denotes that there were more reports made. Look to the left and see what the impact score is like for the other damage types OR hover over the data points. | ||
+ | |||
+ | [[File:Uncertainty.jpg|700px|center]] | ||
+ | |||
+ | == Uncertainty in Change Over Time == | ||
+ | |||
+ | '''Dashboard Design''' </br> | ||
+ | |||
+ | '''Purpose / Description | ||
+ | ''' | ||
+ | Find out if there is a relationship between shake intensity and the number of reports over time and assume that there were 3 earthquakes. A dual-axis chart is useful in comparing the shake intensity and other damage types in a specific time frame. | ||
+ | |||
+ | [[File:Meh.jpg|700px|center]] | ||
+ | |||
+ | '''Interactive Techniques | ||
+ | ''' | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | Interactive Technique | ||
+ | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Rationale | ||
+ | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;" | Brief Implementation Steps | ||
+ | |||
+ | |- | ||
+ | | <center>'''Highlight selected item'''</center> </br> | ||
+ | [[File:Highlighter.jpg|200px|center]] | ||
+ | </br> | ||
+ | || | ||
− | + | * Highlight actions allow us to call attention to marks of interest by dimming all others. It works well with a small amount of data. | |
+ | * Right-click on the legend and click on Highlight Selected Item | ||
+ | || | ||
+ | # Follow the steps in the Reliability of Reports #1: Damage Reports Over Time dashboard (Impact Level Preset For Faster Filtering). | ||
+ | # Create a parameter. Show the Parameter. Create a calculated field. Drag the calculated field to the Filter shelf. | ||
|} | |} |
Latest revision as of 02:02, 13 October 2019
VAST 2019 MC1: Crowdsourcing for Situational Awareness
|
|
|
|
|
Contents
- 1 Dashboard Overview
- 2 Common Interactive Features Across All Dashboards
- 3 Overview
- 4 Shake Map Analysis
- 5 Time Of Earthquake
- 6 Hardest Hit Areas
- 7 Emergency Response Planning
- 8 Prioritization - Building, Medical, Power
- 9 Prioritization - Roads and Bridges, Sewer and Water
- 10 Reliability of Reports #1: Damage Reports Over Time
- 11 Reliability of Reports #2: Comparison of Maximum Impact Scores Over Time
- 12 Reliability of Reports #3: Variation In Impact Scores
- 13 Reliability of Reports #4: Damage Uncertainty
- 14 Uncertainty in Change Over Time
Dashboard Overview
The interactive visualization can be accessed here: https://public.tableau.com/views/AssignmentVA_15709028039740/Overview?:embed=y&:display_count=yes&:origin=viz_share_link
For the best experience, adjust your screen resolution to 1366x768 and enable full screen on the browser. Adjust the dashboard so that all elements can be clearly visible without the need to scroll up/down.
A summary of the breakdown of the visualizations created for Question 1 is as shown below.
No. | Dashboard Name | Purpose |
---|---|---|
1 | Overview | Provide more information on the Mini-Challenge and the questions that will be addressed |
2 | Shake Map Analysis | Gain a better idea of the situation and see if the reports reveal the same key observations |
3 | Time Of Earthquake | Identify when the earthquake started and use the identified timeframe for further analysis |
4 | Hardest | Identify which neighbourhoods are hardest hit from the earthquake |
5 | Emergency Response Planning | Determine how the emergency response should change based on the reports made |
6 | Prioritization: Building, Medical, and Power Damages | Some cities are more affected than others and prioritizing the right cities based on the damage types is a very crucial step |
7 | Prioritization: Roads and Bridges, Sewer and Water Damages | Some cities are more affected than others and prioritizing the right cities based on the damage types is a very crucial step |
A summary of the breakdown of the visualizations created for Question 2 is as shown below.
No. | Dashboard Name | Purpose |
---|---|---|
1 | Reliability Of Reports #1: Damage Reports Over Time | Analyse reports made before the earthquake and delay in reports |
2 | Reliability Of Reports #2: Comparison Of Maximum Impact Scores Over Time | Observe the change in impact scores before, during and after the earthquake |
3 | Reliability Of Reports #3: Variation In Impact Scores | Explore the differences in the reported impact scores by citizens who live in the same region / within the neighbourhood |
4 | Damage Uncertainty | Observe the relationship between shake intensity and other damage types |
A summary of the breakdown of the visualizations created for Question 3 is as shown below.
No. | Dashboard Name | Purpose |
---|---|---|
1 | Uncertainty in Change Over Time | Use research on earthquakes to explore the uncertainty in the data throughout the entire period. Insights for key changes will be derived from other charts listed above. |
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:
Common Interactive Features Across All Dashboards
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
The following sections elaborate on the dashboard design and other interactivity techniques that are integrated into each of the individual dashboards.
Overview
Purpose / Description
The Overview is the landing page you will see when you open the workbook/link. This is considered the home page for this visualization. Icons are used to explain how crowdsourcing works and how it will used by the emergency response team. The visualization goals are also started here to give the user an idea of what to expect from the dashboards.
Shake Map Analysis
Dashboard Design
Purpose / Description
Before we begin analyzing the reports, we will first analyze the shake maps that were captured on 6 April and 8 April 2020. This is a crucial step since the shake maps will be used to check the reliability of the reports made by citizens through the Rumble app - Do the reports reveal the same key observations? The shake maps indicate the corresponding earthquakes' epicenters and how much shaking can be felt across the city. This is critical for emergency decision making. Insights gained from the shakemap are also displayed here.
Time Of Earthquake
Dashboard Design
Purpose / Description
The aim of the dashboard is to analyze the number of reports made by each neighbourhood throughout the entire period and identify the time of the earthquake. The charts are placed side by side to allow for easier analysis. The filters are consistently placed at the right side of the dashboard and the tips will help the user to explore the chart on their own. The line chart is used since the objective is to show the trend in reports made over time.
Interactive Technique
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
| |
|
|
Hardest Hit Areas
Dashboard Design
Purpose / Description
The aim of the dashboard is to analyze the average shake intensity and the number of shake intensity reports made for each neighbourhood throughout the entire period. A heatmap is used to show the average shake intensity as it allows the user to quickly identify areas that are more affected by the earthquake. The gaps in the chart indicate that no reports (for all damage types) were made. Null impact scores are not filtered out in this chart. Therefore, if the user hover over the data points and the average shake intensity is empty, it means that the impact score is Null.
For the Shake Intensity By Impact Level chart, the purpose is to show the variation in impact levels reported and to identify cities that are hardest hit. There are 2 options to view this chart – Horizontal or Vertical. A grouped bar chart is used since it allows for easy comparison and identification of patterns and anomalies.
Interactive Technique
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
Note: There are 2 separate sheets used for this visualization - Horizontal and Vertical
| |
|
| |
|
|
Emergency Response Planning
Dashboard Design
Purpose / Description
The emergency response can be determined by the mode of the damages. The blank map makes it easy for users to see the change in the size of the circle marks which denotes the number of reports over time. The bigger the size, the greater the number of reports made by a specific neighbourhood. The mode chart is represented by the maximum number of reports made by the impact score for each damage type and neighbourhood. It is better to use mode instead of average and maximum since they are prone to be affected by outliers. An area that is the hardest hit may not always have a very high number of reports since there are other factors that could influence the number of reports like the size of the population in a neighbourhood.
Therefore, using the mode of the impact score seems to be a better option in assessing the extent of the damage. The overview table will also provide the emergency responders with a breakdown of the reports by impact scores if they prefer to look at the details. The maps would allow them to get the information they are looking for at a glance.
Interactive Techniques
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
| |
|
| |
|
|
Prioritization - Building, Medical, Power
Dashboard Design
Purpose / Description
The aim of the dashboard is to identify neighborhoods to prioritize based on the damage reports and shake maps. Having maps for each damage type will allow users to see an overview of the damages across types and the heatmap makes it easy to identify areas that require more immediate attention than others. The relevant information like maintenance work and building information is strategically placed below the chart so that the team can refer to it and take that into consideration when making critical decisions.
An assumption made is that the emergency response team comprise of different divisions and responders are specialized or trained to deal with a specific damage type. The Amenities filter can also come in handy when it comes to transporting the injured to the hospitals and the school can be turned into a temporary shelter if needed.
Interactive Techniques
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
| |
|
|
Prioritization - Roads and Bridges, Sewer and Water
Dashboard Design
Purpose / Description
The aim of the dashboard is to identify neighborhoods to prioritize based on the damage reports and shake maps. Having maps for each damage type will allow users to see an overview of the damages across types and the heatmap makes it easy to identify areas that require more immediate attention than others. The relevant information like maintenance information is strategically placed below the chart so that the team can refer to it and take that into consideration when making critical decisions.
Possible implications of maintenance work: Repair work on some roads will result in delays in traffic. This can also mean that rescue efforts may be affected.
Interactive Techniques
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
| |
|
|
Reliability of Reports #1: Damage Reports Over Time
Dashboard Design
Purpose / Description
The aim of the dashboard is to analyze reports made before the earthquake and understand more about the delay in reports in some of the neighbourhoods. The charts used in this dashboard is similar to the Time of Earthquake dashboard described above.
One of the differences is that was a mode chart was added in and it has its own filter for Damage Type. This will allow the user to make comparisons between the average impact score for a specific damage type and time with the mode for Power damages etc. The mode chart will also allow users to identify anomalies in the data easily. This chart instead of a map since the user can make comparisons across the different neighbourhoods and see the mode clearly without having to hover over the data point or look at how dark the color is in the heat map.
Furthermore, if there is 1 mode for each neighborhood, we can check if there is a big variation in impact levels reported. For example, if a neighbourhood has a mode of Weak and a mode of Severe at a specific timing for a specific damage type, it shows the uncertainty and inaccuracy in the data. When using a map, if there are 2 modes, the mode that is displayed on the map is the maximum value and this suggests that we will not be able to detect the difference in impact levels.
A maintenance/hospital column is also added to this dashboard and it will indicate if there is maintenance work or hospitals within the neighborhood based on the selected damage type. The description will be displayed when the user hovers over the data point.
Dashboard Tip: Analyse the number of reports chart first and identify the timeframe where there is a surge in reports. Next, explore the Average Impact Score chart, followed by the Mode chart. Filter the Mode chart by Damage Type to analyze the severity of the damage and detect outliers in the data.
Interactive Techniques
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
| |
|
The parameter is used for filtering the records and the steps are slightly different as compared to the one on Hardest Hit Areas dashboard (Change View) which is for sheet swapping.
| |
|
| |
|
|
Reliability of Reports #2: Comparison of Maximum Impact Scores Over Time
Dashboard Design
Purpose / Description
The aim of the dashboard is to compare the maximum impact scores before, during and after the earthquake and it can be used to detect anomalies in the data. The Earthquake Period preset also helps the user to speed up the time taken to analyze between 2 periods. We are assuming that there is no earthquake after the one on 8 April for this analysis.
Interactive Techniques
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
|
|
Reliability of Reports #3: Variation In Impact Scores
Dashboard Design
Purpose / Description
The aim of the dashboard is to explore the differences in the reported impact scores by citizens who live in the same region / within the neighborhood. Based on the shakemap on 8 April, we can estimate how close or far a neighbourhood is from the epicenter. A map of St. Himark is added to the dashboard so that users can see that neighborhoods like Palace Hills are very far away from the earthquake. We can see if there are discrepancies/false reports made through the Variation in the Impact Scores chart. A stacked bar chart is used since we want to see the proportion of reports made for each impact level group and compare it with other neighborhoods in the same region.
For instance, since Old Town and Safe Town are close to the epicenter, it is unlikely for shake intensity reports with an impact score of 1 to 3 to be made since the impact should be the strongest. Furthermore, it is easy to see if there is a big difference in impact levels reported across the region and within the neighbourhood itself at a specific timing.
Interactive Techniques
The following interactive techniques have been employed in this dashboard:
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
|
|
|
|
This is one of the ways to highlight a dimension.
|
|
|
This is one of the ways to highlight a dimension.
|
Reliability of Reports #4: Damage Uncertainty
Dashboard Design
Purpose / Description
The aim of this dashboard is to explore the relationship between shake intensity and other damage types to show uncertainty in the data. If a neighbourhood have a high shake intensity but the other damage types seem to experience less damages, it could possibly be an anomaly. To analyse this chart, look at the Y axis which is the range for shake intensity. Find the rectangle which is darker in color since it denotes that there were more reports made. Look to the left and see what the impact score is like for the other damage types OR hover over the data points.
Uncertainty in Change Over Time
Dashboard Design
Purpose / Description Find out if there is a relationship between shake intensity and the number of reports over time and assume that there were 3 earthquakes. A dual-axis chart is useful in comparing the shake intensity and other damage types in a specific time frame.
Interactive Techniques
Interactive Technique | Rationale | Brief Implementation Steps |
---|---|---|
|
|
|