IS428 2016-17 Term1 Assign2 Lim Ting Zhi

Theme of Interest

Regardless of the organisation or industry, having a safe work environment is very important. Any injury could cause a major issue to the victim’s family, co-workers or the organisation itself. Other than the mental and physical suffering, the financial burden could be placed on other family members. For the organisation, having a safe environment would lessen unnecessary costs. If an employee is injured, the organisation’s productivity will decline. Other co-workers' workload will increase to cover for the victim. Safety also improves the quality of work produced as employees would be focusing on their work than their safety. Therefore, the following analysis would be to find out the factors that contribute to workplace injuries by using the dataset provided, Workplace Injuries Data 2014. So that related organisations or industries could keep in mind to reduce the number of workplace injuries occurred.

General Questions for Investigation

1. How did the workers get injured?
2. Where did the workers get injured at?
3. What are the injuries?
4. What is the profile of the worker?
5. When did the workers get injured?

Tools Utilized

The following tools were utilized during the analysis:

1. Microsoft Excel 2016
2. JMP Pro 12 – Data preparation
3. Tableau 10.0 – Create visualizations and interactive dashboards, and publish final visualization online

Data Attributes Used

1. Accident Agency Level 1 Desc
2. Accident Agency Level 2 Desc
3. Accident Day
4. Accident Time
5. Accident Type level 2 Category
6. Accident Type Level 2 Desc
7. Accident Weekday
8. Body Parts Injured
9. Cause
10. Injured When Working Overtime
11. Injured While Performing Official Work Duties
12. Major Industry (SSIC 2010)
13. Major Injury Indicator
14. Months worked
15. Nature of Injury
16. Occupation
17. Pct Manual Work
18. Sub Industry (SSIC 2010)
19. Supposed Start Work Timing on Day Injured
20. Victim's Age (Reported Yr - Birth Yr)
21. Victim's Employment Start Date
22. Victim's Gender

Data Preparation

1. Remove unnecessary data attributes
2. Check through missing data patterns

There is a total of 33 rows that have some missing data. The data attributes that have missing data are Supposed Start Work Timing on Day Injured, Victim's Employment Start Date and Months Worked. As the missing data is relatively small, I had chosen to ignore them.

3. Transform text formats

There is a total of 33 rows that have some missing data. The data attributes that have missing data are Supposed Start Work Timing on Day Injured, Victim's Employment Start Date and Months Worked. As the missing data is relatively small, I had chosen to ignore them.

4. Remove unnecessary words

5. Recode occupation attribute

6. Transform time formats

7. Setting up Hierarchy