IS428 2016-17 Term1 Assign2 Liang Bing

From Visual Analytics for Business Intelligence
Revision as of 18:16, 24 September 2016 by Bing.liang.2013 (talk | contribs)
Jump to navigation Jump to search

Abstract

In order to put Singapore's workplace safety and health (WSH) performance on par with the world's leading countries, The Workplace Safety and Health (WSH) Institute is established to collaborate with MOH to work on researching, as well as data collecting and analyzing to understand the current and emerging work environment in Singapore, and use the knowledge discovered to develop solutions for improving WSH practices. One of the field of concern is the workplace injury. This report will utilize the workplace injury data provided by WSHI to explore insights which could help find trends and understand the workplace injury situation in 2014.

Theme of Interest

Workplace injury has always been a concern of WSH. Workplace injury can be seen as the accidents happen to workers in their working environment. Some job s are naturally more dangerous than the normal office jobs. Also, certain group of people will have higher chance to get injured during work compare to others. Therefore, finding out the victims' characteristics which has high probability to have injured incidents is very important for WSHI and stakeholders to understand the risk in their workplace and improve their management accordingly. This hence is the main focus of this report.

Questions for Investigation

The following are the questions guides through the data exploration process to determine how the characteristics of workplace injury victims affect their nature of injury:

  1. How does occupation affect their nature of injury.
  2. Work overtime and cause of injury (self/external)
  3. Percentage of manual work and nature of injury.

Understanding the Data

Data Attributes

There are a total of 5650 rows of data with 48 attributes(Columns)per row.
Wid lb ass2 rowscol.png
The figure below shows all the 48 attributes provided in the WID excel file:
Wid lb ass2 48attributes.png

Data Selection & Preparation

Not all of the 48 data attributes are useful in providing information needed by this report. For example, the informant's information and employer's information are not the main concern of this report:
Wid lb ass2 proneanyway.png
After using JMP and Microsoft Excel to examine all the data attributes, irrelevant columns are removed and the rest are the data attributes which could add value to the report analysis.

Below are the data attributes remained:
Wid lb ass2 pruneleft2.png

After pruning the irrelevant data, some of the nominal data should be standardized in terms of the letter cases. For example, for the Occupation Column, the same word "cook" is recorded in both upper case"COOK" and lower case "cook". The standardization process uses JMP's formula function:
1. Create a new column called "Occupation Lower Case", right click on the column header to find the formula tab:
Wid lb ass2 cookupperlower2.png
2. Drag the Occupation attribute from Table Columns into the workspace , and then select Lower Cases function from the Character option, click "ok":
Wid lb ass2 formulalowercase2.png
3. The new column "Occupation Lower Case" is created:
Wid lb ass2 newoccupationlowercase.png

Moreover, there are typos in the Occupation column which resulted in meaningless occupation categories being created. e.g. the "cleaner" typo.
Wid lb ass2 cleanertypo.png
Also, the non-standardized occupation words have resulted in missing count of same kind of occupations. e.g. the "assembler" & "assemblers" means the same occupation obviously.
Wid lb ass2 assembler.png
I have exported the pruned data as excel file from JMP to filter through and clean these data with typo and minor differences. After few rounds of filtering and fixing, the data is read for use.

Data Exploration and Findings

Visualization 1 : The nature of injury pattern for various occupations

Visualization 1 : The injury pattern for various occupations

Final Analysis

Interactive Data Visualization

Tools

  1. Excel:
  2. JMP:

References

WSH Institute Official Website