Difference between revisions of "ANLY482 AY2016-17 T2 Group23 Silver Daisies Project Management"

From Analytics Practicum
Jump to navigation Jump to search
 
(15 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
<!------- Logo ---->
 
−
<center>
 
−
[[File:Silver-pages-logo.jpg]]
 
−
</center>
 
  
 
<!------- Main Navigation Bar---->
 
<!------- Main Navigation Bar---->
Line 21: Line 17:
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="190px" |   
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="190px" |   
 
[[ANLY482 AY2016-17 T2 Group23 Silver Daisies Documentation|<font color="#3c3c3c"><strong>DOCUMENTATION</strong></font>]]
 
[[ANLY482 AY2016-17 T2 Group23 Silver Daisies Documentation|<font color="#3c3c3c"><strong>DOCUMENTATION</strong></font>]]
 +
 +
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="190px" | 
 +
[[ANLY482_AY2017-18_Term_2|<font color="#3c3c3c"><strong>MAIN PAGE</strong></font>]]
  
 
|}
 
|}
 
</center>
 
</center>
 
<!------- End of Main Navigation Bar---->
 
<!------- End of Main Navigation Bar---->
 +
 +
== Scope of Work ==
 +
{| class="wikitable"
 +
|-
 +
| Stage 1: Project Planning ||
 +
* Discussion with Sponsor
 +
* Understanding the nature of organization
 +
* Identifying business problems
 +
 +
|-
 +
| Stage 2: Project Proposal ||
 +
* Finalize on scope of project
 +
* Identify relevant data based on project scope
 +
* Cleaning up and organization of data based on project scope
 +
 +
|-
 +
| Stage 3: Data Collection ||
 +
* Identify and obtain relevant data based on project scope
 +
* Understand data, and seek clarifications with client (if any)
 +
* Data will be collected after signing of NDA
 +
* Data validation, cleaning and transformation to be carried out to prepare data ready for further analysis
 +
 +
|-
 +
| Stage 4: Data Analysis ||
 +
* Deriving insights from data
 +
* Sharing with client and formulating recommendations/solutions
 +
 +
|-
 +
| Stage 5: Midterm  ||
 +
* Interim discussion with Professor 
 +
* Incorporating feedback to further improve model
 +
 +
|-
 +
| Stage 6: Research Topic || * Finalizing appropriate research topic to work on
 +
|-
 +
| Stage 7: Finalization ||
 +
* Finalizing of analysis
 +
* Organizing insights to present findings to all stakeholders
 +
 +
|}
  
 
== Work Plan ==
 
== Work Plan ==
Line 48: Line 87:
 
! style="font-weight: bold; width: 4%; font-family:Helvetica Neue;" | W15
 
! style="font-weight: bold; width: 4%; font-family:Helvetica Neue;" | W15
 
|-
 
|-
−
| style="font-weight: bold; background: #efefef;" colspan="16"| Stage 1: Project Planning
+
| style="font-weight: bold; background: #efefef;" colspan="18"| Stage 1: Project Planning
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Source for sponsor  
 
| style="font-family:Helvetica Neue;"| Source for sponsor  
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|All
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|  
 
|  
Line 59: Line 98:
 
|  
 
|  
 
|  
 
|  
 +
|
 
|  
 
|  
 
|  
 
|  
 +
|
 
|  
 
|  
 
|  
 
|  
Line 68: Line 109:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Learn about sponsor's product and industry
 
| style="font-family:Helvetica Neue;"| Learn about sponsor's product and industry
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|All
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
Line 80: Line 121:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 
|
 
|
 
|  
 
|  
Line 85: Line 128:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Meeting sponsor and discussion on project topic
 
| style="font-family:Helvetica Neue;"| Meeting sponsor and discussion on project topic
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|Xiaoyou
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
Line 96: Line 139:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 
|  
 
|  
 
|
 
|
Line 102: Line 147:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Project and sponsor confirmation
 
| style="font-family:Helvetica Neue;"| Project and sponsor confirmation
−
|
+
| style="text-align: center; font-family: Helvetica Neue"|All
 
|  
 
|  
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
−
| style="background: #EC8518;" |
+
|  
 
|  
 
|  
 
|  
 
|  
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 
|
 
|
 
|  
 
|  
Line 119: Line 166:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| NDA confirmation
 
| style="font-family:Helvetica Neue;"| NDA confirmation
−
|
+
| style="text-align: center; font-family: Helvetica Neue"|All
 +
