IS428 2016-17 Term1 Assign2 Chua Shan Yong James

From Visual Analytics for Business Intelligence
Revision as of 01:19, 25 September 2016 by James.chua.2013 (talk | contribs)
Jump to navigation Jump to search

Abstract

Workplace injuries has always been a concern in Singapore as the fatalities and accident rates number are worrying. Safety protocols have been in placed and perhaps adhered to but injuries are still unavoidable. This topic has therefore caught my interest to work on as i hope to find out trends in specific industries, age, body parts injured etc and the relationship between them.

Theme of Interest

The theme of interest for workplace injuries that i will be working on is identifying and analysing the contributing factors to workplace injuries and the relationship between each of these factors.

Questions for investigation

  1. Which industry has the highest rate of workplace injuries?
  2. Which are the body parts that got injured the most number of times?
  3. Which gender suffer more injuries?
    1. Is it justified in each industries?
  4. Are the older workers more careful than the younger workers? Or vice versa?
    1. For each industry, is the above finding justified?
  5. Does experience make a worker more slack and negligent about workplace safety (months worked)?

Identifying appropriate attributes

With reference to the theme of interest and questions for investigation that i have came up with, i needed the following attributes to carry out my analysis :

  1. Body parts injured
  2. Victim's gender
  3. Victim's age
  4. Months worked
  5. Sub industry
  6. Informant's number of employees

Transformations/Rearrangements of dataset

Visualization

Tools Utilized

  1. Excel 2013 for data preparation
  2. Tableau for visualization