Difference between revisions of "IS428 2016-17 Term1 Assign2 Dina Heng Li Gwek"
(→Blog) |
|||
(6 intermediate revisions by the same user not shown) | |||
Line 35: | Line 35: | ||
==Blog== | ==Blog== | ||
+ | Data Transformation, Preparation & Cleaning <br> | ||
To get things started, I examined and analysed the raw data ("WPI_data") to understand the dataset and attributes given to me. I also noticed that some data are either improper or irrelevant. For example, there were some spelling mistakes. As a data analyst, I needed to ensure that I have done proper data cleaning before doing analytics so that my analysis is true and accurate. I used Microsoft Excel 2016 and JMP to clean and transform my data. Then, I used Tableau to do my visualization.<br> | To get things started, I examined and analysed the raw data ("WPI_data") to understand the dataset and attributes given to me. I also noticed that some data are either improper or irrelevant. For example, there were some spelling mistakes. As a data analyst, I needed to ensure that I have done proper data cleaning before doing analytics so that my analysis is true and accurate. I used Microsoft Excel 2016 and JMP to clean and transform my data. Then, I used Tableau to do my visualization.<br> | ||
− | + | 1. Industry with the Highest Rate of Injuries <br> | |
+ | I created a new attribute called "% of Injured Employees" by taking the sum of records divided by the total number of workers of the informants. <br> | ||
− | I used a treemap | + | I used a treemap as it allows the user to have a bird's eye view of the injury rates of the different industries. <br> |
[[File:Dina_MA2_Injured Employees.png|600px|Visualization 3]] | [[File:Dina_MA2_Injured Employees.png|600px|Visualization 3]] | ||
− | 2. | + | 2. MC given to Minor and Major Injuries <br> |
You can see that for major injuries, blindness was given the most number of MC, followed by amputations then multiple injuries. However, my findings is that not enough MC days have been given to amputations and multiple injuries. | You can see that for major injuries, blindness was given the most number of MC, followed by amputations then multiple injuries. However, my findings is that not enough MC days have been given to amputations and multiple injuries. | ||
Line 54: | Line 56: | ||
[[File:Overall_Pattern_of_Accidents_in_a_Year.png|600px|Visualization 3]] | [[File:Overall_Pattern_of_Accidents_in_a_Year.png|600px|Visualization 3]] | ||
− | 4. Victim Demographic | + | 4. Victim Demographic <br> |
+ | |||
+ | Males tend to get injured more often than females. Statistics have shown that males predominantly work in the labor intensive e.g. construction industry.<br> | ||
[[File:Victim_Demographic.png|600px|Visualization 3]] | [[File:Victim_Demographic.png|600px|Visualization 3]] | ||
Line 67: | Line 71: | ||
[[File:Type_of_Injuries_by_Industry.png|600px|Visualization 3]] | [[File:Type_of_Injuries_by_Industry.png|600px|Visualization 3]] | ||
− | 7. | + | 7. Number of Accidents of Different Major Industry |
− | [[File: | + | [[File:No_of_Accidents_of_Different_Major_Industry.png|600px|Visualization 3]] |
− | 8. | + | 8. Accident Rate of Different Sub Industry.png |
[[File:Accident_Rate_of_Different_Sub-Industry.png|600px|Visualization 3]] | [[File:Accident_Rate_of_Different_Sub-Industry.png|600px|Visualization 3]] | ||
Line 80: | Line 84: | ||
==Findings & Recommendations== | ==Findings & Recommendations== | ||
+ | 1. Adults got injured the most. <br> | ||
+ | 2. Construction has the highest rate of workplace injuries. Perhaps more precaution and safety measures should be put in place for this industry. After all, it is one of the most dangerous industries. <br> | ||
+ | 3. Hand and lower leg ankle foot got injured the most. After all, we use our hands to do work and since our lower leg ankle foot tends to be exposed more often so employers should consider imposing covered shoes or insure those body parts more.<br> | ||
+ | 4. Males suffered more injuries as compared to the females especially in the construction industry.<br> | ||
==Visualization== | ==Visualization== |
Latest revision as of 02:11, 26 September 2016
Contents
Abstract
Twenty-two workers have died from workplace accidents since the start of 2016, more than the 18 from the same period last year, the Workplace Safety and Health (WSH) Council said on Monday (Apr 4). It is urging relevant industries to review their safety procedures at work immediately and to ensure that all control measures are in place.
Manpower Minister Lim Swee Say, noting that in the first half of 2016, there have already been 42 fatalities - 12 more compared to the same period last year. Mr Lim added that the construction sector remains the top contributor with 18 fatalities - an 80 per cent increase from last year, which saw 10 fatalities in the sector.
This issue has sparked my curiosity as I want to find out more about the trends occurring in specific industries, the key figures in workplace injuries, top sectors with workers injured, top causes of injuries etc.
Theme of Interest
Questions for Investigation:
• Which industry has the highest rate of workplace injuries?
• Which body parts got injured most of the time?
• Which gender suffered more injuries and particularly in which industry?
• Who is more prone to injuries? Is it the younger or older ones?
• How did they get injured?
• Who gets injured most of the time?
• When do accidents occur the most? (Which month and why? Does it occur more frequently during overtime?)
• What is the distribution of the number of MC given to injured employees?
Identifying appropriate attributes
The following data attributes are selected for analysis:
- Reported Date
- Reported Month
- Informant's No Of Employees
- Accident Month
- Major Industry
- Sub Industry
- Body Parts Injured
- Nature of Injury
- Major Injury Indicator
- Accident Type Category
- Victim's Age
- Cause
- Victim's Gender
Blog
Data Transformation, Preparation & Cleaning
To get things started, I examined and analysed the raw data ("WPI_data") to understand the dataset and attributes given to me. I also noticed that some data are either improper or irrelevant. For example, there were some spelling mistakes. As a data analyst, I needed to ensure that I have done proper data cleaning before doing analytics so that my analysis is true and accurate. I used Microsoft Excel 2016 and JMP to clean and transform my data. Then, I used Tableau to do my visualization.
1. Industry with the Highest Rate of Injuries
I created a new attribute called "% of Injured Employees" by taking the sum of records divided by the total number of workers of the informants.
I used a treemap as it allows the user to have a bird's eye view of the injury rates of the different industries.
2. MC given to Minor and Major Injuries
You can see that for major injuries, blindness was given the most number of MC, followed by amputations then multiple injuries. However, my findings is that not enough MC days have been given to amputations and multiple injuries.
3. Overall Pattern of Accidents in a Year
You can see that for the months of January and February, not a lot of accidents have occurred. The peak was during March, April and September. I reckon that especially at those months, perhaps precaution has been lax or either there are more construction happening during those months.
4. Victim Demographic
Males tend to get injured more often than females. Statistics have shown that males predominantly work in the labor intensive e.g. construction industry.
5. Pattern of Accidents in a Year by Industry
6. Type of Injuries by Industry
7. Number of Accidents of Different Major Industry
8. Accident Rate of Different Sub Industry.png
9. No of Reported Cases Per Month By Sub Industry
Findings & Recommendations
1. Adults got injured the most.
2. Construction has the highest rate of workplace injuries. Perhaps more precaution and safety measures should be put in place for this industry. After all, it is one of the most dangerous industries.
3. Hand and lower leg ankle foot got injured the most. After all, we use our hands to do work and since our lower leg ankle foot tends to be exposed more often so employers should consider imposing covered shoes or insure those body parts more.
4. Males suffered more injuries as compared to the females especially in the construction industry.
Visualization
https://public.tableau.com/views/VAAssignment2DinaHengLiGwek/Dashboard3?:embed=y&:display_count=yes
Tools Utilized
- Excel 2013 for data preparation
- Tableau for visualization