ANLY482 AY2016-17 T2 Group23 Silver Daisies Analysis and Findings
Contents
Data Quality
Data given are in two ways. The daily operation schedule data is excel or hard copies format, which 1 day represent 1 sheet, structured in a form of tables rather than a database structure. The vehicle data are automatically collected in their system in a summary format. Therefore to get daily data will require manual selection of dates and manually extract them.
There are discrepancies between the drivers' driving hours time log and the vehicle's moving duration as drivers change their vehicles occasionally. Also, because there is a lack of variables that directly reflect the driving cost such as the amount of fuel consumed. In the daily operations scheduling data, some of the vehicle numbers are missing, therefore unable to identify the vehicle used. Many of the writings for driver names and purpose of appointment are also very inconsistent and ambiguous. There are missing data in February because of file corruption which has been deleted. There are also missing data in vehicle data of 1 vehicle because of 2 months late installation of their new tracking system.