ANLY482 AY2016-17 T2 Group10 Analysis & Findings
Data Preparation
Exploratory Data Analysis is the approach to understand main characteristics of datasets through use of graphical techniques such as bar chart, histogram, and scatterplot. Our main responsibility for EDA lies in determining relationships among explanatory and response variables, and in doing so, generate insights on ways to tackle aforementioned business problems.
MCCP
Invoice Details
Relationship between Sales, Price for different Channels
We want to identify any purchasing patterns on sales and price by different channels (GP, Hospital, Pharmacy). We will follow the assumption that sales per transaction is an estimator of demand.
Relationship between No. of Transactions and Channels by Products
We would like to determine purchasing pattern on frequencies of transactions based on different channels and products.
Integrated MCCP & Invoice
Relationship between No. of Interaction and Sales
We want to identify any purchasing patterns on sales and price by different channels (GP, Hospital, Pharmacy). We will follow the assumption that sales per transaction is an estimator of demand.
Relationship between No. of Transactions and Channels by Products
We intend to find out any relationship between number of interactions and sales aggregated by sales rep, customer, product, and quarter. This is governed by the understanding that the company segments each customer and product pair by past sales performance, and the better the grade would lead to more interactions. Hence, it is important to analyze whether more interactions would lead to more sales, and whether more interactions due to more sales are necessary. Also, we hope to find out an optimum minimal number of interactions for each product that will result in good sales performance.
