ANLY482 AY2017-18T2 Group32: Project Overview/Data

From Analytics Practicum
Jump to navigation Jump to search

Return to ANLY482 AY2017-18 Home Page

Pharma G Logo.png

Home

About Us

Project Overview

Project Insights

Project Management

Documentation

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.

Data 1.png
Data 2.png