IS428 AY2019-20T2 Assign DAVID CHOW JING SHAN
Contents
- 1 Background
- 2 Objectives
- 3 Information Gathering
- 3.1 Data preparation
- 3.2 Home Dashboard
- 3.3 Importance ranking
- 3.4 Level of services perceived by undergraduate,postgraduat,faculty and staff (Importance)
- 3.5 HVAC Control System Dashboard - Heating
- 3.6 HVAC Control System Dashboard - Ventilation
- 3.7 HVAC Control System Dashboard - Air Conditioning
- 3.8 Power Consumption Dashboard
- 3.9 Exhaust Fan Dashboard
- 3.10 Chemical Dashboard
- 3.11 Interesting patterns that appear in the building data and describe what is notable about the pattern
- 4 Reference
Background
Every two years, SUM libraries conduct a comprehensive survey to receive feedback from the faculty, students, and staff with regards to the libraries' services. With the data collected, SMU libraries hope to gain some insights so that they can enhance their existing services and meet the emerging needs of SMU faculty, students and staff.
However, the past reports were not able to give a comprehensive and condensed summary for SMU libraries as they are mainly made-up of pages of tables. With so much information, it becomes difficult for SMU libraries to get an essential overview that allows SMU libraries to gain useful insights.
Objectives
With such a massive amount of data being collected, it is important to summarize the key areas and provide proper visualizations for them. Hence, using all the visualization and analytical techniques that I have learned in class, I aim to create an interactive data visualization to help SMU libraries better understand their service feedbacks so that they can make improvements on their services to better satisfy the needs of their respective users.
With this interactive visualization, SMU libraries would be able to easily find out the feedbacks for their services that are used by their respective users:
- undergraduate students
- postgraduate students
- faculty
- staff
Information Gathering
With the given data(2018 Survey dataset), like any visualization processes, it is vital to understand and look through the data before using any visualization software. I will be using Tableau as my visualization software and there are some work to be done on the given datasets before I plot my visualizations.
Data preparation
The interactive visualization can be accessed here:
Home Dashboard
The following shows the home dashboard:
Importance ranking
The following shows the employee movement dashboard:
Level of services perceived by undergraduate,postgraduat,faculty and staff (Importance)
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:
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:
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:
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:
Exhaust Fan Dashboard
The following shows the Exhaust Fan dashboard:
Chemical Dashboard
The following shows the Exhaust Fan dashboard:
Now that we have created all the necessary dashboard, we are ready to use it as a platform to conduct our exploration and analysis.
Interesting patterns that appear in the building data and describe what is notable about the pattern
| S/N | Interesting Pattern | Significance |
|---|---|---|
| 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. | |
| 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. | |
| 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.
