AY1516 T2 Team13 Natasha Studio Project Overview Data
| BACKGROUND | DATA | METHODOLOGY |
|---|
DATASET
For the purpose of this project, Natasha Studio has provided us with a set of softcopy data, which includes Purchase data and Attendance data. Purchase data includes the package purchase records of Natasha Studio’s members. Attendance data contain members’ attendance for each lesson and the member’s purchased package through the cost allocated to each member. These two datasets are expected to be the main focus of this project as they provide insights into Natasha Studio customers’ purchase behavior and their preference of dance genres, class types and packages.
Data Overview
Upon receiving the soft copy data, preliminary data analysis is performed on the overall dataset to provide an overview of variables present. The preliminary analysis reveals that there are 4 different types of datasets. They are linked to each other via the various lookup functions in Excel. They are as follows:
| Variable Name | Description |
|---|---|
| Name | Full Name of Participant |
| IC | NRIC of Participant (S or G) |
| Mobile Number | Contact Number of Participant |
| Date Started | Date started attending class at Natasha |
Natasha Studio has requested for us to remove the NRIC and contact number of members due to sensitivity of personal information. As such, these two columns are removed from our analysis and the member IDs will be used as the unique identifier of each member.
| Variable Name | Description |
|---|---|
| Date | Date of class |
| Type | Type of class (Class type, Instructor, Time) |
| Attendant | Participants attending the class |
| Cost | Price per participant (Linked to the packages bought) e.g. For Course Packages - $12.50, Unlimited - $4 etc. |
| Variable Name | Description |
|---|---|
| Date | Date of class |
| Time | Time of class |
| Faculty | Instructor for the class |
| Genre | Genre of class |
| Type | Course or Open class |
| Level | Beginner, Level I, Level II, Level III |
| Course No. | Internal Course No. |
| Venue | Studio One or Studio Two |
| Class size | Total class size |
| Trial Lesson | No. of participants on trial lesson |
| Unlimited | No. of participants on Unlimited packages (1 or 3 month) |
| Actual | No. of participants on a per class basis (Not unlimited) |
| Pay | Price that participants paid for class |
| Owe | Price that participants owe for class |
| Variable Name | Description |
|---|---|
| Date Purchased | Date of Purchase |
| Member ID | To extract member details from member list |
| FullName | Full Name of Participant |
| Status | Adult, student or NSF |
| Package | Type of dance (Hiphop, locking, popping, any) |
| Course/ Open & Level | Course or Open. If Course, level I or II or III |
| Comments | Specific type of package e.g. 01 Month Package |
| Amount | Amount paid |
| Date Start | Start Date of Package |
| Date End | End Date of Package |
| Mode of Payment | NETS, Cash or Bank Transfer |
As the project scope is limited to analyzing Natasha Studio’s dance genres, package and class type offered, the faculty data is irrelevant to the purpose of this project and will not be included in future analysis. Thus as mentioned above, the two datasets - Purchases and Attendance, will be the main focus of our analysis.
