Difference between revisions of "ANLY482 AY2017-18T2 Group32: Project Overview/Data"
Jump to navigation
Jump to search
Zycheng.2014 (talk | contribs) |
|||
(10 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | <div align="right"> | ||
+ | [[ANLY482_AY2017-18_Term_2|<font color="#dd672e" font-family:helvetica><b>Return to ANLY482 AY2017-18 Home Page</b></font>]] | ||
<center> | <center> | ||
− | [[File: | + | [[File:Pharma G Logo.png|300px]] |
</center> | </center> | ||
Line 8: | Line 10: | ||
| style="padding:0.2em; font-size:130%; background-color:#000000; text-align:center; " width="5%" | | | style="padding:0.2em; font-size:130%; background-color:#000000; text-align:center; " width="5%" | | ||
− | [[ANLY482_AY2017- | + | [[ANLY482_AY2017-18T2_Group_32| <font face ="Avenir Next" color="#ffffff" >Home</font>]] |
| style="background:none;" width="1%" | | | style="background:none;" width="1%" | | ||
Line 43: | Line 45: | ||
<div align="left"> | <div align="left"> | ||
− | <div style="background: #f6a228; padding: 12px; font-family: Avenir Next; font-size: 18px; font-weight: bold; line-height: 1em;"><font color="# | + | <div style="background: #f6a228; padding: 12px; font-family: Avenir Next; font-size: 18px; font-weight: bold; line-height: 1em;"><font color="#ffffff">Metadata </font> |
</div> | </div> | ||
<div style="background: #FFFFFF;border-style:solid; border-top:0px; border-width: 2px; border-color: #000000; padding: 1em; text-align: justify;"> | <div style="background: #FFFFFF;border-style:solid; border-top:0px; border-width: 2px; border-color: #000000; padding: 1em; text-align: justify;"> | ||
− | + | 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. | ||
+ | |||
+ | <br> | ||
{| 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;" | | + | ! style="background: #fcb706; color: #262626 ; font-weight: bold;" | File/ Sheet Name |
− | ! style="background: #fcb706; color: #262626 ; font-weight: bold; " | | + | ! style="background: #fcb706; color: #262626 ; font-weight: bold; " | Description |
+ | ! style="background: #fcb706; color: #262626 ; font-weight: bold; " | 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 |
− | |||
− | |||
|- | |- | ||
+ | |||
+ | |||
|} | |} | ||
<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.