Difference between revisions of "Hiryuu Project Management"

From Analytics Practicum
Jump to navigation Jump to search
 
(14 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: Exploratory Analysis
+
| Analysis 1: Exploratory Analysis
 
| Week 3
 
| Week 3
−
| Week 6
+
| Week 8
 
| All
 
| All
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
−
| Stage 2: Clustering
+
| Analysis 2: Time Series/Seasonality
−
| Week 3
 
 
| Week 6
 
| Week 6
−
| All
+
| Week 9
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| Wan Theng
 +
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
−
| Stage 3: Exploratory Analysis
+
| Analysis 3: Geospatial Analysis
−
| Week 3
+
| Week 4
−
| Week 6
+
| Week 13
−
| Jouta
 
−
| style="background:#F78181; color:white"| '''Not Completed'''
 
−
|-
 
−
|-
 
−
| Stage 4: Geospatial
 
−
| Week 5
 
−
| Week 10
 
 
| Qianpin
 
| Qianpin
−
| 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 147: Line 178:
 
| Week 8
 
| Week 8
 
| All
 
| All
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
 
| Prepare interim report and slides
 
| Prepare interim report and slides
−
| Week 6
 
 
| Week 7
 
| Week 7
 +
| Week 8
 
| Jouta
 
| Jouta
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
Line 162: Line 193:
 
|-
 
|-
 
| Code the application
 
| Code the application
−
| Week 8
+
| Week 6
−
| Week 11
+
| Week 14
 
| All
 
| All
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
 
| Testing the application
 
| Testing the application
 
| Week 10
 
| Week 10
−
| Week 12
+
| Week 14
 
| All
 
| All
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
Line 179: Line 210:
 
| Week 16
 
| Week 16
 
| 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 189: Line 220:
 
| Week 13
 
| Week 13
 
| Jouta
 
| Jouta
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
Line 196: Line 227:
 
| Week 13
 
| Week 13
 
| Wan Theng, Qianpin
 
| Wan Theng, Qianpin
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
Line 207: Line 238:
 
| Week 14
 
| Week 14
 
| All
 
| All
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|-
 
|-
Line 214: Line 245:
 
| Week 15
 
| Week 15
 
| Qianpin
 
| Qianpin
−
| style="background:#F78181; color:white"| '''Not Completed'''
+
| style="background:#00BFFF; color:white"| '''Completed'''
 
|-
 
|-
 
|}
 
|}
Line 225: 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
−
<!---------------START of sub menu ---------------------->
+
* Exploratory Analysis completed by Week 8
−
{| style="background-color:#ffffff; margin: 3px auto 0 auto" width="90%"
+
* Time Series completed by Week 9
−
|-
+
* Geospatial Analysis completed by Week 14
−
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #2e2e2e" width="150px"| [[Hiryuu_Project_Management| <span style="color:#3d3d3d">Week 0</span>]]
+
* Both Rshiny dashboards completed by Week 15
−
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|
+
* Dummy Data created for poster session
−
 
 
−
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="150px"| [[Weekly_Diary_1| <span style="color:#3d3d3d">Week 1</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"| [[Weekly_Diary_2| <span style="color:#3d3d3d">Week 2</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"| [[Weekly_Diary_3| <span style="color:#3d3d3d">Week 3</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"| [[Weekly_Diary_4| <span style="color:#3d3d3d">Week 4</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"| [[Weekly_Diary_5| <span style="color:#3d3d3d">Week 5</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"| [[Weekly_Diary_6| <span style="color:#3d3d3d">Week 6</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"| [[Weekly_Diary_7| <span style="color:#3d3d3d">Week 7</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"| [[Weekly_Diary_8| <span style="color:#3d3d3d">Week 8</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"| [[Weekly_Diary_9| <span style="color:#3d3d3d">Week 9</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"| [[Weekly_Diary_10| <span style="color:#3d3d3d">Week 10</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"| [[Weekly_Diary_11| <span style="color:#3d3d3d">Week 11</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"| [[Weekly_Diary_12| <span style="color:#3d3d3d">Week 12</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"| [[Weekly_Diary_13| <span style="color:#3d3d3d">Week 13</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"| [[Weekly_Diary_14| <span style="color:#3d3d3d">Week 14</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"| [[Weekly_Diary_15| <span style="color:#3d3d3d">Week 15</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"| [[Weekly_Diary_16| <span style="color:#3d3d3d">Week 16</span>]]
 
−
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|
 
−
|}
 
−
<!---------------END of sub menu ---------------------->
 

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’