|
|
| Line 1: |
Line 1: |
| − | __NOEDITSECTION__
| |
| − | __NOTOC__
| |
| − | <!--Header Start-->
| |
| − | {|style="background-color:#6A8D9D; color: #F5F5F5; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |
| |
| − | | style="padding:0.3em; font-size:100%; background-color:#6A8D9D; text-align:center; color: #F5F5F5" width="10%" |
| |
| − | [[ANLY482 AY2016-17 T2 Group 2|
| |
| − | <font color="#F5F5F5" size=2><b>HOME</b></font>]]
| |
| | | | |
| − | | style="background:none;" width="1%" |
| |
| − | | style="padding:0.3em; font-size:100%; background-color:#466675; text-align:center; color:#F5F5F5" width="10%" |
| |
| − | [[ANLY482 AY2016-17 T2 Group 2 Project Overview|
| |
| − | <font color="#F5F5F5" size=2><b>PROJECT OVERVIEW</b></font>]]
| |
| − |
| |
| − | | style="background:none;" width="1%" |
| |
| − | | style="padding:0.3em; font-size:100%; background-color:#6A8D9D; text-align:center; color:#F5F5F5" width="10%" |
| |
| − | [[ANLY482 AY2016-17 T2 Group 2 Findings|
| |
| − | <font color="#F5F5F5" size=2><b>FINDINGS</b></font>]]
| |
| − |
| |
| − | | style="background:none;" width="1%" |
| |
| − | | style="padding:0.3em; font-size:100%; background-color:#6A8D9D; text-align:center; color:#F5F5F5" width="10%" |
| |
| − | [[ANLY482 AY2016-17 T2 Group 2 Project Documentation|
| |
| − | <font color="#F5F5F5" size=2><b>PROJECT DOCUMENTATION</b></font>]]
| |
| − |
| |
| − | | style="background:none;" width="1%" |
| |
| − | | style="padding:0.3em; font-size:100%; background-color:#6A8D9D; text-align:center; color:#F5F5F5" width="10%" |
| |
| − | [[ANLY482 AY2016-17 T2 Group 2 Project Management|
| |
| − | <font color="#F5F5F5" size=2><b>PROJECT MANAGEMENT</b></font>]]
| |
| − | |}
| |
| − | <!--Header End-->
| |
| − |
| |
| − | <!--Sub Header-->
| |
| − | {| style="background-color:#ffffff; margin: 3px auto 0 auto" width="55%"
| |
| − | |-
| |
| − | ! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="150px"| [[ANLY482 AY2016-17 T2 Group 2 Project Overview| <span style="color:#3d3d3d">Background</span>]]
| |
| − | ! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|
| |
| − |
| |
| − | ! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #2e2e2e" width="150px"| [[ANLY482 AY2016-17 T2 Group 2 Project Overview Data Source| <span style="color:#3d3d3d">Data Source</span>]]
| |
| − | ! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|
| |
| − |
| |
| − | ! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="150px"| [[ANLY482 AY2016-17 T2 Group 2 Project Overview Methodology| <span style="color:#3d3d3d">Methodology</span>]]
| |
| − | ! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|
| |
| − | |}
| |
| − | <!--/Sub Header-->
| |
| − |
| |
| − | <!--Content-->
| |
| − | ==<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>Data Source</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);">
| |
| − | To facilitate our initial analysis, Kaiso has provided us with sample datasets that consists of some transaction data from November 2016. The three datasets given are namely the musical transaction data, concerts transaction data and customer profile data.
| |
| − | <br><br>'''Musical data'''<br>
| |
| − | This dataset contains of every instance of transaction data for customer musical purchases. Musical purchases can be in the form of local or overseas.
| |
| − | {|class="wikitable" width="60%"
| |
| − | |-
| |
| − | ! width="15%" | Data Field
| |
| − | ! Description
| |
| − |
| |
| − | |-
| |
| − | ! Currency
| |
| − | | The currency the transaction was purchased in. Should be “SGD” for all transactions.
| |
| − |
| |
| − | |-
| |
| − | ! AccDummy
| |
| − | | The account number that purchased this transaction. This is being anonymised.
| |
| − |
| |
| − | |-
| |
| − | ! TicketStatus
| |
| − | | S is for Single and M is for Multiple.
| |
| − |
| |
| − | |-
| |
| − | ! TicketType
| |
| − | | The kind of ticket type.
| |
| − |
| |
| − | |-
| |
| − | ! Channel
| |
| − | | I is for Internet and P is for Phone. We will use this column to differentiate which channel the transaction is purchased from.
| |
| − |
| |
| − | |-
| |
| − | ! MusicalDate
| |
| − | | The date where the musical is held.
| |
| − |
| |
| − | |-
| |
| − | ! QuickPick
| |
| − | | Y means that the machine picked the number while N means that the customer picked the number.
| |
| − |
| |
| − | |-
| |
| − | ! DrawNumber
| |
| − | | Unique number for each musical.
| |
| − |
| |
| − | |-
| |
| − | ! Product
| |
| − | | 23 is local production, 9 is overseas production
| |
| − |
| |
| − | |-
| |
| − | ! SettleDate
| |
| − | | The settlement date for the purchase.
| |
| − |
| |
| − | |-
| |
| − | ! Selection
| |
| − | | Seat number that the customer selected.
| |
| − |
| |
| − | |-
| |
| − | ! TicketDate
| |
| − | | The date of purchase.
| |
| − |
| |
| − | |-
| |
| − | ! TicketTime
| |
| − | | The time of purchase
| |
| − |
| |
| − | |-
| |
| − | ! TicketAmount
| |
| − | | The total amount from the purchase
| |
| − | |}
| |
| − | <br>
| |
| − | '''Concert data'''<br>
| |
| − | This dataset contains of every instance of transaction data for customer concert purchases.
| |
| − | {|class="wikitable" width="60%"
| |
| − | |-
| |
| − | ! width="15%" | Data Field
| |
| − | ! Description
| |
| − |
| |
| − | |-
| |
| − | ! Currency
| |
| − | | The currency the transaction was purchased in. Should be “SGD” for all transactions.
| |
| − |
| |
| − | |-
| |
| − | ! AccountDummy
| |
| − | | The account number that purchased this transaction. This is being anonymised.
| |
| − |
| |
| − | |-
| |
| − | ! TicketStatus
| |
| − | | A is for Active.
| |
| − |
| |
| − | |-
| |
| − | ! TicketType
| |
| − | | The kind of ticket type.
| |
| − |
| |
| − | |-
| |
| − | ! Channel
| |
| − | | I is for Internet and P is for Phone. We will use this column to differentiate which channel the transaction is purchased from.
| |
| − |
| |
| − | |-
| |
| − | ! LiveInd
| |
| − | | Y means that the purchase was on a live concert while N means otherwise
| |
| − |
| |
| − | |-
| |
| − | ! TicketType
| |
| − | | The type of ticket
| |
| − |
| |
| − | |-
| |
| − | ! LegStatus
| |
| − | |
| |
| − |
| |
| − | |-
| |
| − | ! MarketName
| |
| − | |
| |
| − |
| |
| − | |-
| |
| − | ! Odds
| |
| − | |
| |
| − |
| |
| − | |-
| |
| − | ! SettleDate
| |
| − | | The settlement date for the tickets.
| |
| − |
| |
| − | |-
| |
| − | ! SettleInfo
| |
| − | |
| |
| − |
| |
| − | |-
| |
| − | ! TicketDate
| |
| − | | The date of purchase.
| |
| − |
| |
| − | |-
| |
| − | ! TicketTime
| |
| − | | The time of purchase.
| |
| − |
| |
| − | |-
| |
| − | ! ArtistCode
| |
| − | | The concert artist that the ticket belongs to
| |
| − |
| |
| − | |-
| |
| − | ! TicketAmount
| |
| − | | The total amount from the purchase
| |
| − | |}
| |
| − | <br>
| |
| − | '''Customer Profile data'''<br>
| |
| − | This dataset consists of each customer’s account number and the associated account details.
| |
| − | {|class="wikitable" width="60%"
| |
| − | |-
| |
| − | ! width="15%" | Data Field
| |
| − | ! Description
| |
| − |
| |
| − | |-
| |
| − | ! ACCOUNTNUMBER
| |
| − | | Account number of the customer. Each account number is anonymised in the same way as the transaction datas.
| |
| − |
| |
| − | |-
| |
| − | ! GENDER
| |
| − | | The gender of the customer.
| |
| − |
| |
| − | |-
| |
| − | ! NATIONALITY
| |
| − | | The nationality of the customer
| |
| − |
| |
| − | |-
| |
| − | ! Age
| |
| − | | The age of the customer
| |
| − |
| |
| − | |-
| |
| − | ! New
| |
| − | | 0 means that it is not an old customer while 1 means that it is a new customer.
| |
| − | |}
| |
| − | </div>
| |
