Difference between revisions of "Hiryuu Project Management"

From Analytics Practicum
Jump to navigation Jump to search
 
(18 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
<!-- LOGO -->
 
<!-- LOGO -->
 +
[[Image:HomeButtonRounded400.png|50px |link=https://wiki.smu.edu.sg/ANLY482/ANLY482_AY2016-17_Term_2 |alt=Current Project]]
 
[[File:Logo Hiryuu.png|250px|center]]<br>
 
[[File:Logo Hiryuu.png|250px|center]]<br>
  
Line 28: Line 29:
 
[[Hiryuu_Documentations| <font color="#FFFFFF">Documentations</font>]]
 
[[Hiryuu_Documentations| <font color="#FFFFFF">Documentations</font>]]
 
|}
 
|}
 +
 +
<!---------------START of sub menu ---------------------->
 +
{| 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 #2e2e2e" width="150px"| [[Hiryuu_Project_Management| <span style="color:#3d3d3d">Overview</span>]]
 +
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|
 +
|}
 +
<!---------------END of sub menu ---------------------->
  
 
<!--------------- Body Start ---------------------->
 
<!--------------- Body Start ---------------------->
 +
==<div style="background: #A4A4A4; line-height: 0.3em; font-family:Roboto;  border-left: #848484 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#ffffff"><strong>Scope of Work</strong></font></div></div>==
 +
<ol>
 +
<li><b>Data Gathering and Scoping</b></li>
 +
Data have been gathered from our sponsor which consists of data across 3 months and spanning across several countries. The data given to us are all in .csv formats.
 +
 +
<li><b>Research on Software and Proposal Preparation</b></li>
 +
Our team has researched and discussed on the software and applications used in analysing and visualising the data with our supervisor and sponsor.
 +
 +
<p>We will mainly utilise JMP Pro for the clustering, exploratory, and seasonality analysis and QGIS for our geospatial analysis. Our sponsor has expressed their preference for the final product to be in Power BI as they are familiar with it. In addition, they have expressed interest for the final product to be dynamic, meaning any input of future data can tap on the methods used to produce the results.</p>
 +
 +
<p>Currently we will focus on analysis on JMP Pro and QGIS and have plans to decide how to compromise the dynamic capabilities within our limitations.</p>
 +
 +
<li><b>Data Cleaning and restructuring</b></li>
 +
<p>After looking and familiarising ourselves with the data, we discovered the complexity of the data. The data is not only large in size, contains a wide variety, and also inconsistent across different countries. This inconsistency is due to the differences in language used for reporting as well as different systems used. As such, certain coding languages could not be used to process the values and other solutions have to be looked into. </p>
 +
 +
<p>Due to the complexity and variety of the data, we will be conducting data cleaning by removing duplicates, ensuring consistency by inserting the header column, merging the data files, filtering the data by countries and checking that the data is appropriate and ready for analysis. </p>
 +
 +
<li><b>Data Modelling</b></li>
 +
<ol type="a">
 +
<li>Exploratory Analysis</li>
 +
<li>Geospatial Analysis
 +
<li>Time Series Data Analysis
 +
</ol>
 +
 +
<li><b>Dashboard Building</b></li>
 +
<p>To offer a dynamic dashboard that can intake raw data from the providers and produce meaningful graphs and charts for the user to understand the logistics performance,
 +
we decided to utilise <i>Rshiny</i>. Both service providers engaged very different in their data collection, hence we decided to build 2 separate dashboards to handle the 2 very different formats. However, our delivery of analysis is similar for both dashboards. We were able to build the dashboard with a clearer end picture in mind as we had a c better understanding of the data after the earlier analysis done on JMP Pro.</p>
 +
</ol>
 +
 
==<div style="background: #A4A4A4; line-height: 0.3em; font-family:Roboto;  border-left: #848484 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#ffffff"><strong>Timeline</strong></font></div></div>==
 
==<div style="background: #A4A4A4; line-height: 0.3em; font-family:Roboto;  border-left: #848484 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#ffffff"><strong>Timeline</strong></font></div></div>==
  
Line 93: Line 131:
 
| Week 2
 
| Week 2
 
| All
 
| All
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
Line 100: Line 138:
 
| Week 2
 
| Week 2
 
| All
 
| All
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
Line 107: Line 145:
 
| Week 2
 
| Week 2
 
| All
 
| All
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|- style="background:#A4A4A4; color:white; text-align: left;"  
 
|- style="background:#A4A4A4; color:white; text-align: left;"  
Line 113: Line 151:
 
|-
 
|-
 
|-
 
|-
−
| Stage 1:
+
| Analysis 1: Exploratory Analysis
−
| Week 4
+
| Week 3
−
| Week 4
 
−
| Yi Sheng
 
−
| style="background:aquamarine"| '''Completed'''
 
−
|-
 
−
|-
 
−
| Data Cleaning
 
−
| Week 4
 
 
| Week 8
 
| Week 8
 
| All
 
| All
−
| style="background:aquamarine"| '''Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
−
|- style="background:black; color:white; text-align: left;"
+
| Analysis 2: Time Series/Seasonality
−
|colspan="7"|'''Modelling'''
+
| Week 6
 +
| Week 9
 +
| Wan Theng
 +
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
−
| Stage 1: Exploratory Analysis
+
| Analysis 3: Geospatial Analysis
 
| Week 4
 
| Week 4
−
| Week 8
+
| Week 13
−
| All
+
| Qianpin
−
| style="background:aquamarine"| '''Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 +
|- style="background:#A4A4A4; color:white; text-align: left;"
 +
|colspan="7"|'''Interim Preparation'''
 
|-
 
|-
−
| Stage 2: Funnel Plot Analysis
+
| Gather feedback from Client
−
| Week 7
+
| Week 4
−
| Week 9
 
−
| Elizabeth
 
−
| style="background:aquamarine"| '''Completed'''
 
−
|-
 
−
|-
 
−
| Stage 3: Time-Series Analysis
 
 
| Week 8
 
| Week 8
−
| Week 10
+
| All
−
| Elizabeth & Kang Long
+
| style="background:#00BFFF; color:white"| '''Completed'''
−
| style="background:aquamarine"| '''Completed'''
 
−
|-
 
−
|-
 
−
| Stage 4: Geospatial Analysis
 
−
| Week 7
 
−
| Week 10
 
−
| Yi Sheng
 
−
| style="background:aquamarine"| '''Completed'''
 
 
|-
 
|-
−
|- style="background:black; color:white; text-align: left;"
 
−
|colspan="7"|'''Midterm Presentation'''
 
 
|-
 
|-
−
|-
+
| Prepare interim report and slides
−
| Create Midterm Report
 
 
| Week 7
 
| Week 7
 
| Week 8
 
| Week 8
−
| All
+
| Jouta
−
| style="background:aquamarine"| '''Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
−
| Update Wiki
+
|- style="background:#A4A4A4; color:white; text-align: left;"
−
| Week 8
+
|colspan="7"|'''Application Building'''
−
| Week 8
 
−
| Elizabeth
 
−
| style="background:aquamarine"| '''Completed'''
 
 
|-
 
|-
 
|-
 
|-
−
|- style="background:black; color:white; text-align: left;"
+
| Code the application
−
|colspan="7"|'''Testing & Iteration'''
+
| Week 6
−
|-
+
| Week 14
−
|-
 
−
| Stage 6: Refining and extrapolating
 
−
| Week 8
 
−
| Week 13
 
 
| All
 
| All
−
| style="background:aquamarine"| '''Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
−
| Meeting Client to get feedback
+
| Testing the application
−
| Week 8
+
| Week 10
−
| Week 13
+
| Week 14
 
| All
 
| All
−
| style="background:aquamarine"| '''Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
−
| Refine Model based on feedback
+
| Gather feedback from Client
−
| Week 8
+
| Week 12
−
| Week 14
+
| Week 16
 
| All
 
| All
−
| style="background:aquamarine"| '''Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 +
|- style="background:#A4A4A4; color:white; text-align: left;"
 +
|colspan="7"|'''Iteration'''
 
|-
 
|-
−
|- style="background:black; color:white; text-align: left;"
 
−
|colspan="7"|'''Final Presentation'''
 
 
|-
 
|-
 +
| Adjust analysis
 +
| Week 12
 +
| Week 13
 +
| Jouta
 +
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
−
| Prepare final presentation slides
 
−
| Week 14
 
−
| Week 14
 
−
| Kang Long & Yi Sheng
 
−
| style="background:aquamarine"| '''Completed'''
 
 
|-
 
|-
−
|-
+
| Refine results to improve clarity
−
| Update Wiki
+
| Week 12
−
| Week 14
+
| Week 13
−
| Week 14
+
| Wan Theng, Qianpin
−
| Elizabeth
+
| style="background:#00BFFF; color:white"| '''Completed'''
−
| style="background:aquamarine"| '''Completed'''
 
 
|-
 
|-
 
|-
 
|-
−
|- style="background:black; color:white; text-align: left;"  
+
|- style="background:#A4A4A4; color:white; text-align: left;"  
−
|colspan="7"|'''Research Paper'''
+
|colspan="7"|'''Final Preparation'''
 
|-
 
|-
 
|-
 
|-
−
| Set up structure of research paper
+
| Prepare Research Paper
−
| Week 3
 
 
| Week 14
 
| Week 14
−
| All
 
−
| style="background:aquamarine"| '''Completed'''
 
−
|-
 
−
|-
 
−
| Update research paper (iterative)
 
−
| Week 3
 
 
| Week 14
 
| Week 14
 
| All
 
| All
−
| style="background:aquamarine"| '''Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
−
|- style="background:black; color:white; text-align: left;"
+
| Prepare Poster
−
|colspan="7"|'''Poster'''
+
| Week 15
−
|-
+
| Week 15
−
|-
+
| Qianpin
−
| Create Poster
+
| style="background:#00BFFF; color:white"| '''Completed'''
−
| Week 14
 
−
| Week 14
 
−
| All
 
−
| style="background:aquamarine"| '''Completed'''
 
 
|-
 
|-
 
|}
 
|}
Line 256: Line 256:
 
[[File:Hiryuu_Gantt_Chart.JPG|1000px|center]]
 
[[File:Hiryuu_Gantt_Chart.JPG|1000px|center]]
  
−
==<div style="background: #A4A4A4; line-height: 0.3em; font-family:Roboto;  border-left: #848484 solid 15px;"><div style="border-left: #FFFFFF solid 5px; padding:15px;font-size:15px;"><font color= "#ffffff"><strong>Weekly Diary</strong></font></div></div>==
+
Final Changes:  
 +
* Clustering module removed
 +
* Exploratory Analysis completed by Week 8
 +
* Time Series completed by Week 9
 +
* Geospatial Analysis completed by Week 14
 +
* Both Rshiny dashboards completed by Week 15
 +
* Dummy Data created for poster session

Latest revision as of 13:49, 22 April 2017

Current Project

Logo Hiryuu.png


Home

About Us

Project Overview

Findings

Project Management

Documentations

Overview

Scope of Work

  1. Data Gathering and Scoping
    2. Data have been gathered from our sponsor which consists of data across 3 months and spanning across several countries. The data given to us are all in .csv formats.
  2. Research on Software and Proposal Preparation
    3. Our team has researched and discussed on the software and applications used in analysing and visualising the data with our supervisor and sponsor.

    We will mainly utilise JMP Pro for the clustering, exploratory, and seasonality analysis and QGIS for our geospatial analysis. Our sponsor has expressed their preference for the final product to be in Power BI as they are familiar with it. In addition, they have expressed interest for the final product to be dynamic, meaning any input of future data can tap on the methods used to produce the results.

    Currently we will focus on analysis on JMP Pro and QGIS and have plans to decide how to compromise the dynamic capabilities within our limitations.

  3. Data Cleaning and restructuring

    4. After looking and familiarising ourselves with the data, we discovered the complexity of the data. The data is not only large in size, contains a wide variety, and also inconsistent across different countries. This inconsistency is due to the differences in language used for reporting as well as different systems used. As such, certain coding languages could not be used to process the values and other solutions have to be looked into.

    Due to the complexity and variety of the data, we will be conducting data cleaning by removing duplicates, ensuring consistency by inserting the header column, merging the data files, filtering the data by countries and checking that the data is appropriate and ready for analysis.

  4. Data Modelling
    1. Exploratory Analysis
    2. Geospatial Analysis
    3. Time Series Data Analysis
  5. Dashboard Building

    6. To offer a dynamic dashboard that can intake raw data from the providers and produce meaningful graphs and charts for the user to understand the logistics performance, we decided to utilise Rshiny. Both service providers engaged very different in their data collection, hence we decided to build 2 separate dashboards to handle the 2 very different formats. However, our delivery of analysis is similar for both dashboards. We were able to build the dashboard with a clearer end picture in mind as we had a c better understanding of the data after the earlier analysis done on JMP Pro.

Timeline

Tasks Start End Teammates Involved Status
Data Gathering and Scoping
Gather Data Week 0 Week 0 All Completed
Finalise Requirements with client Week 0 Week 0 All Completed
Scope Project Week 0 Week 0 All Completed
Research and Preparation
Explore software Week 0 Week 0 All Completed
Finalise Proposal Week 0 Week 0 All Completed
Create and update wiki page Week 0 Week 0 All Completed
Data Cleaning
Data collection Week 1 Week 2 All Completed
Data cleaning and restructuring Week 1 Week 2 All Completed
Resolve/remove incomplete data Week 1 Week 2 All Completed
Data Modelling
Analysis 1: Exploratory Analysis Week 3 Week 8 All Completed
Analysis 2: Time Series/Seasonality Week 6 Week 9 Wan Theng Completed
Analysis 3: Geospatial Analysis Week 4 Week 13 Qianpin Completed
Interim Preparation
Gather feedback from Client Week 4 Week 8 All Completed
Prepare interim report and slides Week 7 Week 8 Jouta Completed
Application Building
Code the application Week 6 Week 14 All Completed
Testing the application Week 10 Week 14 All Completed
Gather feedback from Client Week 12 Week 16 All Completed
Iteration
Adjust analysis Week 12 Week 13 Jouta Completed
Refine results to improve clarity Week 12 Week 13 Wan Theng, Qianpin Completed
Final Preparation
Prepare Research Paper Week 14 Week 14 All Completed
Prepare Poster Week 15 Week 15 Qianpin Completed

Work Plan

  • Fortnightly meetings with Supervisor
  • Monthly meetings with Sponsor
Hiryuu Gantt Chart.JPG

Final Changes:

  • Clustering module removed
  • Exploratory Analysis completed by Week 8
  • Time Series completed by Week 9
  • Geospatial Analysis completed by Week 14
  • Both Rshiny dashboards completed by Week 15
  • Dummy Data created for poster session
Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=Hiryuu_Project_Management&oldid=15283’