Exploring the Vax Potential
A real-time interactive dashboard for Viriginia COVID-19 case reports and vaccinations with end-to-end data collection, storage, and processing pipeline
The goal of this project is to built an end-to-end data storage and processing pipeline that created a dashboard to visualize Virginia COVID-19 case reports and vaccinations with real-time data . The impact of this project is to provide a user-friendly interactive dashboard that allows users to visualize both real-time COVID-19 case reports and vaccinations. The pipeline created was able to collect data from API, store data in SQL database and preprocess data, and was automated with cron job for real-time data. The data were then used to build a Dash dashboard app . The web app dashboard consists of two main components: State overview and County summary.
Tools
- API
- SQL
- Python (sqlalchemy, Numpy, Pandas)
- Plotly
- Dash
- Heroku
- cronjob
Techniques/Algorithms
- Designing ETL Pipeline
- Automation for real-time data
- Interactive Dashboard
Application Usage
To Learn More, Check Out My:
Note: The app can take awhile to load... please be patient :)