Difference between revisions of "AY1516 T2 Team Skulptors - Project Overview"
(Created page with "<!--Main Navigation--> <center> {|style="background-color:#ffffff; color:#000000; width="100%" cellspacing="0" cellpadding="10" border="0" | |style="font-size:90%; border-left...") |
|||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<!--Main Navigation--> | <!--Main Navigation--> | ||
<center> | <center> | ||
| + | [[Image:Skulptors-Logo.png|160px|link=AY1516 T2 Team Skulptors]] | ||
| + | |||
{|style="background-color:#ffffff; color:#000000; width="100%" cellspacing="0" cellpadding="10" border="0" | | {|style="background-color:#ffffff; color:#000000; width="100%" cellspacing="0" cellpadding="10" border="0" | | ||
|style="font-size:90%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="8%" |[[Image:Skulptors-HomeIcon.png|30px|link=]] [[AY1516 T2 Team Skulptors |<font color="#F5F5F5" size=2><b>HOME</b></font>]] | |style="font-size:90%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#001e4d; " width="8%" |[[Image:Skulptors-HomeIcon.png|30px|link=]] [[AY1516 T2 Team Skulptors |<font color="#F5F5F5" size=2><b>HOME</b></font>]] | ||
| Line 13: | Line 15: | ||
|} | |} | ||
| + | <!--Sub Navigation--> | ||
| + | {|style="background-color:#ffffff; color:#000000; font-size:10pt" padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"| | ||
| + | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[AY1516 T2 Team Skulptors - Project Overview |<font color="#000a1a"><b>Summary</b></font>]] | ||
| + | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[AY1516 T2 Team Skulptors - Project Description |<font color="#005ae6"><b>Description</b></font>]] | ||
| + | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[AY1516 T2 Team Skulptors - Methodology & Technology |<font color="#005ae6"><b>Methodology & Technology</b></font>]] | ||
| + | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[AY1516 T2 Team Skulptors - Limitations & ROI |<font color="#005ae6"><b>Limitations & ROI</b></font>]] | ||
| + | |} | ||
<br/> | <br/> | ||
</center> | </center> | ||
| Line 18: | Line 27: | ||
<!--Content Start--> | <!--Content Start--> | ||
| − | + | In recent years, data has evolved to provide answers and solutions to problems hidden from the surface. Analytics, the study of data, has evolved over the years to be an integral tool for many companies to further improve efficiency and sustainability. However, the ability to easily visualise data, quickly modify views and interrogate data can be difficult and time consuming due to the difficulty and effort required to update reports and dashboards. On top of that, in today's connected world there are many more data sources available to organisations, such as machinery sensors, mobile devices, wearables, web logs, etc. The Internet of Things (IoT) now allows us to collect and exchange data between systems, providing a rich set of data for analysis. Some of this data is unstructured, in siloes, making it difficult to analyse in its raw form let alone integrating it to gain valuable insights .<br/> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | Today, a local multi-national corporation faces the same adversity as many others – the plight of unworked data. Visualizations of the data provided by their in-house warehousing solution has proven to be difficult and much of the information is not placed to better use. The company hopes to solve 3 main issues, namely how they should categorize their warehouse supplies into ABC categories (each category refers to how fast the goods move) to store their goods in the best location available, how can their data be visualized better so that it is easier for employees to see, and how can their warehouses be utilized to the fullest to ensure minimal wastage.<br/> | |
| + | Our team, Skulptors, will be developing a dashboard application to solve the issues of this company. Control charts will be used to depict control of the movement of the SKUs, identifying which type of products have excessive or lack of movements from the warehouse. Treemaps will be used to identify products or SKUs that have minimal utilization of warehouses, and also to identify which warehouse location is not fully utilized. Java add-ons will be used to facilitate additional functions, such as allowing the upload of an excel file to update the database. This allows for our solution to remain sustainable. Time series line graphs will also be used for easy display of inflow and outflow rate of specified SKUs.<br/> | ||
| + | With our solution, we hope to assist the company and the employees, relieving them from the hassle of manually analyzing the given data. Through our visualizations and analysis, we also hope to improve upon their warehousing solution, allowing the company to better utilize their warehouses and thus improving the business value.<br/> | ||
<br/> | <br/> | ||
<!--Content End--> | <!--Content End--> | ||
Latest revision as of 23:39, 12 January 2016
 HOME
|
 ABOUT US
|
 PROJECT OVERVIEW
|
 PROJECT MANAGEMENT
|
 DOCUMENTATION
|
| Summary | Description | Methodology & Technology | Limitations & ROI |
In recent years, data has evolved to provide answers and solutions to problems hidden from the surface. Analytics, the study of data, has evolved over the years to be an integral tool for many companies to further improve efficiency and sustainability. However, the ability to easily visualise data, quickly modify views and interrogate data can be difficult and time consuming due to the difficulty and effort required to update reports and dashboards. On top of that, in today's connected world there are many more data sources available to organisations, such as machinery sensors, mobile devices, wearables, web logs, etc. The Internet of Things (IoT) now allows us to collect and exchange data between systems, providing a rich set of data for analysis. Some of this data is unstructured, in siloes, making it difficult to analyse in its raw form let alone integrating it to gain valuable insights .
Today, a local multi-national corporation faces the same adversity as many others – the plight of unworked data. Visualizations of the data provided by their in-house warehousing solution has proven to be difficult and much of the information is not placed to better use. The company hopes to solve 3 main issues, namely how they should categorize their warehouse supplies into ABC categories (each category refers to how fast the goods move) to store their goods in the best location available, how can their data be visualized better so that it is easier for employees to see, and how can their warehouses be utilized to the fullest to ensure minimal wastage.
Our team, Skulptors, will be developing a dashboard application to solve the issues of this company. Control charts will be used to depict control of the movement of the SKUs, identifying which type of products have excessive or lack of movements from the warehouse. Treemaps will be used to identify products or SKUs that have minimal utilization of warehouses, and also to identify which warehouse location is not fully utilized. Java add-ons will be used to facilitate additional functions, such as allowing the upload of an excel file to update the database. This allows for our solution to remain sustainable. Time series line graphs will also be used for easy display of inflow and outflow rate of specified SKUs.
With our solution, we hope to assist the company and the employees, relieving them from the hassle of manually analyzing the given data. Through our visualizations and analysis, we also hope to improve upon their warehousing solution, allowing the company to better utilize their warehouses and thus improving the business value.
