Difference between revisions of "IS428 2016-17 Term1 Assign2 Wang Jingxuan"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 31: Line 31:
 
[[file:ConstructionInjury.png]]<br>
 
[[file:ConstructionInjury.png]]<br>
 
[[file:ConstructionWorker.png]]<br>
 
[[file:ConstructionWorker.png]]<br>
== interactive dashboard visualisation ==
+
== Interactive Dashboard Visualisation ==
 
The interactive dashboard visualisation can be found [https://public.tableau.com/profile/publish/WorkplaceInjuryAnalysis/Dashboard1#!/publish-confirm here]
 
The interactive dashboard visualisation can be found [https://public.tableau.com/profile/publish/WorkplaceInjuryAnalysis/Dashboard1#!/publish-confirm here]
  

Revision as of 01:13, 26 September 2016

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
Q2. Are there patterns of injury time
AccidentTime.png
Q3. Are there Patterns of injury types
Construction.png
ConstructionInjury.png
ConstructionWorker.png

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