|  
 
|  
 
|  
−
| style="background: #EC8518;" |
 
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|  
 
|  
Line 128: Line 175:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 
|  
 
|  
 
|  
 
|  
Line 136: Line 185:
 
|-
 
|-
  
−
| style="font-weight: bold; background: #efefef;" colspan="16"| Stage 2: Proposal
+
| style="font-weight: bold; background: #efefef;" colspan="18"| Stage 2: Proposal
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Proposal Report
 
| style="font-family:Helvetica Neue;"| Proposal Report
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|All
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
Line 146: Line 195:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 
|
 
|
 
|
 
|
Line 156: Line 207:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Wiki Page Setup
 
| style="font-family:Helvetica Neue;"| Wiki Page Setup
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|Tham Hin
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
Line 167: Line 218:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 
|
 
|
 
|  
 
|  
Line 173: Line 226:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Work Plan
 
| style="font-family:Helvetica Neue;"| Work Plan
 +
| style="text-align: center; font-family: Helvetica Neue"|Carol
 
|  
 
|  
−
| style="background: #EC8518;" |
 
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|  
 
|  
Line 183: Line 236:
 
|
 
|
 
|  
 
|  
 +
|
 +
|
 
|  
 
|  
 
|  
 
|  
Line 189: Line 244:
 
|  
 
|  
 
|-
 
|-
−
| style="font-weight: bold; background: #efefef;" colspan="16"| Stage 3: Data Preparation
+
| style="font-weight: bold; background: #efefef;" colspan="18"| Stage 3: Data Preparation
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Data Validation
 
| style="font-family:Helvetica Neue;"| Data Validation
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|Xiaoyou
 
|  
 
|  
 
|
 
|
Line 201: Line 256:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 
|  
 
|  
 
|
 
|
Line 209: Line 266:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Data Cleaning
 
| style="font-family:Helvetica Neue;"| Data Cleaning
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|All
 
|  
 
|  
 
|
 
|
 +
| style="background: #EC8518;" |
 +
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|  
 
|  
 
|  
 
|  
 +
|
 
|  
 
|  
−
|
 
 
|
 
|
−
|  
+
|
 
|
 
|
 
|  
 
|  
Line 226: Line 285:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Data Encoding & Sorting
 
| style="font-family:Helvetica Neue;"| Data Encoding & Sorting
 +
| style="text-align: center; font-family: Helvetica Neue"|All
 +
|
 
|  
 
|  
−
|
 
 
|  
 
|  
 +
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|  
 
|  
 
|  
 
|  
 +
|
 
|  
 
|  
−
|
 
 
|
 
|
−
|  
+
|
 
|
 
|
 
|  
 
|  
Line 242: Line 303:
 
|  
 
|  
 
|-
 
|-
−
| style="font-weight: bold; background: #efefef;" colspan="16"| Stage 4: Data Analysis
+
| style="font-weight: bold; background: #efefef;" colspan="18"| Stage 4: Data Analysis
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Exploratory Data Analysis
 
| style="font-family:Helvetica Neue;"| Exploratory Data Analysis
 +
| style="text-align: center; font-family: Helvetica Neue"|All
 +
|
 
|  
 
|  
 
|
 
|
 
|  
 
|  
−
|
 
 
|  
 
|  
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
Line 255: Line 317:
 
|  
 
|  
 
|  
 
|  
−
|  
+
|
−
|  
+
|
 
|  
 
|  
 
|
 
|
Line 262: Line 324:
 
|  
 
|  
 
|-
 
|-
−
| style="font-family:Helvetica Neue;"| Manpower Ratio Analysis
+
| style="font-family:Helvetica Neue;"| Appointment Duration Analysis
 +
| style="text-align: center; font-family: Helvetica Neue"|Carol
 +
|
 +
|
 
|  
 
|  
 
|  
 
|  
 
|
 
|
−
|
 
 
|  
 
|  
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
Line 272: Line 336:
 
|  
 
|  
 
|  
 
|  
 +
|
 
|  
 
|  
−
|
 
 
|
 
|
−
|  
+
|
 
|
 
|
 
|  
 
|  
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Geospatial Analysis
 
| style="font-family:Helvetica Neue;"| Geospatial Analysis
 +
| style="text-align: center; font-family: Helvetica Neue"|Xiaoyou
 
|  
 
|  
 
|  
 
|  
 +
|
 
|  
 
|  
−
|
 
 
|  
 
|  
 
