ANLY482 AY2016-17 T2 Group 2 Findings

From Analytics Practicum
Revision as of 14:23, 20 February 2017 by Leejia.yong.2013 (talk | contribs)
Jump to navigation Jump to search


HOME

 

FINDINGS

 

PROJECT DOCUMENTATION

 

PROJECT MANAGEMENT

 

ABOUT US

 

ANLY482 HOMEPAGE

Findings Literature Review
General Sales

Total purchase frequency and sales
Kaikai-Graph1.png
We observed that the purchase frequency has increased from 1,110,633 in 2015 to 5,178,141 in 2016. This amounts to a staggering 366% increase in total bet frequency upon the launch of the online ticketing site.
Total ticketing sales on the other hand has increased from 32,120,249 to 56,032,709, which amounts to only an 75% increase. Comparing to the proportion increase in bet frequency, we identify that although customers are seen to be betting more frequently, it appears they are betting in smaller amounts instead.

Total sales by product
Kaikai-Graph2.png
Looking at the total sales of each product, we observed that sales have increased the most for concert tickets by $20,439,120. On the other hand, overseas musical sales have seen the least increase by only $510,053.

Percentage sales by product
Kaikai-Graph3.png
We then decide to take a closer look at the changes in the sales composition in each year. We notice that concert sales remains the highest composition and have increased by 3% from 78% in the previous year to 81% in the current year. Local musicals and overseas musicals on the other hand have decreased by 1% from 16% to 15% and 2% from 6% to 4% respectively.

Product shift for local musicals
Kaikai-Graph4.png
As we are interested to find out if there are changes in the ticketing behavior of customers between the three products, we decided to look into the product shift. As observed from the figure above, we have identified that an increase in local musical customers who are seen to be purchasing on all of the three products. In addition, we also observe a noticeable amount of customers who used to only purchase local musicals, purchasing on overseas musicals after the launch of the online ticketing site as well.

Product shift for overseas musicals
Kaikai-Graph5.png
Looking at the product shift for overseas musicals customers, we observe that there a significant proportion of customers who used to only purchase on overseas musicals, purchasing local musicals as well. In addition, it can be seen that there is an increase in overseas musicals customers who are betting on all the three products.

Product shift for concerts
Kaikai-Graph6.png
From the figure above, we detected that many of the customers who used to purchase on concerts only, have seen to be purchasing musical tickets as well. Moreover, we also find that many concert customers now are also customers for both local and overseas musicals.

Transaction Variables

Total purchase frequency and sales
Kaikai-Graph1.png
We observed that the purchase frequency has increased from 1,110,633 in 2015 to 5,178,141 in 2016. This amounts to a staggering 366% increase in total bet frequency upon the launch of the online ticketing site.
Total ticketing sales on the other hand has increased from 32,120,249 to 56,032,709, which amounts to only an 75% increase. Comparing to the proportion increase in bet frequency, we identify that although customers are seen to be betting more frequently, it appears they are betting in smaller amounts instead.