IS428 2016-17 Term1 Assign3 Chua Feng Ru
Revision as of 23:50, 23 October 2016 by Fengru.chua.2013 (talk | contribs) (Created page with "==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...")
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.
Problem: There are several HVAC issues to work out. Motivation:
Data Cleaning and Transformation
Data Findings and Analysis
Q1: Typical Day for GasTech Employees
- Problem: In the employee list excel file given, I analysed the data and removed the index column. Since I felt that the numbers that denote the number of cards the employee has due to misplacement were not necessary, I removed them.
- Solution: Based on the Mobile Prox and Prox-out CSV files, the employee ID detected were in the format as follows: <first letter of the first name> + <last name> + <number of times replaced (i.e. 005 means replaced card 4 times)>. As such, I ensured that the employee list excel file, mobile prox and prox out CSV files had the identical employee ID meant for joining of tables in Tableau.
