Difference between revisions of "ANLY482 AY2016-17 T2 Group19 Data"

From Analytics Practicum
Jump to navigation Jump to search
Line 55: Line 55:
 
*Sales data from Pharmaceutical Wholesale Distributions
 
*Sales data from Pharmaceutical Wholesale Distributions
 
*Itemised transactions occurring in the years 2014 to 2016
 
*Itemised transactions occurring in the years 2014 to 2016
 +
*3 main customer types namely General Practitioners, Specialists and Branded Chain Pharmacies
 
</div>
 
</div>
  

Revision as of 23:25, 23 April 2017



Protegelogo-01.svg

Protege overview.svg   OVERVIEW

Protege data.svg   DATA

Protege Methods.svg   METHODOLOGY & ANALYSIS

Protegemaster-03.svg   FINDINGS

Protege poster.svg   DOCUMENTATION

  BACK TO COURSE


Data

Background

In the pharmaceutical industry, it has historically been a challenge to manage hundreds of hospitals and clinics with sizeable differences in the types of drugs, disposable items and the sheer volume in respective purchase orders

While not exclusive to this industry alone, managerial decision making processes have historically relied heavily on transactional raw data and managerial experience

The data set that was used contains sales data from a medium-sized pharmaceutical company with customer base ranging from over the counter pharmacies to clinics around Singapore.


Data Description & Acknowledgement

The raw data was collected from Company Z on the 12th of January 2016 and is described as follows:

  • Sales data from Pharmaceutical Wholesale Distributions
  • Itemised transactions occurring in the years 2014 to 2016
  • 3 main customer types namely General Practitioners, Specialists and Branded Chain Pharmacies

Data Cleaning and Preparation

-insert variable that has been cleaned-
-discuss the treatment and why the treatment-