Design and Development of a Data Mart for the HR Department at Amadori

The project carried out in this thesis focuses on the creation of a Data Mart tailored for the HR department of Amadori, one of the most important companies in the Italian agribusiness sector. The main objective is to improve human resource management through a business intelligence solution. What makes the Data Mart implementation complex is the challenge posed by the sensitivity of the data being processed, including salary information. To address this challenge, a demand-driven approach was taken to meet the department’s needs, focusing on defining and satisfying information needs. The project includes the analysis of business needs, the design of the Data Mart’s concept, the development of ETL processes, the creation of user-friendly interactive reports, and the use of MicroStrategy for data visualization as an integral part of the solution