# chia-chang/covid-analytics-automation architecture

> Architecture diagram of the GitHub repository chia-chang/covid-analytics-automation, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-22). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/chia-chang/covid-analytics-automation
- Repository: https://github.com/chia-chang/covid-analytics-automation

## Overview

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: [`notebooks/Automated_Reporting.ipynb`](https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Automated_Reporting.ipynb) (Automated Reporting), [`notebooks/Data_Cleaning_and_Integration.ipynb`](https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Data_Cleaning_and_Integration.ipynb) (Cleaning and Integration), [`outputs/charts`](https://github.com/chia-chang/covid-analytics-automation/tree/main/outputs/charts) (Executive Visualizations), [`outputs/reports/COVID_Report_20251113.xlsx`](https://github.com/chia-chang/covid-analytics-automation/blob/main/outputs/reports/COVID_Report_20251113.xlsx) (Multi-sheet Excel Report)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_integration["Data Integration"]
  node_cleaning_notebook["Cleaning and Integration"]
  node_raw_data[("Synthetic Raw Data<br/>[covid_raw_data.csv]")]
  node_processed_data[("Integrated Dataset")]
end

subgraph group_analytics["Metric Analysis"]
  node_metric_calculation["Standardized Metrics"]
  node_report_metrics["Report Metrics"]
end

subgraph group_reporting["Reporting Outputs"]
  node_reporting_notebook["Automated Reporting"]
  node_visualizations["Executive Visualizations"]
  node_excel_report["Multi-sheet Excel Report"]
end

node_decision_makers(("Decision-makers"))

node_cleaning_notebook -->|"generates"| node_raw_data
node_cleaning_notebook -->|"calculates"| node_metric_calculation
node_cleaning_notebook -->|"exports"| node_processed_data
node_reporting_notebook -->|"loads"| node_processed_data
node_reporting_notebook -->|"calculates"| node_report_metrics
node_reporting_notebook -->|"generates"| node_visualizations
node_reporting_notebook -->|"produces"| node_excel_report
node_visualizations -->|"presents trends"| node_decision_makers
node_excel_report -->|"summarizes metrics"| node_decision_makers

click node_cleaning_notebook "https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Data_Cleaning_and_Integration.ipynb"
click node_raw_data "https://github.com/chia-chang/covid-analytics-automation/blob/main/data/raw/covid_raw_data.csv"
click node_processed_data "https://github.com/chia-chang/covid-analytics-automation/blob/main/data/processed/covid_integrated_data.csv"
click node_metric_calculation "https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Data_Cleaning_and_Integration.ipynb"
click node_reporting_notebook "https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Automated_Reporting.ipynb"
click node_report_metrics "https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Automated_Reporting.ipynb"
click node_visualizations "https://github.com/chia-chang/covid-analytics-automation/tree/main/outputs/charts"
click node_excel_report "https://github.com/chia-chang/covid-analytics-automation/blob/main/outputs/reports/COVID_Report_20251113.xlsx"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_cleaning_notebook,node_raw_data,node_processed_data toneBlue
class node_metric_calculation,node_report_metrics toneAmber
class node_reporting_notebook,node_visualizations,node_excel_report toneMint
class node_decision_makers toneIndigo
```

## Components

### Data Integration

- [Cleaning and Integration](https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Data_Cleaning_and_Integration.ipynb): `notebooks/Data_Cleaning_and_Integration.ipynb`
- [Synthetic Raw Data](https://github.com/chia-chang/covid-analytics-automation/blob/main/data/raw/covid_raw_data.csv): `data/raw/covid_raw_data.csv`
- [Integrated Dataset](https://github.com/chia-chang/covid-analytics-automation/blob/main/data/processed/covid_integrated_data.csv): `data/processed/covid_integrated_data.csv`

### Metric Analysis

- [Standardized Metrics](https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Data_Cleaning_and_Integration.ipynb): `notebooks/Data_Cleaning_and_Integration.ipynb`
- [Report Metrics](https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Automated_Reporting.ipynb): `notebooks/Automated_Reporting.ipynb`

### Reporting Outputs

- [Automated Reporting](https://github.com/chia-chang/covid-analytics-automation/blob/main/notebooks/Automated_Reporting.ipynb): `notebooks/Automated_Reporting.ipynb`
- [Executive Visualizations](https://github.com/chia-chang/covid-analytics-automation/tree/main/outputs/charts): `outputs/charts`
- [Multi-sheet Excel Report](https://github.com/chia-chang/covid-analytics-automation/blob/main/outputs/reports/COVID_Report_20251113.xlsx): `outputs/reports/COVID_Report_20251113.xlsx`

### Other components

- **Decision-makers**

## Connections

- Cleaning and Integration → Synthetic Raw Data: generates (evidence: `README.md`)
- Cleaning and Integration → Standardized Metrics: calculates (evidence: `README.md`)
- Cleaning and Integration → Integrated Dataset: exports (evidence: `README.md`)
- Automated Reporting → Integrated Dataset: loads (evidence: `README.md`)
- Automated Reporting → Report Metrics: calculates (evidence: `README.md`)
- Automated Reporting → Executive Visualizations: generates (evidence: `README.md`)
- Automated Reporting → Multi-sheet Excel Report: produces (evidence: `README.md`)
- Executive Visualizations → Decision-makers: presents trends (evidence: `README.md`)
- Multi-sheet Excel Report → Decision-makers: summarizes metrics (evidence: `README.md`)
