ANLY482 AY2017-18 T1 Group03/Final Progress

Home

About Us

Project Overview

Midterm Progress

Final Progress

Project Management

Documentation

3.0 Methodology

3.1 Data Collection
There were 6 main files sent to us by client out of which 5 of them have been extensively used. For our research, we obtained a full year data of 2016 and 2017 data till August.

File Name (Edited for confidentiality)	Description	Number of Rows
Customer Interaction	Information on interaction details	~213,000(FTF) & ~421,000(PW)
Employee File	Information on employee teams	~2000
Customer (Organisations)	Information on healthcare organisations	~117,000
Customer (non-Organisation)	Information on healthcare professionals	~205,000
Invoice	Information on transactions	~9,000,000

---

3.2 Tools Used
Our research has extensively used SAS JMP Pro 13 for data cleaning and transformation and for confirmatory analysis because of its intuitive system and simplistic approach. During the initial period, there has been considerable usage of Tableau Software for exploratory data analysis because of its easy visualisations for understanding the data.

---

3.3 Data Cleaning & Transformation
3.3.1 Files Required for Cleaning & Transformation

File Name (Edited for confidentiality)	Description
Customer Interaction (Type A)	This file contains information about face-to-face interactions that the client has done with the customers. We have included information such as customer code and allocated duration (i.e to remove double counting of duration issue in the original file) in the file.
Customer Interaction (Type B)	This file contains information about phone web interactions that the client has done with the customers. We have included customer code in the file.
Clean Invoice (2015-2017)	This file contains information about sales invoices that occurred between 2015 to the latest month in 2017. We have previously cleaned and mapped in Therapy Area to the file.