How chia-chang/covid-analytics-automation works
This repository is a notebook-based COVID analytics and reporting workflow. It generates synthetic raw data, cleans and integrates it, calculates standardized trend and burden metrics, then produces charts and a multi-sheet Excel report for decision-makers. The README documents these stages and their data handoffs; no source excerpts were provided, so the graph does not infer finer-grained calls or notebook internals.
Main entry points: Automated_Reporting.ipynb Automated Reporting · Data_Cleaning_and_Integration.ipynb Cleaning and Integration · charts Executive Visualizations · COVID_Report_20251113.xlsx Multi-sheet Excel Report
Components 9
Data Integration
- Cleaning and Integration
notebooks/Data_Cleaning_and_Integration.ipynb - Synthetic Raw Data
data/raw/covid_raw_data.csv - Integrated Dataset
data/processed/covid_integrated_data.csv
Metric Analysis
- Standardized Metrics
notebooks/Data_Cleaning_and_Integration.ipynb - Report Metrics
notebooks/Automated_Reporting.ipynb
Reporting Outputs
- Automated Reporting
notebooks/Automated_Reporting.ipynb - Executive Visualizations
outputs/charts - Multi-sheet Excel Report
outputs/reports/COVID_Report_20251113.xlsx
Other components
- Decision-makers
Connections 9
- Cleaning and Integration → Synthetic Raw Data: generates
README.md - Cleaning and Integration → Standardized Metrics: calculates
README.md - Cleaning and Integration → Integrated Dataset: exports
README.md - Automated Reporting → Integrated Dataset: loads
README.md - Automated Reporting → Report Metrics: calculates
README.md - Automated Reporting → Executive Visualizations: generates
README.md - Automated Reporting → Multi-sheet Excel Report: produces
README.md - Executive Visualizations → Decision-makers: presents trends
README.md - Multi-sheet Excel Report → Decision-makers: summarizes metrics
README.md