Red Dot Payment INITIAL DATA EXPLORATION AND ANALYSIS
Revision as of 14:11, 15 April 2018 by Ruizhi.ong.2014 (talk | contribs) (Created page with "<!------- Navigation Bar----> {|style="background-color:#CFCFCF; color: #000066; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | |...")
| Initial Data Exploration and Analysis | Deeper Data Exploration and Analysis |
|
|---|
Using JMP Graph Builder, we plotted the total number of transactions against months of 2016-2017 (e.g. January 2016 coded as period ‘1’, January 2017 coded as period ‘13’)
From Figure 5, we discovered a sharp increase in number of approved transactions processed during the from January to October 2016. After that, there was an overall decrease in number of approved transactions, with sudden dips in November to December 2016, and April to May 2017. Additionally, the number of rejected transactions has been increasing towards the end of 2017. This signals potential issues, and exploratory analysis was conducted to assess performance of merchants contributing to the less optimistic trends towards end of 2017.
Figure 5: Time-based pattern for each type of transaction across 24 months
