Business question

Can we replace one-off spreadsheets with a repeatable weekly narrative: same structure, fresh numbers?

What we would decide with this

Automate the skeleton of the report (tables, highlights) so stakeholders get consistent timing and definitions; humans still interpret and annotate in review.

Synthetic data

Two CSVs: weekly KPIs (revenue, orders, returns) and a small incidents table. Seed: 42. See demos/repeatable-weekly-report/data/generate.py.

Approach

pandas loads the CSVs; Jinja2 renders src/report.html.j2 using string tables in src/strings_en.json and src/strings_es.json. The script writes English and Spanish variants plus a default report.html (English copy).

Key outputs

Open the generated files in a browser:

• Report (English)
• Report (Spanish)
• Report (default) — same content as English

Reproduce

cd demos/repeatable-weekly-report
python3 data/generate.py
python3 src/run.py

Dependencies: demos/requirements.txt (includes jinja2).