IS428 2016-17 Term1 Assign2 Yang Chengzhen

From Visual Analytics for Business Intelligence
Revision as of 11:07, 25 September 2016 by Czyang.2013 (talk | contribs)
Jump to navigation Jump to search

Description

Abstract

Workplace Safety and Health has always been one of the top concern of Ministry of Manpower. To better manage MSH, MOM established Workplace Safety and Health (WSH) Council on 1 Apr 2008. WSH Concil coordinates with MOM to conduct research on workplace safety and health performance in Singapore. The WSH Institute conducts quality applied research and provides evidence-based information to Ministry of Manpower, WSH Council and industry stakeholders to improve WSH practices in Singapore. The data used were collated from incident reports made by employers, occupiers and medical practitioners.
This Assignment will generate analysis utilizing WSHI work place injuries data in year 2014 to gain insights of workplace safety and health situation in 2014.

Theme of Interest

In order to be more efficient in improving workplace safety and health situation, it is essential to find out the 'Vulnerable groups' and characteristics tied with different groups. Therefore MOM can provide customized plans in order to prevent the happens of injuries and react to injuries faster and smarter.
This assignment aims to find out the major vulnerable groups and peak period of workplace injury cases to facilitate MOM's customization of planning and policy-making.

Research Question

Data Preparation

Attribute Selection

There are 48 columns in the raw data. After scanning through, I selected some attributes which are more relevant in identifying victim groups:

  • Accident Type Level 1 Category
  • Accident Type Level 2 Category
  • Accident Date
  • Nature of Injury
  • Major Industry
  • Sub Industry
  • Victim's Age
  • Victim's Gender
  • Informant's No of employees
  • Injured When Working Overtime

Data Preparation

Check Missing Values

Use JMP to find missing data pattern relating to the attributes selected in the previous section, only one missing data is found. I decided to ignore the record since it has no significant impact to the analysis. Cz-Missing-1.png

Check Distribution of Numerical Attribute

Cz-age-distribution.png Cz-noof employees.png Cz-mcdays.png

Data Exploration

How does injuries distribute in different industries?

Overview with Major/Minor injury distribution

  • Industry has many categories. In order to have a intuitive view of the distribution of injury, I used treemap to visualize the data.

Industry-injury type-explanation.png Major-sub-industry.png

Implementation

Findings

Conclusion

Comments