ANLY482 AY2016-17 T2 Group23 Silver Daisies Analysis and Findings

From Analytics Practicum
Revision as of 23:21, 25 February 2018 by Hin.tham.2014 (talk | contribs)
Jump to navigation Jump to search
THKMC.png

HOME

PROJECT OVERVIEW

ANALYSIS & FINDINGS

PROJECT MANAGEMENT

DOCUMENTATION

MAIN PAGE

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.

Manpower Ratio Analysis

Geo-spatial Analysis

Client Cluster Analysis

Time-series Analysis