ANLY482 AY2016-17 T2 Group 2 Project Overview Data Source

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.