Difference between revisions of "IS428 2016-17 Term1 Assign3 Chua Feng Ru"
Line 58: | Line 58: | ||
| Facilities || The facilities personnel are the ones, whose job is to travel around the office. This is so as they can be seen around all 3 floors throughout the entire day. And it also seems that a minority of them need to stay overnight to accomplish their work. | | Facilities || The facilities personnel are the ones, whose job is to travel around the office. This is so as they can be seen around all 3 floors throughout the entire day. And it also seems that a minority of them need to stay overnight to accomplish their work. | ||
|- | |- | ||
− | | | + | | HR || |
− | |} | + | |- |
+ | | IT || The IT Department are the most punctual, as by 8 AM they are observed to be in Floor 2 and 3 in the office areas. They are also like the engineer department, where they knock off the latest. } | ||
* Employee Movements By Mobile Proximity Sensor | * Employee Movements By Mobile Proximity Sensor |
Revision as of 06:55, 24 October 2016
Contents
Problem & Motivation
While the new office is built to the highest energy efficiency standard, the problem is that there are still several HVAC issues to work out. And thus, the motivation is to use visual analytics to find out what are the most probable issues within the new building.
Data Cleaning and Transformation
Building Data
As for the initial building data, the data is structured such that each record or row has multiple columns as the data elements. The first step is to use JMP Pro to structure the data in the format of (Date/Time, Floor, Zone, Building Data Attribute, Value).
The process in transforming the data, is to first use the "Stack" feature of JMP Pro. This will allow me to format the data as below:
However, I realised that certain fields still contain Floor and Zone information. Thus, I used a series of formulas to separate the Floor and Zone information from the label. The following are the formulas which are used to accomplish the data cleaning process.
Hazium Concentration Data
For the Hazium Concentration Data, I realised that there are the files are splitted according to the sensors in each zone or floor. The first thing to do is to join the files together into 1 single table, with JMP Pro's "Concatenate" table function.
After that is done, I will have multiple columns of Hazium readings, I perform similar function of using the "Stack" feature to restructure the data. And formulas is also used to split the get the relevant zones and floor information. And the end product is as of below:
Employee Data
For the employee data, there is a need to generate the proximity id without the numeric number (e.g., Mat Bramar -> mbramar). JMP formula is used to achieve this:
Fixed Proximity Data
For the fixed proximity data, there will be a need to create an Emp ID field, to facilitate linking of employee data and fixed proximity data. JMP is also used to achieve this:
Data Findings and Analysis
Q1: Typical Day for GasTech Employees
- Employee Movements By Fixed Proximity Sensor
Generally, all GasTech employees will report to the office at around 7 AM, and next at around 12 PM they will go for an hour lunch, and finally end work at around 5 PM.
Department | Behaviour | |||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Engineering | They are the ones who work the latest, as they have been detected by the sensors at 11 PM. | |||||||||||||||||||||||||||||||||||||||||||||||
Administration | The admins are the ones who follow the typical or general pattern, where they report to work at around 7 AM to 8 AM, lunch at around 12 PM and end work at around 5PM. | |||||||||||||||||||||||||||||||||||||||||||||||
Executive | The executives report for work as the same time as others, however in the morning from 9 AM to 11 AM, they can be seen around the all 3 floors. It seems that they are making their rounds. | |||||||||||||||||||||||||||||||||||||||||||||||
Facilities | The facilities personnel are the ones, whose job is to travel around the office. This is so as they can be seen around all 3 floors throughout the entire day. And it also seems that a minority of them need to stay overnight to accomplish their work. | |||||||||||||||||||||||||||||||||||||||||||||||
HR | ||||||||||||||||||||||||||||||||||||||||||||||||
IT | The IT Department are the most punctual, as by 8 AM they are observed to be in Floor 2 and 3 in the office areas. They are also like the engineer department, where they knock off the latest. }
The mobile proximity sensor typically collects data at only 9 AM and 2 PM. It seems that at around this timing, most employees detected are at the office areas in Floor 2 and 3. Q2: Interesting Pattern in Data
Q3: Anomalies in Data
Data VisualisationUploaded to E-learn, as Tableau Online Expired. Tools Used
Reference
Comments |