Difference between revisions of "IS428 2016-17 Term1 Assign3 Lim Hui Ting"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 14: Line 14:
 
====3. Clean out proxid column====
 
====3. Clean out proxid column====
 
====4. Group timestamp to 15 minutes interval====
 
====4. Group timestamp to 15 minutes interval====
 +
====5. Join proximity sensor data with employee dataset====
  
 
===HVAC and Hazium Data===
 
===HVAC and Hazium Data===

Revision as of 01:25, 23 October 2016

Overview

In this assignment, we seek to help GAStech to understand its operations data by using two weeks of building and prox sensors data. The objectives of this assignment are as follows:

1. What are the typical patterns in the prox card data? What does a typical day look like for GAStech employees?
2. 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.
3. 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.
4. 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.

Data Preparation

Proximity Sensor Data

1. Create X and Y coordinates column for fixed-prox

2. Create zone column for mobile-prox

3. Clean out proxid column

4. Group timestamp to 15 minutes interval

5. Join proximity sensor data with employee dataset

HVAC and Hazium Data

1. Separate whole building data and zone specific data

2. Clean zone specific data columns

3. Stack zone specific data columns to a single column

4. Create floor and zone columns for zone specific dataset

1. Typical Patterns in the Prox Card Data

2. Interesting Patterns that Appear in the Building Data

3. Anomalies or Unusual Events Observed in the Data

4. Observed Relationships Between Proximity Card Data and Building Data Elements