Difference between revisions of "AY1516 T2 Team13 Natasha Studio Findings Other"
(Created page with "<!--Header Start--> {|style="background-color:#ffffff; color:#ffff; padding: 5 0 5 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border-left= "1" solid #ffffff...") |
Amy.tan.2012 (talk | contribs) |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 24: | Line 24: | ||
{| style="background-color:#ffffff; margin: 3px auto 0 auto" width="55%" | {| style="background-color:#ffffff; margin: 3px auto 0 auto" width="55%" | ||
|- | |- | ||
| − | ! style="font-size:13px; text-align: center; font-family:Arial; border-top:solid #ffffff; border-bottom:solid # | + | ! style="font-size:13px; text-align: center; font-family:Arial; border-top:solid #ffffff; border-bottom:solid #ffffff" width="100px"| [[AY1516 T2 Team13 Natasha Studio_Findings| <span style="color:#000000">EXPLORATORY DATA ANALYSIS</span>]] |
! style="font-size:14px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"| | ! style="font-size:14px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"| | ||
| − | ! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid # | + | ! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #2e2e2e" width="100px"| [[AY1516 T2 Team13 Natasha Studio_Findings_Other| <span style="color:#000000">OTHER ANALYSIS</span>]] |
! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"| | ! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"| | ||
! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="100px"| [[AY1516 T2 Team13 Natasha Studio_Findings_Database| <span style="color:#000000">DATABASE CREATION</span>]] | ! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="100px"| [[AY1516 T2 Team13 Natasha Studio_Findings_Database| <span style="color:#000000">DATABASE CREATION</span>]] | ||
| + | ! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"| | ||
| + | |||
| + | ! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="100px"| [[AY1516 T2 Team13 Natasha Studio_Findings_RuleMining| <span style="color:#000000">ASSOCIATION RULE MINING</span>]] | ||
| + | ! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"| | ||
| + | |||
| + | ! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="100px"| [[AY1516 T2 Team13 Natasha Studio_Findings_LogReg| <span style="color:#000000">LOGISTIC REGRESSION</span>]] | ||
! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"| | ! style="font-size:13px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"| | ||
|} | |} | ||
| − | |||
<h2>Further Analysis of Revenue Generation in Relation to Dance Genre (Package)</h2> | <h2>Further Analysis of Revenue Generation in Relation to Dance Genre (Package)</h2> | ||
<p>Investigating further as to why 06 Weeks (Full-Course) has reduced in frequency yet being the 2rd highest revenue in 2014-2015 as compared to 2010-2012, we drilled down to the packages (genre) composition for these periods using the purchases data</p> | <p>Investigating further as to why 06 Weeks (Full-Course) has reduced in frequency yet being the 2rd highest revenue in 2014-2015 as compared to 2010-2012, we drilled down to the packages (genre) composition for these periods using the purchases data</p> | ||
| Line 42: | Line 47: | ||
<h2>Cross Tables</h2> | <h2>Cross Tables</h2> | ||
| − | Using Tableau, we also derived several cross-tables with members being a unique variables. Using the purchases data, we derived a cross-table between member and price packages. Using the attendance data, we derived two cross-tables – 1) members and genres 2) members and course/open & level. | + | Using Tableau, we also derived several cross-tables with members being a unique variables. Using the purchases data, we derived a cross-table between member and price packages. Using the attendance data, we derived two cross-tables – 1) members and genres 2) members and course/open & level. These cross tables were subsequently used in our utilization analysis (Logistic Regression). |
Latest revision as of 13:30, 17 April 2016
| EXPLORATORY DATA ANALYSIS | OTHER ANALYSIS | DATABASE CREATION | ASSOCIATION RULE MINING | LOGISTIC REGRESSION |
|---|
Further Analysis of Revenue Generation in Relation to Dance Genre (Package)
Investigating further as to why 06 Weeks (Full-Course) has reduced in frequency yet being the 2rd highest revenue in 2014-2015 as compared to 2010-2012, we drilled down to the packages (genre) composition for these periods using the purchases data
Thus, we see that in the 06 Weeks (Full Course), there has been an increase in number of Kids course as compared to previous years, namely Kpop (Kids) and Hiphop (Kids), Thus, this is likely why 06 Weeks Course is better revenue generating per package bought as Natasha Studio prices its Kids course higher than its other courses. Natasha should consider to continue such Kids course to increase revenue. The drop in frequency could be attributable to the fact that members preferred dance genre such like Hiphop and Street Jazz, which constitutes majority of the open classes as in Figure 23 below. While Hiphop is still popular as a course, members are likely to drawn more to unlimited and open class packages, which offers more flexibility to explore and develop their interest in the particular dance style.
Cross Tables
Using Tableau, we also derived several cross-tables with members being a unique variables. Using the purchases data, we derived a cross-table between member and price packages. Using the attendance data, we derived two cross-tables – 1) members and genres 2) members and course/open & level. These cross tables were subsequently used in our utilization analysis (Logistic Regression).
