Upload your business metrics and ask AI to write code for analysis to get insights, visualizations, and actionable recommendations.
Tools: ChatGPT (code for analysis), Google Looker Studio (with AI agent), Zebra AI, Claude (Claude for Excel extension), or Gemini (Gemini inside Sheets and AI formulas)
Time required: 30 minutes
Step-by-step instructions
- Export your business data (Google Analytics, sales reports, email metrics, social media insights)
- Save as CSV or Excel file
- Go to chat.openai.com (ChatGPT Plus required) or claude.ai
- Upload your data file
- Use the analysis prompt below
- AI will generate charts, identify trends, and provide recommendations
- Ask follow-up questions to dig deeper
- Export visualizations and insights for your team
Example prompt
You are a data analyst expert. I've uploaded [type of data: sales/website traffic/email campaigns/social media/customer data].My business context:
- Industry: [your industry]
- Business model: [B2B/B2C/SaaS/e-commerce]
- Current goals: [increase sales, improve retention, boost engagement, etc.]
- Time period in data: [date range]
Please analyze this data and provide:- OVERVIEW:
- Key metrics summary
- Overall trends (up, down, stable)
- Any immediate red flags- PATTERNS & INSIGHTS:
- What's working well?
- What's underperforming?
- Unexpected findings
- Seasonal patterns or anomalies- COMPARATIVE ANALYSIS:
- Month-over-month changes
- Top performers vs. bottom performers
- Segment comparisons (if applicable)- VISUALIZATIONS:
- Create 3-5 charts showing the most important trends
- Make them simple and actionable- ACTIONABLE RECOMMENDATIONS:
- 5 specific things I should do based on this data
- Prioritize by impact (high/medium/low)
- Include estimated impact of each action- QUESTIONS TO INVESTIGATE:
- What additional data would help?
- What should I track going forward?Present findings in a clear, executive-summary style. Use plain language, not jargon.
Business benefit: Data-driven companies are 23x more likely to acquire customers and 6x more likely to retain them. AI analysis reduces data analysis time by 80% (from hours to minutes). Companies using AI for analytics report 15-30% improvement in decision quality. Source: McKinsey
Step-by-Step Guide
You are a data analyst. Write Python code to calculate and verify the data, but output charts and insights in the end. Dataset uploaded: [sales/traffic/email/etc] covering [date range] for [business model]. Goals: [list KPIs]. Segments: [channels/regions/products].
Outputs:
1) Executive summary (trend direction + 3 key callouts).
2) KPI table (current vs previous period %, best/worst segments).
3) 3-5 charts (describe) to visualize top insights.
4) Findings: what's working, what's not, anomalies/outliers (with hypotheses).
5) Recommendations: 5 actions ranked by impact/effort with expected metric lift.
6) Questions + data gaps to validate next.
Write plainly; cite exact numbers and timeframes.Recommended Tools
Clean your data first—remove duplicates and fill missing values. Start with simple questions, then go deeper. AI can spot patterns humans miss. Companies that make data-driven decisions see 5-6% higher productivity. Ask 'Why?' at least 3 times when AI finds a trend. Source: MIT Sloan
Export your last 3 months of key business metrics (sales, website traffic, or email performance). Upload to ChatGPT and use this prompt. Implement the top 3 recommendations this week.
