Difference between revisions of "ANLY482 AY2016-17 T2 Group 2 Project Overview Data Source"

From Analytics Practicum
Jump to navigation Jump to search
Line 61: Line 61:
 
# Concerts_Name.xlsx (contains all concerts information for 2015)
 
# Concerts_Name.xlsx (contains all concerts information for 2015)
 
# data_cst.xlsx (contains information of registered customers of Kaiso Ticketing)
 
# data_cst.xlsx (contains information of registered customers of Kaiso Ticketing)
 +
 +
==<div style="background: #6A8D9D; line-height: 0.3em; font-family:helvetica;  border-left: #466675 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#F2F1EF"><strong>Musical data</strong></font></div></div>==
 +
<div style="margin:20px; padding: 10px; background: #ffffff; text-align:left; font-size: 95%;-webkit-border-radius: 15px;-webkit-box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96); -moz-box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96);box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96);">
 +
<p>Two datasets were provided for this, the first one is a year-long dataset and the second dataset is a two months long dataset. These datasets contains every instance of transaction data for customer purchases for that time period. These purchases were made via phone booking only, part of the remote purchasing services. Musical purchases can be in the form of local musicals or overseas musicals.
 +
</p>
 +
 +
{|class="wikitable" width="100%"
 +
|-
 +
! width="30%" | Data Field
 +
! Description
 +
 +
        |-
 +
        ! Account Number
 +
| The account number of the customer.
 +
       
 +
        |-
 +
        ! SoldDate
 +
| The date and time that the purchase was made
 +
 +
        |-
 +
        ! Product
 +
| Either Local or Overseas.
 +
 +
        |-
 +
        ! TicketAmount
 +
| The amount of the ticket that was purchased.
 +
 +
        |-
 +
        ! TicketType
 +
| The kind of ticket type. For example, "CAT1", "CAT2", "VIP BOX".
 +
 +
        |-
 +
        ! PerformanceDate
 +
| The date and time where the performance is held.
 +
|}
 +
</div>
  
 
</div>
 
</div>

Revision as of 20:26, 19 February 2017


HOME

 

FINDINGS

 

PROJECT DOCUMENTATION

 

PROJECT MANAGEMENT

 

ABOUT US

 

ANLY482 HOMEPAGE

Background Data Source Methodology

Data Source

To facilitate our analysis, Kaiso has provided us with datasets that consists of transaction data, concerts information data and customer demographics data.

  1. musical15.csv (contains musical transaction data made via phone booking from April 2015 till March 2016)
  2. musicalAug-Oct.csv (contains musical transaction data made via phone booking from August 2016 till October 2016)
  3. musicalrb.csv (contains musical transaction data made via phone and internet booking from 25 October 2016 till November 2016)
  4. concerts15.csv (contains concerts transaction data made via phone booking from April 2015 till March 2016)
  5. concertsAug-Oct.csv (contains concerts transaction data made via phone booking from August 2016 till October 2016)
  6. concertsrb.csv (contains concerts transaction data made via phone and internet booking from April 2015 till March 2016)
  7. Concerts_Master.csv (contains all concerts information for 2016)
  8. Concerts_Name.xlsx (contains all concerts information for 2015)
  9. data_cst.xlsx (contains information of registered customers of Kaiso Ticketing)

Musical data

Two datasets were provided for this, the first one is a year-long dataset and the second dataset is a two months long dataset. These datasets contains every instance of transaction data for customer purchases for that time period. These purchases were made via phone booking only, part of the remote purchasing services. Musical purchases can be in the form of local musicals or overseas musicals.

Data Field Description
Account Number The account number of the customer.
SoldDate The date and time that the purchase was made
Product Either Local or Overseas.
TicketAmount The amount of the ticket that was purchased.
TicketType The kind of ticket type. For example, "CAT1", "CAT2", "VIP BOX".
PerformanceDate The date and time where the performance is held.
Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY2016-17_T2_Group_2_Project_Overview_Data_Source&oldid=13410’