a detailed digital illustration of the covid 19 virus interacting with dna, highlighting scientific themes related to genetics and virology.
back to home


COVID-19 Global Trend and Risk Analysis

A time-series case study exploring infection growth, mortality patterns, recovery behavior, and regional risk signals across global COVID-19 data.

Business Problem

During the COVID-19 pandemic, decision-makers needed to understand not only where cases were highest, though also how infection growth, mortality patterns, and recovery behavior evolved over time across regions. The challenge was to transform large, fast-changing global health data into structured insights that could reveal trend shifts, risk concentration, and comparative country-level patterns.

Analytical Objective

To analyze global COVID-19 time-series data in order to identify major outbreak patterns, mortality trends, recovery acceleration, testing behavior, and regional risk differences using Python, SQL, and interactive dashboards.

Key Questions Answered
  • Which countries were most heavily affected in terms of total cases and deaths?
  • How did confirmed, active, recovered, and death cases evolve over time at the global level?
  • What patterns distinguish outbreak acceleration phases from later stabilization periods?
  • How does mortality burden change when viewed relative to population size rather than raw totals?
  • What relationship can be observed between testing intensity and confirmed case burden across countries?
  • How did COVID-19 trends unfold within a focused country case such as Switzerland, and how did that compare with global patterns?
Highlight

Built an interactive country- and time-filtered dashboard that revealed infection acceleration phases, recovery lag patterns, and concentrated mortality impact across the most affected regions.

Method and Tools
  • Time-series trend analysis
  • Exploratory data analysis
  • Interactive dashboarding
  •  
 
  • Python (Pandas, NumPy, Plotly)
  • SQL
  •  
Workflow
  • cleaned and standardized multi-country COVID-19 data
  • analyzed confirmed, active, recovered, death, and testing indicators
  • used SQL logic to compare country-level patterns
  • built trend visualizations and focused country comparisons
  • translated epidemiological movement into analytical insight
Key Findings
  • Global COVID-19 case growth showed strong nonlinear acceleration early in the timeline before transitioning into more gradual phases of expansion.
  • The highest raw case and death totals were concentrated in a limited number of countries, showing that the global burden was highly uneven.
  • Recovery trends accelerated after major outbreak surges, though with visible lag relative to confirmed cases, reflecting delayed normalization after peak transmission periods.
  • Mortality burden looked different when normalized by population size, showing that severity was not always concentrated in the largest countries.
  • Countries with similar testing volumes did not always show similar confirmed case counts, suggesting structural differences in outbreak scale, detection patterns, or reporting context.
  • The Switzerland case study showed that country-level outbreak behavior could diverge meaningfully from global aggregates, with localized acceleration and stabilization phases becoming more visible at regional scale.

Figure 1. This chart tracks the global evolution of confirmed, active, recovered, and death cases over time. It highlights the strong early acceleration of confirmed cases, the later catch-up in recoveries, and the slower though persistent rise in deaths. The pattern shows how the pandemic moved through successive phases of outbreak expansion, recovery lag, and gradual stabilization.

Figure 2. This chart ranks the countries with the highest total COVID-19 deaths, showing that mortality burden was concentrated heavily among a relatively small number of nations. The ranking highlights the unequal global impact of the pandemic and helps distinguish where absolute mortality pressure was greatest in raw terms.

Figure 3. This chart moves beyond raw totals by ranking countries according to mortality rate per one million population. Unlike total deaths alone, this normalized view highlights relative severity and shows that some smaller countries experienced a disproportionately high public-health burden when population size is taken into account.

Figure 4. This scatter plot compares total COVID-19 tests and confirmed cases across countries using log-scaled axes to make large differences easier to interpret. It shows that higher testing intensity was generally associated with higher detected case counts, while also revealing that similar testing levels did not always produce similar case burdens, suggesting structural differences in outbreak scale and detection patterns.

Figure 5. This country-level breakdown shows how COVID-19 unfolded in Switzerland across confirmed, recovered, and death cases. The pattern reflects rapid early acceleration followed by slower stabilization, illustrating how regional analysis can reveal localized outbreak dynamics that may be less visible within global aggregates.

Why This Matters

This project demonstrates how large-scale public health data can be transformed into structured, decision-oriented insight. Rather than only reporting raw counts, the analysis identifies growth behavior, mortality concentration, recovery timing, and regional disparities — showing how data analysis can support interpretation during high-uncertainty conditions.

What This Project Demonstrates
  • time-series analysis using real-world crisis data
  • multi-country data cleaning and transformation
  • comparative risk and trend analysis
  • ability to interpret nonlinear growth patterns
  • dashboard storytelling for both technical and non-technical audiences
Conclusion

This project shows how high-volume epidemiological data can be converted into meaningful analytical insight through structured cleaning, trend analysis, and comparative visualization. Rather than only charting case totals, the analysis identifies outbreak phases, interprets mortality burden in both raw and normalized terms, and highlights how recovery and testing patterns contribute to a deeper understanding of pandemic dynamics.

Beyond visualization, the work reflects a disciplined analytical approach — moving from data preparation and exploratory analysis to comparative interpretation and decision-relevant communication. It demonstrates the ability to translate complex time-series health data into clear, structured insight for both technical and non-technical audiences.

Scroll to Top