IS428 2016-17 Term1 Assign3 Chen Huiyan

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search

Data Source

Data Analysis

Proximity sensor data for each of the prox zone regions is used to discover the typical working patterns for GAStech employees. In order to identify the pattern, I need find the relationship between prox-id and employees. Through some observations, I have spotted prox-id is constructed by the first character of employee's first name and full last name followed by numbers which start from 001. For example, one employee called Mat Bramar with prox-id "mbramar001". In addition, the same employee may have multiple prox-ids with increasing numbers such as 002.


Data Transformation

For proxOut-MC2.csv, I have extracted employee's last name to identify the unique employee from prox-id by using the Left and Right functions in Excel. ExtractName.JPG




The Tasks

  1. What are the typical patterns in the prox card data? What does a typical day look like for GAStech employees?



  1. Describe up to ten of the most interesting patterns that appear in the building data. Describe what is notable about the pattern and explain its possible significance.


  1. Describe up to ten notable anomalies or unusual events you see in the data. Prioritize those issues that are most likely to represent a danger or a serious issue for building operations.



  1. Describe up to five observed relationships between the proximity card data and building data elements. If you find a causal relationship (for example, a building event or condition leading to personnel behavior changes or personnel activity leading to building operations changes), describe your discovered cause and effect, the evidence you found to support it, and your level of confidence in your assessment of the relationship.

Tools Utilized

Final Visualization

Comments and Suggestions