IS428 AY2019-20T1 Assign Chew Hui Ling Data Preparation
VAST Challenge 2019 MC 1: Crowdsourcing for Situational Awareness
|
|
|
|
|
Data Analysis
Before the analysis began, the dataset given is analysed to identify its respective format and attributes. There was only 1 csv file provided in the assignment which meant that there was minimal amount of information that can be analysed. Hence, I will be taking the shp file from mini challenge 2 as well as creating one csv file called connection to do my transformation process for each dataset.
Mini-challenge 1 Reports
500px
Within the report, it shows the time, damage taken by the different components, shake intensity and location. This provides minimal information for data visualization. Hence, in order to improve the current data that we have, I will be doing the following changes: 1. For each component: power, medical buildings. It would be hard to see all the values together. This is because either you must put 5 graphs together or you will have to create a calculated field to add all the 5 values together. Instead of doing that, pivoting will help to generate 1 column for the component name and 1 column for the component value. And with filter it will allow the user to view all or the components separately. 2. For each value within the component, there is no specific name attached. The user only knows that 10 is the highest and 0 is the lowest. But for user experience, it is much better to attach something to the value such as 0 = Weak, etc. 3. Within the report, there is no specific name for each location and to solve the problem. I will be using the shp file to integrate the location number and name together.
