Difference between revisions of "Improved Decisions for Ocean FreightsProject Management"

From Analytics Practicum
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 22: Line 22:
 
<!------- End of Sub Navigation Bar---->
 
<!------- End of Sub Navigation Bar---->
 
</center>
 
</center>
 +
<br />
 +
{| style="background-color:#ffffff; width:80%; font-family:Century Gothic; font-size:15px; margin: 3px auto 0 auto;" |
 +
| style="background-color:#006600; ; color:#ffffff; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff; width:50%; " |
 +
[[Improved_Decisions_for_Ocean_Freights|<span style="color:#ffffff"><strong>Quick Overview on Schedule</strong></span>]]
 +
|-
 +
|<center>[[File:FreightsScheduleOverview.png|800px]]</center>
 +
|}
 +
<!-- Scrollable table for Scdeule Breakdown -->
 +
<div style="width: 100%; height:30em; overflow:auto; border: 2px solid #088">
 +
{| style="width: 100%;" border="1"
 +
! scope="row" colspan="3" | || scope="row" colspan="2" | Planned
 +
|-
 +
! WBS || Tasks || width="20%"|Milestone || width="10%"|Start || width="10%"|End
 +
|-
 +
<!-- Work Breakdown Structure 1 -->
 +
| 1
 +
| <b>Project Administrations</b><br>
 +
<ul>
 +
<li>Team Formation</li>
 +
<li>Project Selection</li>
 +
<li>NDA Signing and Dataset Collection</li>
 +
</ul>
 +
|
 +
|<center>17 Aug 2015</center>
 +
|<center>23 Aug 2015</center>
 +
|-
 +
<!-- Work Breakdown Structure 2 -->
 +
| 2
 +
|
 +
<b>Initial Exploratory Data Analysis (EDA)</b><br>
 +
<ul>
 +
<li></li>
 +
<li>Build up database</li>
 +
<li>Login & authentication</li>
 +
<li>Grant user roles</li>
 +
<li>Create claims</li>
 +
<li>Edit/ update claims </li>
 +
<li>Delete claims </li>
 +
<li>View claims</li>
 +
<li>Save function for unsubmitted claims</li>
 +
</ul>
 +
 +
<b>Proposal</b><br>
 +
<ul>
 +
<li>Finalise project proposal</li>
 +
<li>Propose and install any relevant software: Tableau 9.0 & JMP Pro 11/12</li>
 +
</ul>
 +
 +
<b>Documentation</b><br>
 +
<ul>
 +
<li>Update revelant documents & progress</li>
 +
<li>Prepare project writeup on wiki</li>
 +
</ul>
 +
|<center>Proposal<br><b>Week 3</b></center>
 +
|<center>24 Aug 2015</center>
 +
|<center>30 Aug 2015</center>
 +
|-
 +
<!-- Work Breakdown Structure 3 -->
 +
|3
 +
|<b>Iteration 1: Customers Profiling</b><br>
 +
<ul>
 +
<li>EDA specific to Customer Profiling</li>
 +
<li>Utilization Analysis</li>
 +
<li>Design Visualisation to help identify FCL switch opportunities</li>
 +
</ul>
 +
 +
<b>Testing</b><br>
 +
<ul>
 +
<li>Evaluate visualisation and analysis</li>
 +
<li>Modifications where applicable</li>
 +
</ul>
 +
 +
<b>Others</b><br>
 +
<ul>
 +
<li>Tableau Functions Research</li>
 +
</ul>
 +
 +
<b>Interim Preparations & Documentation</b><br>
 +
<ul>
 +
<li>Prepare Slides and Report</li>
 +
<li>Update Wiki and Documentation</li>
 +
</ul>
 +
|
 +
|<center>31 Aug 2015</center>
 +
|<center>14 Sep 2015</center>
 +
|-
 +
<!-- Work Breakdown Structure 4 -->
 +
|4
 +
|<b>Iteration 2: Trade Lanes Profiling</b><br>
 +
<ul>
 +
<li>EDA specific to Trade Lanes Profiling</li>
 +
<li>Utilization Analysis</li>
 +
<li>Design Visualisation</li>
 +
<li>Time-Series Analysis</li>
 +
</ul>
 +
 +
<b>Testing</b><br>
 +
<ul>
 +
<li>Evaluate visualisation and analysis</li>
 +
<li>Modifications where applicable</li>
 +
</ul>
 +
 +
<b>Others</b><br>
 +
<ul>
 +
<li>Tableau Functions Research</li>
 +
</ul>
 +
 +
<b>Interim Preparations & Documentation</b><br>
 +
<ul>
 +
<li>Prepare Slides and Report</li>
 +
<li>Update Wiki and Documentation</li>
 +
</ul>
 +
|<center>Interim<br><b>Week 6, 7</b></center>
 +
|<center>15 Sep 2015</center>
 +
|<center>27 Sep 2015</center>
 +
|-
 +
<!-- Work Breakdown Structure 5 -->
 +
|5
 +
|<b>Iteration 3: What-if Analysis</b><br>
 +
<ul>
 +
<li>EDA specific to What-if Analysis</li>
 +
<li>Building Model for What-if</li>
 +
<li>Design Visualisation</li>
 +
</ul>
 +
 +
<b>Testing</b><br>
 +
<ul>
 +
<li>Evaluate visualisation and analysis</li>
 +
<li>Modifications where applicable</li>
 +
</ul>
 +
 +
<b>Others</b><br>
 +
<ul>
 +
<li>Tableau Functions Research</li>
 +
<li>Dashboarding and Storyboarding</li>
 +
</ul>
 +
 +
<b>Documentation</b><br>
 +
<ul>
 +
<li>Update Wiki and Documentation</li>
 +
</ul>
 +
|<center>Interim<br><b>Week 6, 7</b></center>
 +
|<center>28 Sep 2015</center>
 +
|<center>11 Oct 2015</center>
 +
|-
 +
<!-- Work Breakdown Structure 6 -->
 +
|6
 +
|<b>Iteration 4: Consolidation & Conclusion</b><br>
 +
<ul>
 +
<li>Dashboard: Putting all the findings together</li>
 +
<li>Customized Functions for reusability</li>
 +
</ul>
 +
 +
<b>Testing</b><br>
 +
<ul>
 +
<li>Evaluate visualisation and analysis</li>
 +
<li>Modifications where applicable</li>
 +
</ul>
 +
 +
<b>Finals & Documentation</b><br>
 +
<ul>
 +
<li>Prepare Slides and Report</li>
 +
<li>Update Wiki and Documentation</li>
 +
</ul>
 +
|
 +
|<center>12 Oct 2015</center>
 +
|<center>22 Oct 2015</center>
 +
|-
 +
 +
  |} </div>
 +
