← Data & Analytics
COVID-19 Data Exploration.
Exploring global case, death, and vaccination data in T-SQL, with a query set feeding Tableau.
PublicExploration 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.
T-SQLSQL ServerTableauWindow Functions