Difference between revisions of "ANLY482 AY2016-17 T2 Group19 Data"
Line 56: | Line 56: | ||
*Itemised transactions occurring in the years 2014 to 2016 | *Itemised transactions occurring in the years 2014 to 2016 | ||
</div> | </div> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
=<div style="background: #4d4d4d; padding: 20px; line-height: 0.1em; text-indent: 10px; font-size:20px; font-family: Trajan Pro; border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff> Data Cleaning and Preparation </font></div>= | =<div style="background: #4d4d4d; padding: 20px; line-height: 0.1em; text-indent: 10px; font-size:20px; font-family: Trajan Pro; border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff> Data Cleaning and Preparation </font></div>= |
Revision as of 23:21, 23 April 2017
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
Data Cleaning and Preparation
-insert variable that has been cleaned-
-discuss the treatment and why the treatment-