Skip to content
Saafir HaleSecurity & InfrastructureAtlanta, GA
← Data & Analytics

COVID-19 Data Exploration.

Exploring global case, death, and vaccination data in T-SQL, with a query set feeding Tableau.

Public
About

Exploration of global COVID-19 case, death, and vaccination data entirely in T-SQL — death rate against case count, infection rate against population, and rolling vaccination totals built with window functions over partitioned data.

A second query set is written specifically to feed Tableau, aggregating to the shapes a dashboard needs and filtering out the aggregate rows — World, European Union, income bands — that would otherwise double-count against country totals.

Built with
T-SQLSQL ServerTableauWindow Functions
Links
Next@saafirhale content system →