Difference between revisions of "Hiryuu Data"
Jump to navigation
Jump to search
Wtchua.2013 (talk | contribs) (Created page with "<!-- LOGO --> <!--MAIN HEADER --> {|style="background-color:#F5A9A9;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | style="font-family:Roboto; fon...") |
Wtchua.2013 (talk | contribs) |
||
| Line 1: | Line 1: | ||
<!-- LOGO --> | <!-- LOGO --> | ||
| + | [[File:Logo Hiryuu.png|250px|center]]<br> | ||
| + | |||
<!--MAIN HEADER --> | <!--MAIN HEADER --> | ||
| − | {|style="background-color:# | + | {|style="background-color:#A9F5F2;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | |
| − | + | | style="font-family:Roboto; font-size:100%; font-weight: bold; solid #F5A9A9; border-bottom:7px solid #0174DF; background:#848484; text-align:center;" width="15%" | | |
| − | | style="font-family:Roboto; font-size: | ||
; | ; | ||
| − | [[Hiryuu_Home| <font color="# | + | [[Hiryuu_Home| <font color="#A9F5F2">Home</font>]] |
| − | | style="font-family:Roboto; font-size: | + | | style="font-family:Roboto; font-size:100%; font-weight: bold; solid #F5A9A9; border-bottom:7px solid #0174DF; background:#848484; text-align:center;" width="15%" | |
; | ; | ||
| − | [[Hiryuu_About_Us| <font color="# | + | [[Hiryuu_About_Us| <font color="#A9F5F2">About Us</font>]] |
| − | | style="font-family:Roboto; font-size: | + | | style="font-family:Roboto; font-size:100%; font-weight: bold; solid #F5A9A9; border-bottom:7px solid #00BFFF; background:#A4A4A4; text-align:center;" width="20%" | |
; | ; | ||
| − | [[Hiryuu_Project_Overview| <font color="# | + | [[Hiryuu_Project_Overview| <font color="#A9F5F2">Project Overview</font>]] |
| − | | style="font-family:Roboto; font-size: | + | | style="font-family:Roboto; font-size:100%; font-weight: bold; solid #F5A9A9; border-bottom:7px solid #0174DF; background:#848484; text-align:center;" width="15%" | |
; | ; | ||
| − | [[Hiryuu_Findings| <font color="# | + | [[Hiryuu_Findings| <font color="#A9F5F2">Findings</font>]] |
| − | | style="font-family:Roboto; font-size: | + | | style="font-family:Roboto; font-size:100%; font-weight: bold; solid #F5A9A9; border-bottom:7px solid #0174DF; background:#848484; text-align:center;" width="20%" | |
; | ; | ||
| − | [[Hiryuu_Project_Management| <font color="# | + | [[Hiryuu_Project_Management| <font color="#A9F5F2">Project Management</font>]] |
| − | | style="font-family:Roboto; font-size: | + | | style="font-family:Roboto; font-size:100%; font-weight: bold; solid #F5A9A9; border-bottom:7px solid #0174DF; background:#848484; text-align:center;" width="15%" | |
; | ; | ||
| − | [[Hiryuu_Documentations| <font color="# | + | [[Hiryuu_Documentations| <font color="#A9F5F2">Documentations</font>]] |
|} | |} | ||
| − | |||
<!---------------START of sub menu ----------------------> | <!---------------START of sub menu ----------------------> | ||
| − | {| style="background-color:#ffffff; margin: 3px auto 0 auto" width="55%" | + | {| 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 #ffffff" width="150px"| [[Hiryuu_Project Overview| <span style="color:#3d3d3d">Background</span>]] | ! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="150px"| [[Hiryuu_Project Overview| <span style="color:#3d3d3d">Background</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="20px"| | ||
Revision as of 15:02, 30 December 2016
|
|
|
|
|
|
|
| Background | Data | Methodology |
|---|
Data
Data
Total timespan of available data is 3 months worth. There are 2 main datasheets by 2 tracker systems, App1 and App2, owned by the company. Generally they display shipment and customer data for all the items that the company delivers. The dataset is utilized by the sales team to track and monitor shipments.
The App1 TrackHeader and the App2 ShipmentInfo datasets store information pertaining to the shipment itself, such as the sender and receiver data. The App1 Track Detail and the App2 StatusInfo datasets store information pertaining to the tracking data of the shipment, with each row representing a status update for each tracking number. Such data is split into these 2 types following the database normalization processes as per standard data management practices.
All dates and timings in the dataset are stored in String format, so we will classify such data types as Text/String format for easier reference.
Legend:
# Numeric/ID/int or double
^ Text/String format (Eg. words/letters)
* Fixed/Constant
App 1
App 2
