Difference between revisions of "IS428 2016-17 Term1 Assign2 Zheng Xiye"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 10: Line 10:
  
 
==Tools==
 
==Tools==
 +
#Tableau Desktop
 +
#JMP Pro 12
 +
#Microsoft Excel
  
 
==Approaches==  
 
==Approaches==  
 +
===Data Preprocessing===
 +
====1. Data Selection====
 +
{| class="wikitable" style="background-color:#FFFFFF; width: 1000px;" align="center"
 +
|-
 +
! style="color:#ecf0f1; background-color:#005F6B;" width="300pt" | S/D
 +
! style="color:#ecf0f1; background-color:#005F6B;" width="1500pt" | Data Categories
 +
! style="color:#ecf0f1; background-color:#005F6B;" width="700pt" | Data Variables
 +
 +
|-
 +
|style="text-align: center;"|I.
 +
|Accident Time Data
 +
|
 +
#Reported Date
 +
#Accident Date
 +
 +
|-
 +
|style="text-align: center;"|II.
 +
|Accident Industry Data
 +
|
 +
#Major Industry
 +
#Sub Industry
 +
 +
|-
 +
|style="text-align: center;"|III.
 +
|Accident Type Data
 +
|
 +
#Accident Type Category
 +
 +
|-
 +
|style="text-align: center;"|IV.
 +
|Accident Victims Data
 +
|
 +
#Victims' Gender
 +
#Victims' Age
 +
#Occupation
 +
#Injuried (Overtime)
 +
#Injuried (Official Work Duties)
 +
|}
 +
  
 
==Conclusion==
 
==Conclusion==

Revision as of 17:22, 25 September 2016

Theme of Interest

Workplace security and safety has always been one of the essential areas of consideration in Singapore when structuring government policies. Singapore government's high concerns over its workforce's physical well-being has not only reassured its people of conducive working environment but also attracted talents from nearby countries to maintain the sustainable growth of Singapore's economy. However, SMRT Track Accident on 22nd March earlier this year, has sparked off another round of discussion centering around the extend of safety measures that should be implemented in Singapore's workplace. Disputes from which went beyond the context of SMRT Operations Safety Protocols to every aspects of measures, necessary in preventing workplace injuries. On top of which, according to WSHI National Statistics Report 2014, although the number of workplace fatal injury cases has decreased from 73 to 60, number of major and minor injuries in 2014 remain as high as 2013 and going on an increasing trend to 672 and 12,863 respectively from 640 and 11,740. From this perspective, exploring potential correlations between various factors and injury rate may be beneficial in structuring preventive and mitigation actions accordingly.
Workplace Stats.JPG

Analytical & Investigation Questions

Questions listed below are potential correlations hoping to be substantiated with concrete data exploration outputs:

  1. Which periods of the year are having the highest work injuries rate?
  2. Which sub-industries did most of the work injuries fall under?
  3. Which groups of victims with certain characteristics combination are experiencing largest number of work injuries?

Tools

  1. Tableau Desktop
  2. JMP Pro 12
  3. Microsoft Excel

Approaches

Data Preprocessing

1. Data Selection

S/D Data Categories Data Variables
I. Accident Time Data
  1. Reported Date
  2. Accident Date
II. Accident Industry Data
  1. Major Industry
  2. Sub Industry
III. Accident Type Data
  1. Accident Type Category
IV. Accident Victims Data
  1. Victims' Gender
  2. Victims' Age
  3. Occupation
  4. Injuried (Overtime)
  5. Injuried (Official Work Duties)


Conclusion

Reference

WSHI National Statistics Report 2014 SMRT Track Accident

Comments