ANLY482 AY2017-18 T1 Group03/ProjectSteadfast Scope
| Home | About Us | Project Overview | Midterm Progress | Final Progress | Project Management | Documentation |
In the validation of the current work done by the previous team, we would need to break down their findings into relationship pairs that they have examined, and from there derive any missing relationships between sales and various key resources that the client invests. This serves also as a primary sensitivity test, allowing us to better focus analytical efforts into areas which appear to have greater sensitivity.
The steps in detail are as follow:
Problem Definition: To sit down with client and to discuss about business problems that need to be solved.
Data Exploration: To summarize the main characteristics of a dataset.
Data Preparation: To collect, prepare, clean and integrate data into a suitable form for further analysis and processing.
Model Selection: To come up with models based on the type of business problems that we are dealing with.
Model Validation: To verify sensitivity analyses against resource-to-sales relationships as proposed in our model.
Model Development: To build the most suitable model after validation is done and to test it against data we have on hand.
Communication of Results: To use information displays such as tables and charts to help communicate key messages contained in the data to the client.
As agreed with our supervisor, our team has decided to divide the scope of work accordingly:
Analysis of Invoice Detail Report:
- Analyze sales trend over the years. Look for sales pattern and analyze data to understand what drives the sales trend.
- Understand which channel contributes most to the company’s sales. Analyze the channels individually to find out what products in what therapy areas are they more likely to buy.
- Find out what are the products that contributes the most to the company’s sales. Focus on these products in the later part of the analysis.
Analysis of Customer Interactions:
- Analyze customer interaction trends in terms of number of records and total duration of interactions.
- Analyze which products are designated with the longest duration of interactions.
Analysis of Sensitivity of Sales to Customer Interactions:
- Compare total sales amount and duration of interactions and look for correlation.
- Analyze sensitivity of sales according to different channels, therapy areas, as well as products.
