IS428 AY2019-20T2 Assign NG JUN HONG

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
SMU Libraries Survey

Background

Objectives

Information Gathering

Data Preparation

Employee List & Fixed/Mobile Proximity Data

600px


Screenshot
Steps Taken
400px
400px
400px


Interactive Visualization

The interactive visualization can be accessed here:https://public.tableau.com/profile/lim.kim.yong#!/vizhome/VA_Assignment3_Final6/Home_Page

The resolution of the visualization is custom set at the size of 1280 x 700 for a better user experience.Throughout all the different dashboards, useful tips/sharings will be provided to assists users in navigating through the different filters and actions so that their analysis can be performed smoothly.

Home Dashboard

A homepage is created with 6 different data categories in mind - Home, Employee Activity, HVAC System, Power Consumption, Exhaust Fan and Chemical. Each of these categories are further broken down into its respective sub-categories for the ease of users to perform their analysis. As such, users can select any categories that they are interested in to conduct their investigations.

The following shows the home dashboard:

800px

Employee Activity

The following shows the employee movement dashboard:

800px

Based on the given dataset, GAStech has 7 departments: Administration, Engineering, Executive, Facilities, HR, Information Technology, and lastly Security. I have decided to use tableau to visualize how does a typical day look like for GAStech employees by the various departments.

To assist with my exploration, I decided to use “Sort”, “Filter” and “Pages” to show the movements of employees from all the different departments throughout a typical day. Below are some of the screenshots that I got after using “Filter”, “Sort” and “Pages” functions.

The “Pages” shelf creates a set of pages, with a different view on each page. For e.g. the view below shows the movements of all employees from various departments and floor for each hour throughout the entire 2 weeks (31st of May to 13th of June).

Q1)Typical Patterns In Proximity Card Data & Typical Day Of GAStech Employees

The following shows the typical routine for GAStech employees in a specific department in general:

Department Activities
Administration
  1. Administration employees start entering into the building between 7am to 9am. They will report to their office either at floor 2 or floor 3.
  2. Between 11am to 1pm, Administration employees will take the elevators/stairs to floor 1 and go for their lunch break till around 2pm.
  3. At 3pm, all Administration employees were not being detected by any sensors. I have speculated that they might had gone out for a tea break session.
  4. Lastly, between 5-6pm, Administration employees would have started leaving the building.
Executive
  1. Executive employees start entering into the building between 7am to 9am.
  2. At 9am, movements of the executive employees are mostly detected at floor 3. This might be due to their offices located at floor 3.
  3. Between 11am to 1pm, executive employees will take the elevators/stairs to floor 1 and start leaving for their lunch break. At around 12pm, movements of CEO Sten Sanjorge Jr. around the building was noticed and at around 2pm everyone will be back from lunch.
  4. At 3pm and 4pm, none of the executive employees are being detected by any sensors in all floors. I speculate that they might have gone out for outside meeting or tea break session.
  5. Lastly, by 6pm, all the executive employees would have already left the building and they are often the last department to be seen at floor 3 other than the Facilities department.
Engineering
  1. Engineering employees start entering into the building between 7am to 9am.
  2. At 9am, movements of the Engineering employees are mostly detected at floor 2. This might be due to their offices located at floor 2.
  3. Between 11am to 1pm, Engineering employees will take the elevators/stairs to floor 1 and go for their lunch break till around 2pm.
  4. Most Engineering employees will leave at around 5 or 6pm. However, Employee Clemencia, Penney, and Twana were often seen as the last few employees to leave the building at around 11pm.
Facilities
  1. Facilities employees in this department are the only ones performing a 24hour shift work duties except for the weekends.
  2. For instance, Employee Varro and Employee Emile were often detected at Floor 1 during the night time starting at 12am. Also, at 2am, they will always be detected at Floor 1_Zone 6_Conf office_1030. And at 5am, only Varro will be detected at Floor 1_Zone 6_Conf office_1030.
  3. At around 9am, some employees from the facilities department will proceed to deli.
  4. Between 11am to 1pm, Facilities Employees will take the elevators/stairs to floor 1 and go for their lunch break till around 2pm.
