Automated Reporting System Builder

Design an automated reporting system for [BUSINESS/TEAM].

Reports needed: [LIST REPORTS]
Recipients: [WHO GETS EACH REPORT]

Frequency: [DAILY / WEEKLY / MONTHLY]

Provide:
1. **Report Specifications**: For each report:
   - Metrics included
   - Data sources
   - Visualizations
   - Comparison periods
   - Commentary requirements
2. **Automation Architecture**: Tools and workflow (SQL → Python → Email/Slack/PDF)
3. **Data Pipeline**: Queries that power each report
4. **Template Design**: Layout and formatting for each report type
5. **Scheduling**: Cron jobs or orchestration setup
6. **Distribution**: How reports reach recipients (email, Slack, dashboard link)
7. **Error Handling**: What happens when data is missing or pipeline fails
8. **Self-Service**: How recipients can drill deeper on their own
9. **Maintenance**: Monthly review process to keep reports relevant
10. **Code**: Complete implementation for the highest-priority report

Design an automated reporting system for [BUSINESS/TEAM].

Reports needed: [LIST REPORTS]
Recipients: [WHO GETS EACH REPORT]
Frequency: [DAILY / WEEKLY / MONTHLY]

Provide:
1. **Report Specifications**: For each report:
   - Metrics included
   - Data sources
   - Visualizations
   - Comparison periods
   - Commentary requirements
2. **Automation Architecture**: Tools and workflow (SQL → Python → Email/Slack/PDF)
3. **Data Pipeline**: Queries that power each report
4. **Template Design**: Layout and formatting for each report type
5. **Scheduling**: Cron jobs or orchestration setup
6. **Distribution**: How reports reach recipients (email, Slack, dashboard link)
7. **Error Handling**: What happens when data is missing or pipeline fails
8. **Self-Service**: How recipients can drill deeper on their own
9. **Maintenance**: Monthly review process to keep reports relevant
10. **Code**: Complete implementation for the highest-priority report