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