Difference between revisions of "ANLY482 AY2017-18T2 Group01: Project Management"

From Analytics Practicum
Jump to navigation Jump to search
Line 35: Line 35:
 
'''Step 1:'''
 
'''Step 1:'''
  
'''Understanding the Business Problem and Business Context:'''
+
<!-- Start Information -->
 +
<div style="background:#AE0000; line-height:0.3em; font-family:montserrat; font-size:120%; border-left:#FFE2C0 solid 15px;"><div style="border-left:#fff solid 5px; padding:15px;"><font color="#fff"><strong>Understanding the Business Problem</strong></font></div></div>
 +
 
 
We first wanted to gather all information related to the booking journey of customers and the key influencing factors. To do this we carried out the following steps:
 
We first wanted to gather all information related to the booking journey of customers and the key influencing factors. To do this we carried out the following steps:
 
<br> 1. Spoke with eatigo employees beyond our sponsor (Sales Lead and Marketing Lead)
 
<br> 1. Spoke with eatigo employees beyond our sponsor (Sales Lead and Marketing Lead)
Line 41: Line 43:
 
Based on our understanding, we have mapped out the customer journey map as follows:
 
Based on our understanding, we have mapped out the customer journey map as follows:
  
[[File:Journey final.png|700 px|centre|]]
+
[[File:Journey final.png|600 px|centre|]]
  
'''Step 2:'''
+
<!-- Start Information -->
 +
<div style="background:#AE0000; line-height:0.3em; font-family:montserrat; font-size:120%; border-left:#FFE2C0 solid 15px;"><div style="border-left:#fff solid 5px; padding:15px;"><font color="#fff"><strong>Data Preparation and Cleaning</strong></font></div></div>
  
'''Data Preparation:'''
 
 
The next step involved zooming into the data sheets provided to us and understand each variable, it's sufficiency and relevance in helping us solve the business problem, and then preparing it for analysis. These were the steps in Data Preparation:
 
The next step involved zooming into the data sheets provided to us and understand each variable, it's sufficiency and relevance in helping us solve the business problem, and then preparing it for analysis. These were the steps in Data Preparation:
  
[[File:Eatigodataprep.png|700 px|centre|]]
+
[[File:Eatigodataprep.png|1000 px|centre|]]
 
 
''Joining the Dataset'' : We combined the three sheets into one consolidated sheet.
 
 
 
''Developing Meta-Data'': Once we had our combined sheet ready, we developed the meta-data to clearly understand the variables and their distributions. We had to undertake the following steps:
 
<br> i. Categorize the variables: We first had to categorize the variables into Numeric vs. Character Variables, and then further divide the Numeric variables into nominal, ordinal and continuous variables.
 
<br> ii. Map Variable Distribution: We then mapped the distribution of each variable, to find the reliability and steps needed for cleaning.
 
  
''Cleaning and Standardisation'' : Here we looked into missing values, insignificant values, discrepancies and binning.
+
The details of our work in each step has been summarized as follows:
 +
[[File:DataCleaningEatigo.png |700 px|centre|]]
  
''Transformation'': We developed a cleaned master sheet, and separate vendor and user sheets for more meaningful analysis
 
  
 
Due to confidentiality, we cannot share data details. For more information, please refer to our e-learn drop box or email us.
 
Due to confidentiality, we cannot share data details. For more information, please refer to our e-learn drop box or email us.

Revision as of 21:32, 14 April 2018


Home

Team

Project Overview

Project Findings

Project Management

Documentation

Main Page


Project Outline

We went through the following steps to execute our project:

Project ScopeEatigo.png

Step 1:

Understanding the Business Problem

We first wanted to gather all information related to the booking journey of customers and the key influencing factors. To do this we carried out the following steps:
1. Spoke with eatigo employees beyond our sponsor (Sales Lead and Marketing Lead)
2. Interviewed eatigo customers to understand their typical priorities and their customer journey. Based on our understanding, we have mapped out the customer journey map as follows:

Journey final.png
Data Preparation and Cleaning

The next step involved zooming into the data sheets provided to us and understand each variable, it's sufficiency and relevance in helping us solve the business problem, and then preparing it for analysis. These were the steps in Data Preparation:

Eatigodataprep.png

The details of our work in each step has been summarized as follows:

DataCleaningEatigo.png


Due to confidentiality, we cannot share data details. For more information, please refer to our e-learn drop box or email us.

Step 3:

Model Preparation: We plan to use clustering, market basket analysis and geospatial methods to derive our final clusters and recommendations. We are currently working on this.

Step 4:

Analysis and Insights: Based on our insights we will be developing a recommendation plan for Eatigo which will enable the company to increase bookings


Work Plan


We have prepared a work plan for our project as follows.

03.png

[Our discussions with the sponsor, professor and amongst ourselves ]