Data Warehousing for Financial Processes in the Fashion Industry

Business intelligence (BI) refers to the process of collecting, analyzing, and presenting data. It is a valuable tool for organizations to make informed business decisions, and improve their overall performance. By analyzing data from various sources, organizations can identify trends, understand customer behavior, and gain insights into their operations, making strategic decisions that give them an edge over their competitors. Given the datacentric nature of BI, there is the need of data warehousing systems supporting it, with its related financial processes. A data warehouse is a central repository that stores historical data in a format that is optimized for analysis and reporting. The use of specialized software tools is required, and SAP is one of the leaders in the industry. BW/4HANA is the data warehousing solution from SAP, specifically optimized for HANA, their database management system (DBMS). This document presents the work carried out during the internship at PwC Italy, for one of the largest Italian fashion groups: in particular, it describes how the project is organized, the main objectives, the initial state of the system, and the detailed description of the work done.