|  
 
|  
 +
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|  
 
|  
 
|  
 
|  
−
|  
+
|
−
|  
+
|
 
|
 
|
 
|  
 
|  
Line 297: Line 363:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Client Cluster Analysis
 
| style="font-family:Helvetica Neue;"| Client Cluster Analysis
−
|
+
| style="text-align: center; font-family: Helvetica Neue"|Tham Hin
 +
|  
 
|  
 
|  
 
|  
 
|  
Line 303: Line 370:
 
|  
 
|  
 
|  
 
|  
 +
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|  
 
|  
 
|  
 
|  
 
|  
 
|  
−
|  
+
|
−
|  
+
|
 
|
 
|
 
|
 
|
 
|  
 
|  
 
|-
 
|-
−
| style="font-family:Helvetica Neue;"| Time-series Analysis
+
| style="font-family:Helvetica Neue;"| Appointment Clinic Analysis
 +
| style="text-align: center; font-family: Helvetica Neue"|Tham Hin
 
|  
 
|  
 +
|
 
|  
 
|  
−
|
 
 
|  
 
|  
 
|  
 
|  
 
|  
 
|  
 +
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|  
 
|  
 
|  
 
|  
 
|  
 
|  
−
|  
+
|
−
|  
+
|
 
|
 
|
 
|
 
|
 
|  
 
|  
 
|-
 
|-
−
| style="font-weight: bold; background: #efefef;" colspan="16"| Midterm Report
+
| style="font-weight: bold; background: #efefef;" colspan="18"| Stage 5: Midterm Report
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Interim Report Preparation
 
| style="font-family:Helvetica Neue;"| Interim Report Preparation
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|All
 
|  
 
|  
 
|
 
|
Line 339: Line 409:
 
|  
 
|  
 
|
 
|
 +
|
 
|  
 
|  
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
Line 344: Line 415:
 
|  
 
|  
 
|  
 
|  
−
|  
+
|
 +
|
 
|  
 
|  
 
|  
 
|  
Line 350: Line 422:
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Interim Presentation Preparation
 
| style="font-family:Helvetica Neue;"| Interim Presentation Preparation
 +
| style="text-align: center; font-family: Helvetica Neue"|All
 +
|
 +
|
 
|  
 
|  
 
|  
 
|  
Line 355: Line 430:
 
|  
 
|  
 
|  
 
|  
−
|
 
 
|  
 
|  
−
| style="background: #EC8518;" |
 
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|  
 
|  
 
|  
 
|  
 
|  
 
|  
−
|  
+
|
 +
|
 
|
 
|
 
|  
 
|  
 
|-
 
|-
 
| style="font-family:Helvetica Neue;"| Wiki Update
 
| style="font-family:Helvetica Neue;"| Wiki Update
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|Tham Hin
 
|  
 
|  
 
|
 
|
Line 373: Line 447:
 
|  
 
|  
 
|
 
|
 +
|
 
|  
 
|  
 
|  
 
|  
Line 379: Line 454:
 
|  
 
|  
 
|  
 
|  
 +
|
 
|  
 
|  
 
|
 
|
−
|  
+
|
 
|-
 
|-
−
| style="font-weight: bold; background: #efefef;" colspan="16"| Step 4: Data Visualization
+
| style="font-weight: bold; background: #efefef;" colspan="18"| Stage 6: Research Topic Finalisation
 
|-
 
|-
−
| style="font-family:Helvetica Neue;"| Visualization development
+
| style="font-family:Helvetica Neue;"| Research Paper Insights Preparation
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|All
 
|  
 
|  
 
|
 
|
Line 396: Line 472:
 
|
 
|
 
|  
 
|  
 +
| style="background: #EC8518;" |
 +
| style="background: #EC8518;" |
 
|  
 
|  
 
|  
 
|  
−
| style="background: #EC8518;" |
+
|
 
|
 
|
 
|  
 
|  
 
|-
 
|-
−
| style="font-weight: bold; background: #efefef;" colspan="16"| Final Presentation
+
| style="font-weight: bold; background: #efefef;" colspan="18"| Stage 7:Finalisation
 
|-
 
|-
−
| style="font-family:Helvetica Neue;"| Final Report
+
| style="font-family:Helvetica Neue;"| Abstract Preparation
 +
| style="text-align: center; font-family: Helvetica Neue"|All
 
|  
 
|  
 
|
 
|
 +
|
 
|
 
|
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 +
|
 +
