Cloud-Based Data Warehousing: Migration and Reporting with SAP Datasphere and SAP Analytics Cloud

This thesis was developed during my internship at Iconsulting S.p.A. and focuses on data warehousing, technological migration, and data integration, with a particular emphasis on SAP Datasphere and SAP Analytics Cloud. The study is based on a real-world project aimed at designing and optimizing an ETL process for data consolidation and business intelligence reporting. It details the transition from graphical ETL tools to SQL-based transformations, analyzing the motivations, challenges, and performance implications of different approaches. Additionally, it explores outlier detection techniques, applying statistical methods to identify anomalies and improve analytical insights.