Prompt of the Day: Data Detective — Turn Number Chaos into Clear Insights in 5 Minutes
Sound familiar? You open an Excel spreadsheet with sales figures, website statistics, or survey results and see rows upon rows of numbers. You know there are insights hiding in there somewhere — but where do you start?
The problem: Most people can read data but cannot interpret it. What does a 12% decline in March mean? Is it seasonal or a real problem? Which three clients generate 80% of revenue? Where is the biggest optimization potential?
The solution: Copy your data into an AI and let it review everything like an experienced analyst. You get not just a summary but patterns, outliers, trends, and — most importantly — concrete recommendations for what to do next.
What you can analyze:
- Revenue and sales figures — which products, regions, or time periods stand out
- Website analytics — where visitors come from, where they drop off, what converts
- Survey results — what customers are really saying, what patterns hide in free-text responses
- Budgets and expenses — where the money flows, where overspending occurs
- Project data — which tasks take longer than planned, where bottlenecks exist
- HR data — overtime trends, sick leave rates, turnover rates
Important privacy note: Before pasting sensitive company data into an AI tool, check your company's data privacy policies. Anonymize personal data — replace names with 'Employee A/B/C', remove customer IDs, and use only aggregated values where possible. For confidential business data, use a local AI solution or an enterprise version with data privacy guarantees.
How to proceed:
1. Prepare your data: Copy your table directly from Excel or Google Sheets — AI understands tabular data even without CSV formatting. Or describe the data if you cannot paste it directly.
2. Use the prompt: Copy the prompt below and insert your data.
3. Follow up: If the initial analysis is interesting, ask: 'Go deeper on [point X]' or 'Compare [period A] with [period B]'.
Pro tips:
- Request visualization: 'Describe which 3 charts I should create in Excel to visualize the key insights — with step-by-step instructions.'
- For the C-suite: 'Summarize the results as an executive summary — maximum 5 sentences that even a time-pressed CEO can understand.'
- Dare a forecast: 'Based on the trends: What is the most likely development for the next 3 months? What assumptions are behind it?'
- Cross-check: 'What alternative explanations exist for the trends you found? What might I be overlooking?'
You are an experienced data analyst with a talent for turning numbers into stories. Your task: Analyze my data and deliver clear, understandable insights — no statistics lecture, just plain language with actionable recommendations. **Context:** [Briefly describe what this is about. e.g., 'Sales figures from our online shop for the last 6 months', 'Results from a customer satisfaction survey with 200 respondents', 'Website traffic for the last 90 days from Google Analytics'] **The data:** [Paste your data here — copied directly from Excel, as a table, or as CSV. If the data is too large, paste a representative sample and describe the rest.] **My questions about the data:** [Optional: What do you specifically want to know? e.g., 'Why did revenue drop in April?', 'Which customer segment is most profitable?', 'Are there seasonal patterns?'] --- Analyze the data and deliver: **1. Overview in 3 Sentences** What do the data say at first glance? Summarize the most important points so I can understand them in 10 seconds. **2. The 5 Most Important Insights** For each insight: - **What:** What do the data show? - **Why it matters:** What impact does this have? - **Assessment:** Is this positive, negative, or neutral — and compared to what? **3. Anomalies and Outliers** - Are there data points that fall outside the norm? - Are there unexpected patterns or correlations? - What is missing from the data that would be important for a complete analysis? **4. Trends and Development** - What direction are the key metrics heading? - Are there seasonal or cyclical patterns? - At what point did something change — and what might have triggered it? **5. Action Recommendations** Give me 3 concrete measures, prioritized by impact: - **Do now** (this week): [one quick-win measure] - **Short-term** (next 4 weeks): [one measure with measurable results] - **Strategic** (next quarter): [one larger initiative] **6. Visualization Recommendation** Which 2-3 charts should I create to present the insights to my team or leadership? For each, describe: chart type, X-axis, Y-axis, and what it should show. **Rules:** - Speak plainly, no statistics jargon - If the data basis is too thin for a claim, say so honestly - Clearly distinguish between what the data show and what you suspect - Round numbers sensibly — '43.7%' not '43.712%' - If you need comparison values (industry benchmarks, etc.), mark them as [INSERT BENCHMARK]