<!-- End of Scrollable table -->

Latest revision as of 17:48, 30 August 2015

Home

PROJECT MANAGEMENT

Documentation

Analysis & Findings

SCHEDULE

Plan & Methodology


Quick Overview on Schedule

FreightsScheduleOverview.png
Planned
WBS Tasks Milestone Start End
1 Project Administrations
  • Team Formation
  • Project Selection
  • NDA Signing and Dataset Collection
17 Aug 2015
23 Aug 2015
2

Initial Exploratory Data Analysis (EDA)

  • Build up database
  • Login & authentication
  • Grant user roles
  • Create claims
  • Edit/ update claims
  • Delete claims
  • View claims
  • Save function for unsubmitted claims

Proposal

  • Finalise project proposal
  • Propose and install any relevant software: Tableau 9.0 & JMP Pro 11/12

Documentation

  • Update revelant documents & progress
  • Prepare project writeup on wiki
Proposal
Week 3
24 Aug 2015
30 Aug 2015
3 Iteration 1: Customers Profiling
  • EDA specific to Customer Profiling
  • Utilization Analysis
  • Design Visualisation to help identify FCL switch opportunities

Testing

  • Evaluate visualisation and analysis
  • Modifications where applicable

Others

  • Tableau Functions Research

Interim Preparations & Documentation

  • Prepare Slides and Report
  • Update Wiki and Documentation
31 Aug 2015
14 Sep 2015
4 Iteration 2: Trade Lanes Profiling
  • EDA specific to Trade Lanes Profiling
  • Utilization Analysis
  • Design Visualisation
  • Time-Series Analysis

Testing

  • Evaluate visualisation and analysis
  • Modifications where applicable

Others

  • Tableau Functions Research

Interim Preparations & Documentation

  • Prepare Slides and Report
  • Update Wiki and Documentation
Interim
Week 6, 7
15 Sep 2015
27 Sep 2015
5 Iteration 3: What-if Analysis
  • EDA specific to What-if Analysis
  • Building Model for What-if
  • Design Visualisation

Testing

  • Evaluate visualisation and analysis
  • Modifications where applicable

Others

  • Tableau Functions Research
  • Dashboarding and Storyboarding

Documentation

  • Update Wiki and Documentation
Interim
Week 6, 7
28 Sep 2015
11 Oct 2015
6 Iteration 4: Consolidation & Conclusion
  • Dashboard: Putting all the findings together
  • Customized Functions for reusability

Testing

  • Evaluate visualisation and analysis
  • Modifications where applicable

Finals & Documentation

  • Prepare Slides and Report
  • Update Wiki and Documentation
12 Oct 2015
22 Oct 2015
Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=Improved_Decisions_for_Ocean_FreightsProject_Management&oldid=2608’