ANLY482 AY2016-17 T2 Group10 Project Overview: Methodology
Tools Used
SAS JMP Pro 13 is chosen as our primary tool for data preparation, exploratory and further analysis. It is an analytical software that can perform most statistical analysis on large datasets and generate results with interactive visualizations used by data scientists to manipulate data selection on the go. Furthermore, tutorials and guides are widely available online for us to learn JMP Pro 13’s different techniques and functions. More importantly, its easy-to-use built-in tools enable us to conduct analysis of variance to determine relationship between interactions and sales revenue.
Data Preparation
Data preparation took us through time-consuming and tedious procedures to obtain high quality data. Though seemingly unrewarding, a set of high quality data allows for more accurate, reliable and consistent analysis of results. Therefore, it is imperative to invest a lot of time and effort on it to avoid getting false conclusions for our hypothesis.
image
The above diagram illustrates how data tables are being integrated, which took a few stages to achieve.
The first stage of data preparation involves cleaning Invoice Details and Call Details tables.
- For missing values under “price$” column in Invoice Details, we imputed their values to “0” as these rows contain records where free samples given out to customers.
- Steps Taken:
- Press Ctrl-F to show “search data tables” interface
- Enter the following fields:
- Find what: *
- Replace with 0
- Tick “Match entire cell value”
- Tick “Restrict to selected column” of “Price$”
- Tick “Search data”
- Click on “Replace All” to apply change
- Steps Taken:
MCCP
