Difference between revisions of "AY1516 T2 Team13 Natasha Studio Project Overview Data"

From Analytics Practicum
Jump to navigation Jump to search
(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...")
 
 
(2 intermediate revisions by the same user not shown)
Line 40: Line 40:
 
==<div style="background: #B0C4DE; padding: 10px; font-family:Arial; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 3px; padding 0px 18px 0 px 18 px;"><font color="white">DATASET</font></div>==
 
==<div style="background: #B0C4DE; padding: 10px; font-family:Arial; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 3px; padding 0px 18px 0 px 18 px;"><font color="white">DATASET</font></div>==
  
−
<div style="justify;">Coming soon
+
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.
 +
 
 +
<h2>Data Overview</h2>
 +
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:
 +
 
 +
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
 +
|+ '''Members List'''
 +
! scope="col" | Variable Name
 +
! scope="col" | 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
 +
|}
 +
<p>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.</p>
 +
 
 +
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
 +
|+ '''Attendance List'''
 +
! scope="col" | Variable Name
 +
! scope="col" | 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.
 +
|}
 +
<!--INSERT SAMPLE PICTURE FOR ATTENDANCE LIST-->
 +
 
 +
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
 +
|+ '''Faculty List'''
 +
! scope="col" | Variable Name
 +
! scope="col" | 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
 +
|}
 +
 
 +
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
 +
|+ '''Purchases'''
 +
! scope="col" | Variable Name
 +
! scope="col" | 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
 +
|}
 +
 
 +
<p>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.</p>

Latest revision as of 21:40, 28 February 2016

HOME

TEAM

PROJECT OVERVIEW

FINDINGS & ANALYSIS

PROJECT MANAGEMENT

DOCUMENTATION

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:

Members List
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.

Attendance List
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.
Faculty List
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
Purchases
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.

Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=AY1516_T2_Team13_Natasha_Studio_Project_Overview_Data&oldid=6144’