Difference between revisions of "ANLY482 AY2017-18T2 Group32: Project Overview/Data"
Jump to navigation
Jump to search
Zycheng.2014 (talk | contribs) |
Zycheng.2014 (talk | contribs) |
||
(5 intermediate revisions by the same user not shown) | |||
Line 57: | Line 57: | ||
{| class="wikitable" style="text-align: center; background: white; margin: 0px auto; width:80%" | {| class="wikitable" style="text-align: center; background: white; margin: 0px auto; width:80%" | ||
! style="background: #fcb706; color: #262626 ; font-weight: bold;" | File/ Sheet Name | ! style="background: #fcb706; color: #262626 ; font-weight: bold;" | File/ Sheet Name | ||
+ | ! style="background: #fcb706; color: #262626 ; font-weight: bold; " | Description | ||
! style="background: #fcb706; color: #262626 ; font-weight: bold; " | Count | ! style="background: #fcb706; color: #262626 ; font-weight: bold; " | Count | ||
− | |||
|- | |- | ||
|'''HCP''' | |'''HCP''' | ||
− | |||
|Information on individual doctors | |Information on individual doctors | ||
+ | |7553 | ||
|- | |- | ||
|'''HCO''' | |'''HCO''' | ||
− | |||
|Information on clinics, organizations | |Information on clinics, organizations | ||
+ | |4919 | ||
|- | |- | ||
|'''Invoice Detail''' | |'''Invoice Detail''' | ||
− | | | + | |Transactions of product purchases by Target Audience |
− | | | + | |337518 |
|- | |- | ||
|'''TCE Account List/ TCE Brands only GP_SP''' | |'''TCE Account List/ TCE Brands only GP_SP''' | ||
− | | | + | |Annual sales for TCE brands over all accounts |
− | | | + | |2361 |
|- | |- | ||
|'''TCE Brands''' | |'''TCE Brands''' | ||
− | | | + | |Brands amongst the entire list of drugs that falls under the TCE category |
− | | | + | |86 |
|- | |- | ||
+ | |||
|} | |} | ||
<br> | <br> | ||
− | + | ==== Initial Exploratory Data Analysis ==== | |
+ | For Invoice, filter with the TCE brands. Here is a distribution of all the TCE brands and its sales performance. | ||
+ | [[File:Data 1.png | 600px | center]] | ||
+ | [[File:Data 2.png | 600px | center]] | ||
</div> | </div> | ||
<br> | <br> |
Latest revision as of 23:12, 25 February 2018
Return to ANLY482 AY2017-18 Home Page
Description | Data | Methodology |
Metadata
With a clear understanding of what our sponsor had in mind, our team began data munging process. This includes: data cleaning, transformation, and integration to obtain a an integrated data table via JMP for further analysis.
For our project, the sponsor has provided us with five datasets - Invoice data, TCE Account List data, TCE Brands data, HCO and HCP data that stretched from the year 2015 to today.
File/ Sheet Name | Description | Count |
---|---|---|
HCP | Information on individual doctors | 7553 |
HCO | Information on clinics, organizations | 4919 |
Invoice Detail | Transactions of product purchases by Target Audience | 337518 |
TCE Account List/ TCE Brands only GP_SP | Annual sales for TCE brands over all accounts | 2361 |
TCE Brands | Brands amongst the entire list of drugs that falls under the TCE category | 86 |
Initial Exploratory Data Analysis
For Invoice, filter with the TCE brands. Here is a distribution of all the TCE brands and its sales performance.