IS428 2016-17 Term1 Assign2 Chua Feng Ru

From Visual Analytics for Business Intelligence
Revision as of 00:53, 26 September 2016 by Fengru.chua.2013 (talk | contribs)
Jump to navigation Jump to search

Theme of Interest

The theme of interest for IDEAL assignment is to understand the accidents reported in the workplace of Singapore. It strives and aims to explore and analyse reported accidents in 3 general aspects:

  • Who/What is involved in these reported accidents?
  • When did the accident happened?
  • What is the relationship between variables?


Questions for Investigation

From the above questions, I am able to generate the specific questions:

  • What is the relationship between number of accidents reported and number of MC days, in terms of each major or sub-industry?
  • What is the relationship between number of accidents reported and number of MC days, in terms of the nature of injury?
  • At which hour of a day is the accidents reported the highest or lowest?
  • What are the patterns of accident reported for each hour in a day?
  • What contributes to the patterns of accident reported for each hour in a day?
  • What is the prevalence of the injuries in each sub-industry ?
  • Does working experience minimize the number of MC Days?
  • Does the size of company affect the number of MC Days?



Findings

Tools Utilized

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