Inventory management and booking software for the IWF Communications
The IWF Communication has been using an Excel file to manage their inventory, which offers certain ease of use, but also brings its own issues. Through a workshop, all requirements were gathered so that an alternative web application could be developed.
Manuele Alberto Vaccari, 2022
Bachelor Thesis, IWF Communications, IWF AG
Betreuende Dozierende: Rainer Telesko
Keywords: Excel, Web Application, Agile, SCRUM, Requirements Analysis, User Stories, Database Model
The client has been using an Excel file for managing their inventory and when needing to gather information from it. This leads to issues where one cannot be sure the information is up-to-date since data might be missing, an item was stolen, or something is broken but is not noted. There is also no way of knowing if an item is being used or reserved for a particular event. Practically, this file is only being used as a list of items. Another issue with Excel files is that only one person can work on them simultaneously.
The first step consisted of collecting all the information about the process of working with this Excel file and their inventory. This means that a workshop was conducted with the client where everyone brainstormed about the entire process and thought about which data was being collected to implement an efficient process. Once the requirements document was created with all the models and requirements, the application was developed following the Agile SCRUM method with bi-weekly sprints. This lasted for three sprints until the work was completed.
As a result, a requirement analysis document was created. It encompasses the requirements for this thesis and notes for future developments. These are in the form of user stories and models. The application has also been created with all tools used by the IWF Web Solutions. The project can be handed off to the IWF Web Solutions without facing issues with unknown tools or programming languages. Currently, the application has the functionality to manage categories, locations, products and inventory items (physical products). This represents the master data. Thanks to this, there is now one central point where data is managed instead of multiple Excel files. Additionally, as noted by the requirements document, future developments have been considered when modelling the database and application. The next goal is to add more functionality to the application to cover the entire process, including managing projects/events and their resources.
Studiengang: Business Information Technology (Bachelor)
Fachbereich der Arbeit: