Customer Success Stories | Pythian®

AEG Worldwide

Written by Pythian Marketing | Sep 19, 2023 11:08:14 AM

 

 What we did
  • Worked with AEG and Microsoft to implement a cloud-native customer data platform, a big data and analytics solution 
    • Enterprise Data Platform brought millions of rows of data from eight different data sources in more than two dozen data formats together into a data lake (capture), then cleaned and integrated the data to create an organized and incredibly rich view of the AEG customer base (curation) 
    • This data was then made available in Azure SQL Data Warehouse to business analysts who used Power BI and other tools to create marketing programs that could be completely personalized (consumption) 
  • Tailored the Enterprise Data Platform solution to AEG’s specific needs, using Azure Blob Storage as the data lake, some open-source tools for curation, and Azure SQL Data Warehouse for consumption 
 

Technologies used

 
  • Capture (Ingestion and Storage Layers) 
  • Azure Key Vault (to store encryption/decryption keys for sensitive data) 
  • Apache NiFi 
  • Azure Blob Storage 
  • Azure VMs 
  • Encryption Server Curation (Processing Layer) 
  • Apache Spark (running on Azure VMs) 
  • Apache Airflow (tasks-scheduling and orchestration) 
  • Data Access Layer 
  • Azure SQL Data Warehouse via Power BI and Tableau 
  • Azure Blob storage via Azure ML 
 
View full post