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...")
 
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
+
At present, we have been given a dataset from a time period between July 2010 to August 2012. We are also currently in the midst of requesting more data from our client.
 +
<br><br>Currently, Natasha keeps track of its purchases by members (in the form of dance packages) and attendance through a basic Excel spreadsheet using a legacy system. Thus, such manual input has resulted in various issues such as redundancy of data as well as data errors. For example, Hip Hop can be written as Hip Hop or Hip Hop (Kids), both of which are related to the same type of sale. In addition, some fields are also left blank. Thus, we anticipate that data cleansing needs to be done to address these issues. In addition, on top of performing data cleansing for our analysis, we also aim help to design a simple system for data entry purposes and eliminate the issues mentioned above. This also helps us to achieve the objective of continuity which will be beneficial to our client.
 +
There are 4 main 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
 +
|}
 +
 
 +
<!--INSERT SAMPLE PICTURE FOR MEMBER LIST-->
 +
 
 +
{| 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
 +
|-
 +
| Attendant || Participants attending the class
 +
|-
 +
| Amount || Price per participant
 +
|}
 +
 
 +
<!--INSERT SAMPLE PICTURE FOR ATTENDANCE LIST-->
 +
 
 +
 
 +
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
 +
|+ '''Faculty Attendance'''
 +
! 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
 +
|}

Revision as of 23:15, 9 January 2016

HOME

TEAM

PROJECT OVERVIEW

FINDINGS & ANALYSIS

PROJECT MANAGEMENT

DOCUMENTATION

BACKGROUND DATA METHODOLOGY


DATASET

At present, we have been given a dataset from a time period between July 2010 to August 2012. We are also currently in the midst of requesting more data from our client.

Currently, Natasha keeps track of its purchases by members (in the form of dance packages) and attendance through a basic Excel spreadsheet using a legacy system. Thus, such manual input has resulted in various issues such as redundancy of data as well as data errors. For example, Hip Hop can be written as Hip Hop or Hip Hop (Kids), both of which are related to the same type of sale. In addition, some fields are also left blank. Thus, we anticipate that data cleansing needs to be done to address these issues. In addition, on top of performing data cleansing for our analysis, we also aim help to design a simple system for data entry purposes and eliminate the issues mentioned above. This also helps us to achieve the objective of continuity which will be beneficial to our client. There are 4 main 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


Attendance List
Variable Name Description
Date Date of class
Type Type of class
Attendant Participants attending the class
Amount Price per participant


Faculty Attendance
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
Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=AY1516_T2_Team13_Natasha_Studio_Project_Overview_Data&oldid=3997’