.webp&w=3840&q=100)
Industry
healthcare
Skills
approach
quality
Tools
excel
sql
python
power-bi
Learning Objectives
Apply data wrangling, cleaning, and modeling techniques to real-world healthcare datasets.
Identify and track critical COVID-related KPIs across regions using effective visualizations.
Learn to build an end-to-end data analysis pipeline using Excel, SQL, Python, and Power BI.
Develop a decision-support dashboard to guide government-level strategic responses.
Overview
In this scenario, you will step into the role of a data expert supporting the U.S. Department of Health in analyzing the impact of the COVID-19 pandemic on healthcare infrastructure. You'll collect, clean, and integrate multi-source data to uncover patterns in high-risk zones, recovery trends, and system vulnerabilities. Using tools like Excel, SQL, Python, and Power BI, you will create dynamic dashboards that empower government officials with insights to make timely and informed decisions. This hands-on project simulates a real-world public health analytics use case, combining data wrangling, modeling, and storytelling for maximum impact.
Prerequisites
- Working knowledge of Excel functions for data exploration and formatting.
- Experience in writing SQL queries for data retrieval and aggregation.
- Understanding of Python for data cleaning and manipulation using libraries like pandas.
- Familiarity with Power BI for building interactive visual dashboards.