IS428 2019-1920 T1 Assign LeeSunho Data Preparation

From Visual Analytics for Business Intelligence
Revision as of 21:29, 12 October 2019 by Sunho.lee.2017 (talk | contribs)
Jump to navigation Jump to search
-
Data Exploration & Transformation Process


Problem & Motivation


Data Exploration & Transformation Process

Interactive Visualization


Insight

The dataset zip file

  • AnswerSheet Folder
  • MC1-DataDescription ( Word document )
  • mc1-majorquake-shakemap ( PNG File )
  • mc1-prequake-shakemap ( PNG File)
  • mc1-reports-data ( Excel document )
  • VAST 2019 - St. Himark - About Our City ( Word document )

mc1-reports-data

Data 1.png









====mc1-reports-data==== includes


  • 83700 datas
  • Time (d/m/yyyy h:mm)
    • Time: 6/4/2020 12:00:00 am to 11/4/2020 12:00:00 am
  • sewer_and_water (number)
    • sewer_and_water: 0 to 10 with blanks
  • power (number)
    • power: 0 to 10
  • roads_and_bridges (number)
    • roads_and_bridges: 0 to 10
  • medical (number)
    • medical: 0 to 10 with blanks
  • buildings (number)
    • buildings: 0 to 10 with blanks
  • shake_intensity (number)
    • shake_intensity: 0 to 9 with blanks
  • location (number)
    • 1 to 19


=Issue

1.null data

Out of 83700, 59925 data are null data.

2.Intensity level is not specified into group.

Group.jpg

As the reported earthquake intensities are on a scale of 1-10, it is important for users to first understand what these numbers actually mean. Above is a table which succinctly summarizes the scale, explaining that a 1 is basically a non-existent earthquake while a 10 is a catastrophic one. Furthermore, an intensity greater than 6 signifies that the earthquake is strong enough to cause damage.


3.The data does not have longitude and latitudes hence there is issue with plotting map.


=Solution

1. The reason why there are null data might be because the data is lively collected, it is possible the report is not properly recorded, or they might purposely not show it.

2. Group the intensity level

Data 2 group.png

I have used tebleau group function to group the intensity level. Hence, user can identify seriousness of the reported value.

3. In order to plot Map chart, I have downloaded mini2 case data’s “StHimark.shp” file using Tableau which will allow me to visualize map. In order to solve