/projects
Azure Tokyo Olympics Data Analytics
End-to-end Azure ETL and analytics pipeline processing Tokyo 2020 Olympics data using Data Factory, Databricks, and Synapse.
Highlights
- Developed a full cloud-based ETL pipeline on Azure (Data Factory, Databricks, Data Lake Gen2, Synapse) to ingest, transform, and warehouse Tokyo 2020 Olympics data for analytics and reporting
- Engineered scalable PySpark transformations including cleaning, schema standardization, feature engineering, and aggregations, producing curated datasets optimized for SQL analytics in Synapse
- Delivered actionable Olympic insights through advanced SQL analysis—medal rankings, gender participation trends, country performance metrics, and discipline popularity
Technologies
AzureSynapseDatabricksData FactoryData Lake Gen2PySparkSQL