Human Resource (HR)
  1. HR Employees start entering into the building between 7am to 9am.
  2. At 9am, movements of the HR employees are mostly detected at floor 3. This might be due to their offices located at floor 3.
  3. Between 11am to 1pm, HR employees will take the elevators/stairs to floor 1 and go for their lunch break till around 2pm.
  4. At 3pm-4pm, HR employees are not detected by any sensors in all floors. I speculate that they might have gone out for a tea break session.
  5. Lastly, at around 5pm, HR employees will start leaving the building.
Information Technology
  1. IT Employees start entering into the building between 7am to 9am.
  2. At 9am, movements of the IT employees are mostly detected at floor 2. This might be due to their offices located at floor 2.
  3. Between 11am to 1pm, IT employees will take the elevators/stairs to floor 1 and go for their lunch break till around 2pm.
  4. At 9am and 2pm, Some of the IT employees like Sven, Celestina are often detected at Floor 3 to provide IT support.
  5. At 4pm, IT employees were often seen gathering at floor 2_zone 4_Mech/Elev. Maybe they are going for their tea break.
  6. There are some IT employees who often stay till 11pm daily.
Security
  1. Security employees start entering into the building between 7am to 9am.
  2. Employee Stenig and Varja are mostly detected in Floor 1, Zone 7 Office 1010 and Zone 8 Office 1020 respectively. Additionally, only Employee Felix is detected on Floor 3 as his office is located in that floor.
  3. Between 11am to 1pm, IT employees will take the elevators/stairs to floor 1 and go for their lunch break till around 2pm.
  4. Lastly, at around 5pm, Security employees will start leaving their offices/the building.

Based on the information gathered above, the typical day for GAStech employees, in all departments:

  1. Employees start entering into the building at 7am. By 9am, majority of the employees would have already reached their compartment/office.
  2. Lunch break is usually in between 12pm to 2pm.
  3. By 2pm, most of the employees will be back as observed by the large amount of movements/activities occurring during that period in all level of floors.
  4. Employees typically ends work at around 5-6pm.
  5. After 6pm, most of the departments would have left except employees from the Facilities,Engineering and IT department.
  6. After 7pm, employees working in level 3, mainly executives, would have left the office.
  7. At 12am, most of the employees would have left the building except for Facilities department who are on 24-hour rotational shift.
  8. It is always the same people in facilities department that perform the night shift(Employee Stenig and Varja are found in Floor 1 as their offices are located in that floor).
  9. Most GAStech employees do not work during the weekends. However, a few of the employees from the administration department came back during the weekends and work from 8am onwards till latest 3pm.
  10. Some Employees from the Engineering & IT departments often stay till 11pm-12am.


HVAC Control System Dashboard - Heating

When creating the dashboard, Heating, Ventilation and Air-Conditioning comes to my mind to segregate them into three different dashboards rather than putting everything onto one dashboard. The following shows the HVAC(Heating) dashboard:

800px

The visualizations created are based on these attributes and their units:

  • Water Heater Tank Temperature (C): Temperate of the water inside the hot water heater(Tank)
  • Water Heater Setpoint: Temperature you have set to maintain.
  • Supply Side Inlet Temperature (C): Temperature of water entering the hot water heater.
  • Supply Side Outlet Temperature (C): Temperature of the water exiting the hot water heater
  • Pump Power (W): Power used by the hot water system pump.
  • Water Heater Gas Rate (W): Rate at which the water heater burns natural gas
  • Supply Side Inlet Mass Flow Rate (kg/s): Flow rate of water entering the hot water heater.
  • Loop Temp Schedule: Temperature set point of the hot water loop. This is the temperature at which hot water is delivered to hot water appliances and fixtures

