Stock Movement Tracking - Stock Transfer and Procurement

Tay, Jia Yi (2020) Stock Movement Tracking - Stock Transfer and Procurement. Final Year Project (Bachelor), Tunku Abdul Rahman University College.

Text TAY JIA YI_Fulltext.pdf Restricted to Registered users only Download (4MB)

Abstract

This project is about developing a Business Intelligence (BI) Dashboard and also a report system for the employees of Kian Joo Can Factory (KJCF). For the Inventory Dashboard, users are allow to view the overview of total stock in the warehouse and also able to drilldown using stock type, item number, warehouse and stock zone. As for the report system, user is able to produce and generate report in excel format without using the manual way and also referring to multiple documents. The software that is used to develop the Business Intelligence (BI) dashboard for Kian Joo is Microsoft Power BI. The tools needed to develop the Report System is ASP.NET framework with C# using Visual Studio 2013. The database that is used to store the table and data of the Report System is MySQL database. Agile methodology has been chosen as the software development model in order to develop the project as this project requires a lot of user participation. Also, a series of test case such as unit test, integration test, system testing and will be done for both the Business Intelligence (BI) Inventory Dashboard and also the Report System to ensure the function and result generated is correct.