IS428 2016-17 Term1 Assign2 Wang Jingxuan

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search

Abstract

Workplace Safety and Health (WSH) includes legal requirements, certification and registration, monitoring and surveillance, accident reporting and work injury compensation. We understand that certain types of work may have higher chance of getting injured, and some injures are due to bad management and overtime. So based on data given by Workplace Safety and Health(WSH), we want to explore the patterns of work-related injuries.

Data Visualisation System Design Process

1. Identify a theme of interest
Safety has always been a great concern to Workplace Safety and Health (WSH) and it has always been trying to reduce work-related injury. A work-related accident is any unintended event that occurs in the course of work (excluding domestic work) that leads to an injury or condition. Based on injury data given by Workplace Safety and Health (WSH) We try to identify patterns of injuries types, victims' characteristics, and injury time.
2. Define questions for investigation
Are there patterns in accident occurring time?
What are the industries/occupation that accidents occur frequently?
Are there and what are the patterns of injuries types?
Are there and what are the patterns of victims?
3. Find appropriate data attributes
Among all only 26 columns are chosen, and they are shown in the graph.
Selectcolumn.png
Then we realize for the occupation column, there are duplicates, and the only difference is uppercase and lowercase. As graph shown 'cook' is the same as 'COOK'.
Cook.png
So I used JMP Pro lowercase function lowercase the occupation column as the graph shown.
Lowercase.png
And the missing values are insiginificant.
Missing data.png

Analysis

Q1. Is there a relationship between the experience of employees and workplace injury?
Age.png
Worked.png
Agedistribution.png
From the above graphs, we realized that most of the injured workers are quite young, the victims' age distribution is quite skewed and its interquartile range is between 28 and 48. And from the graph of worked months, we noticed that with increasing number of working months, the number of victims reduces. The worked months distribution are quite skewed towards small number of worked months. So we made speculation that with more working experience, the less chance that workers will get injured. So safety training could important to those young workers with less experience.

Q2. Are there patterns of injury time
Group1.png
As above graph shown, in order to study patterns of injury time, we used the attribute Accident Time. However Accident Time is in minutes. So I have to group them up by hour, for example from 12:00-1:00 AM.
Group2.png
As above graph shown, I further categorize the hours into parts of day, 9 PM - 4 AM is night, 4 AM - 12 PM is morning, 12 PM - 5 PM is afternoon and 5 PM - 9 PM is evening.
AccidentTime.png
As the above graph shown, most of the accidents occur during morning and afternoon. And morning 10:00 AM - 11:00 AM, afternoon 2:00 PM - 3:00 PM is the peak hour for accidents. So during that period of time, some measures could be implemented. For example, giving workers a short break.
Q3. Are there Patterns of injury types
Construction.png
From the graph above, we noticed that most of accidents came from construction workers. As the construction workers has the darkest color and largest range. ConstructionInjury.png
So we further drill down to construction, from the above graph, we found out most frequent accidents are cut braises and crushing, followed by sprain strains and others. ConstructionWorker.png
However if we drill down to major accidents, we found out that crushing and amputation constitute the large proportion of accidents. So in order Safty measures and guidelines should be highlighted in workplace, especially avoiding crushing and amputation in construction.

Interactive Dashboard Visualisation

The interactive dashboard visualisation can be found here

Tools Utilized

  1. JMP PRO 12
  2. Microsoft Excel
  3. Tableau 10.0

References

http://www.mom.gov.sg:8083/workplace-safety-and-health