HVAC Control System Dashboard - Ventilation

The following shows the HVAC(Ventilation) dashboard:

800px

The visualizations created are based on these attributes and their units:

  • Supply Fan: Fan power (W) - Power used by the HVAC System Fan
  • Supply Fan Outlet Temperature (C) - Temperature of the air exiting the HVAC System fan
  • Supply Fan Outlet Mass Flow Rate (kg/s) - Total flow rate of air delivered by the HVAC system fan to the zones it serves
  • Air Loop Inlet Temperature(C) - Mixed Temperature of air returning to the HVAC system from all zones it serves
  • Air Loop Inlet Temperature(C) - Mixed Temperature of air returning to the HVAC system from all zones it serves
  • Air Loop Inlet MFR (kg/s) - Total flow of air returning to the HVAC system from all zones it serves
  • Drybulb temperature (C) - Drybulb temperature of the outside air
  • Outdoor Air Mass Flow Rate (kg/s) - Flow rate of outside air entering the HVAC System
  • Outdoor Air Flow Fraction - % of total air delivered by the HVAC system that is from the outside
  • Cooling Coil Power(W) - Power used by the HVAC System cooling coil
  • Heating Coil Power(W) - Power used by the HVAC System heating coil


HVAC Control System Dashboard - Air Conditioning

The following shows the HVAC(Air Conditioning) dashboard:

800px

The visualizations created are based on these attributes and their units:

  • Night Cycle Control Status: ON/OFF status of the HVAC system during periods when system is normally scheduled off.
  • Thermostat Cooling Setpoint (C): Cooling set point schedule for the zone
  • Thermonstat Heating Setpoint(C): Heating set point schedule for the zone
  • Thermostat Temp (C): Temperature of the air inside the zone
  • Supply Inlet Temp(C): Temperature of the air entering the zone from its air supply box
  • Supply Inlet Mass Flow Rate(kg/s): Flow rate of the air entering the zone from its air supply box.
  • Reheat Damper Position: Position of the zone's air supply box damper. 1 corresponds to fully open, 0 corresponds to fully closed.
  • Reheat Coil Power (W): Power used by the Zone air supply box reheat coil.

Power Consumption Dashboard

The following shows the Power Consumption dashboard:

800px

Exhaust Fan Dashboard

The following shows the Exhaust Fan dashboard:

800px

Chemical Dashboard

The following shows the Exhaust Fan dashboard:

800px

Now that we have created all the necessary dashboard, we are ready to use it as a platform to conduct our exploration and analysis.

Patterns & Anomalies

Interesting patterns that appear in the building data and describe what is notable about the pattern

S/N Interesting Pattern Significance
1
 On floor 1 and 2, the bathroom exhaust fan is turn on continuously throughout the whole day. However, on floor 3, the bathroom exhaust fan power is only consuming power between 7am to 10pm. Through this pattern, we can see that floor 1 & floor 2 does not comply with the energy efficiency standards. Knowing that energy are non-renewable resources and will eventually run out. Adopting best practices to conserve energy not only helps to conserve resources but also translates into cost savings.
2
 In general, most energy usages were consumed within the corridor areas throughout all floors. This is exceptionally bad for the company as the corridor spaces do not contribute greatly to employee's productive or efficiency. Furthermore, not only does it contributes to energy wastages, it causes the company to incur unnecessary costs. Therefore, management should come out with policies to curb such issue.
3
 The server room at Floor 3, Zone 9 has been constantly using a huge amount of energy. It is not surprising that server room usually consumed the largest amount of equipment power.Management should know such situation and make necessary energy efficiency measures so that resources would be deployed properly.


Reference

Below are some works I personally admire and learning from it.

Retrieved from ‘https://wiki.smu.edu.sg/1920t2is428/index.php?title=IS428_AY2019-20T2_Assign_NG_JUN_HONG&oldid=1453’