European Space Agency Data Factory Implementation

This case study outlines the European Space Agency's (ESA) initiative to modernize its data management through the establishment of the Data Factory, leveraging Microsoft Azure technologies. The project began with the intention to migrate existing applications to the cloud but evolved into a comprehensive overhaul of the data structure. Key components include the analysis and migration of large datasets, standardization of data for a common language, and the creation of a central Data Factory. The implementation utilized Azure Synapse for data processing and Power BI for real-time dashboards, providing a single source of truth for stakeholders. Workshops were conducted to identify data warehouses and define stakeholder requirements, ensuring a transparent process. The Data Factory enables ESA to enhance performance, accelerate project decisions, and lays the groundwork for future automation and AI projects. The collaboration with novaCapta was pivotal in achieving these objectives, resulting in improved data accessibility and operational efficiency.