| style="background: #EC8518;" |
 +
| style="background: #EC8518;" |
 +
|
 +
|
 +
|
 +
|-
 +
| style="font-family:Helvetica Neue;"| Final Report Preparation
 +
| style="text-align: center; font-family: Helvetica Neue"|All
 +
|
 
|
 
|
 
|  
 
|  
 
|  
 
|  
 +
|
 
|  
 
|  
 
|  
 
|  
Line 418: Line 513:
 
|  
 
|  
 
|  
 
|  
 +
|
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 +
| style="background: #EC8518;" |
 +
|
 +
|
 
|-
 
|-
−
| style="font-family:Helvetica Neue;"| Final Presentation
+
| style="font-family:Helvetica Neue;"| Wiki update
 +
| style="text-align: center; font-family: Helvetica Neue"|Tham Hin
 
|  
 
|  
 
|  
 
|  
 
|
 
|
 +
|
 
|  
 
|  
 
|
 
|
Line 431: Line 532:
 
|  
 
|  
 
|  
 
|  
−
|
+
|
−
|  
 
 
|  
 
|  
 
|  
 
|  
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
−
| style="background: #EC8518;" |
+
|
 +
|
 
|-
 
|-
−
 
+
| style="font-family:Helvetica Neue;"| Poster
−
| style="font-family:Helvetica Neue;"| Wiki update
+
| style="text-align: center; font-family: Helvetica Neue"|Carol
 
|  
 
|  
 +
|
 
|  
 
|  
−
|
 
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 452: Line 552:
 
|  
 
|  
 
|  
 
|  
 +
|
 
|  
 
|  
 
|  
 
|  
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 +
|
 
|-
 
|-
−
| style="font-family:Helvetica Neue;"| Poster
+
| style="font-family:Helvetica Neue;"| Final Submission Preparation
−
|  
+
| style="text-align: center; font-family: Helvetica Neue"|All
 
|  
 
|  
 
|
 
|
Line 469: Line 571:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 
|  
 
|  
 
|  
 
|  
 
| style="background: #EC8518;" |
 
| style="background: #EC8518;" |
 
|}
 
|}

Latest revision as of 21:33, 15 April 2018

HOME

PROJECT OVERVIEW

ANALYSIS & FINDINGS

PROJECT MANAGEMENT

DOCUMENTATION

MAIN PAGE

Scope of Work

Stage 1: Project Planning
  • Discussion with Sponsor
  • Understanding the nature of organization
  • Identifying business problems
Stage 2: Project Proposal
  • Finalize on scope of project
  • Identify relevant data based on project scope
  • Cleaning up and organization of data based on project scope
Stage 3: Data Collection
  • Identify and obtain relevant data based on project scope
  • Understand data, and seek clarifications with client (if any)
  • Data will be collected after signing of NDA
  • Data validation, cleaning and transformation to be carried out to prepare data ready for further analysis
Stage 4: Data Analysis
  • Deriving insights from data
  • Sharing with client and formulating recommendations/solutions
Stage 5: Midterm
  • Interim discussion with Professor
  • Incorporating feedback to further improve model
Stage 6: Research Topic * Finalizing appropriate research topic to work on
Stage 7: Finalization
  • Finalizing of analysis
  • Organizing insights to present findings to all stakeholders

Work Plan

Task In Charge W0 W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15
Stage 1: Project Planning
Source for sponsor All
Learn about sponsor's product and industry All
Meeting sponsor and discussion on project topic Xiaoyou
Project and sponsor confirmation All
NDA confirmation All
Stage 2: Proposal
Proposal Report All
Wiki Page Setup Tham Hin
Work Plan Carol
Stage 3: Data Preparation
Data Validation Xiaoyou
Data Cleaning All
Data Encoding & Sorting All
Stage 4: Data Analysis
Exploratory Data Analysis All
Appointment Duration Analysis Carol
Geospatial Analysis Xiaoyou
Client Cluster Analysis Tham Hin
Appointment Clinic Analysis Tham Hin
Stage 5: Midterm Report
Interim Report Preparation All
Interim Presentation Preparation All
Wiki Update Tham Hin
Stage 6: Research Topic Finalisation
Research Paper Insights Preparation All
Stage 7:Finalisation
Abstract Preparation All
Final Report Preparation All
Wiki update Tham Hin
Poster Carol
Final Submission Preparation All
Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY2016-17_T2_Group23_Silver_Daisies_Project_Management&oldid=24433’