COVID-19 global data analysis project (SQL data processing and trend extraction)
Analyzed large-scale, multi-source COVID-19 datasets to derive infection, mortality, and vaccination trends across countries. Used advanced SQL techniques to synthesize and query data from multiple tables and temporal slices. Cleaned incomplete and messy real-world records to ensure accuracy of analysis-ready outputs for data storytelling. • Queried multi-source datasets using JOINs, window functions, and CTEs • Investigated which populations were most affected and how vaccination influenced outcomes • Produced visualization-ready outputs from cleaned datasets • Applied rigorous data cleaning methods to handle missing/inconsistent values