Most small and medium industries are looking for a tool to summarize the performance trend within the various business units. The increasing complexity of value chains has made it increasingly difficult to keep the flow of data under control, especially in the warehouse that is becoming one of the most crucial processes within a supply chain. Inside of it, all the products pass through during both the inbound and outbound phase. For these reasons, the warehouse manager is gaining a more important role within a company because of the large quantities of components and the complexity that he has to manage. This project aims to create a tool that allows creating a dashboard with the use of different cards, graphs, and tables that evidence the situation of the warehouse. The manager will be aided in the management of the different products and can also make decisions in an objective and simplified way. The most widely used software within the companies remains Microsoft Excel, which is formidable in the simple calculation of some parameters but makes some functions very laborious and not very dynamic. For this reason, the project was developed using an intelligence Business tool, called Power BI. Loading and managing data from parts of the software is intuitive, easy, and quick to learn. The main feature of the program is to create dynamic reports, linked to corporate databases and customizable complements.
La maggior parte delle piccole e medie industrie stanno cercando uno strumento capace di riepilogare l'andamento delle prestazioni all'interno delle varie business unit in quanto il continuo aumento della complessità nelle catene di valore ha reso sempre più difficile mantenere i flussi di dati sotto controllo. Il magazzino è il luogo cruciale all'interno di una supply chain al cui interno passano infatti, tutti i prodotti sia durante la fase di inbound che di outbound. Per questo motivo, il ruolo del manager del magazzino sta diventando sempre più importante all'interno di un’azienda per le grosse quantità di componenti che deve gestire. L'obiettivo di questo progetto è quello di creare una dashboard con all'interno differenti schede, grafici e tabelle che evidenziano la situazione del magazzino; il manager sarà così aiutato nella gestione dei diversi prodotti e potrà anche prendere decisioni in maniera oggettiva e semplificata. Il software più largamente diffuso all'interno delle imprese rimane Excel, il quale è formidabile nel semplice calcolo di alcuni parametri ma rende alcune funzioni molto laboriose e poco dinamiche. Per questo motivo, il progetto è stato sviluppato utilizzando uno strumento di Business Intelligence, chiamato Power BI che si caratterizza per un caricamento e una gestione dei dati intuitiva, facile e veloce. Dote principale del programma è inoltre quella di creare report dinamici, collegati ai database aziendali e completamente personalizzabili.
Implementation of a dashboard for measuring warehouse performance - Proposal based on a business intelligence software
Crestan, Luca
2021/2022
Abstract
Most small and medium industries are looking for a tool to summarize the performance trend within the various business units. The increasing complexity of value chains has made it increasingly difficult to keep the flow of data under control, especially in the warehouse that is becoming one of the most crucial processes within a supply chain. Inside of it, all the products pass through during both the inbound and outbound phase. For these reasons, the warehouse manager is gaining a more important role within a company because of the large quantities of components and the complexity that he has to manage. This project aims to create a tool that allows creating a dashboard with the use of different cards, graphs, and tables that evidence the situation of the warehouse. The manager will be aided in the management of the different products and can also make decisions in an objective and simplified way. The most widely used software within the companies remains Microsoft Excel, which is formidable in the simple calculation of some parameters but makes some functions very laborious and not very dynamic. For this reason, the project was developed using an intelligence Business tool, called Power BI. Loading and managing data from parts of the software is intuitive, easy, and quick to learn. The main feature of the program is to create dynamic reports, linked to corporate databases and customizable complements.| File | Dimensione | Formato | |
|---|---|---|---|
|
Implementation of a dashboard for measuring warehouse performance - Proposal based on a business intelligence software.pdf
accessibile in internet solo dagli utenti autorizzati
Dimensione
2.44 MB
Formato
Adobe PDF
|
2.44 MB | Adobe PDF | Visualizza/Apri |
I documenti in POLITesi sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
https://hdl.handle.net/10589/187128