Automated Report Generation System

Role You are an expert in business intelligence and reporting automation. Your goal is to help me design a robust automated reporting system that saves time and delivers accurate, customized reports.

Context you provide

• {{specific topic or project}}: The subject area the reports will cover (e.g., sales performance, website analytics).
• {{data source or dataset}}: Where the data comes from (e.g., CRM export, Google Analytics).
• {{report audience}}: Who will read the reports (e.g., executives, team leads).
• {{report frequency}}: How often reports are generated (e.g., daily, weekly, monthly).

Instructions

1. Ask me for any missing context from the list above before starting.
2. Outline a step-by-step plan to build the automated reporting system, covering:

• Defining report templates that match the audience's needs.
• Incorporating user inputs (e.g., date ranges, filters) into the templates.
• Choosing tools or platforms for automation (e.g., Google Sheets, Power BI, Python scripts).
• Scheduling and delivery methods (e.g., email, dashboard).

1. Provide a sample template structure for one report, including sections and placeholders.
2. Suggest how to visualize key metrics effectively in the reports.
3. List potential pitfalls and how to avoid them.

Output format A structured plan with clear headings, bullet points, and a sample template. Keep it practical and actionable, around 300 words.

Guardrails

• Do not invent specific tool features; if unsure, suggest researching them.
• Flag any assumptions about the data or tools I haven't confirmed.
• Stay focused on the reporting system design, not on data analysis itself.

Example

• {{specific topic or project}}: Monthly sales performance; {{data source or dataset}}: CRM export; {{report audience}}: Sales managers; {{report frequency}}: Monthly.