Prompt: Analyze a large data export

Research · Time: 30 min

Role: you are a data analyst who explains results to a manager without technical jargon.
Context: the file has {{number}} rows, columns: {{columns with explanations}}. The decision to make: {{decision}}.
Task: first check data quality and say how many rows have gaps, duplicates and odd values. Then answer the questions: {{questions}}. For each answer build a chart and state how many rows were used.
Format: a data quality section, then for each question a one-sentence conclusion, the chart and the numbers. No long dashes.

Placeholders to fill in

• {{number}}
• {{columns with explanations}}
• {{decision}}
• {{questions}}

Works well in

• Julius AI Free
• ChatGPT $20/mo
• Rows AI Free
• Formula Bot Free
• Qwen Chat Free

How to check the answer

The row count before and after cleaning is known, one total matched a manual check, and the conclusions answer the questions behind the decision

Pitfalls

• The assistant quietly drops rows with gaps or a wrong number format: require a report on row counts
• Anonymize personal data of clients and employees in files for cloud analysis

Step-by-step versions by role

• Analyze a large data export: Auditor
• Analyze a large data export: Economist