ChatGPT Treats Uploaded JSON as Plain Text Instead of Structured Data
Upload a JSON file expecting ChatGPT to query keys and aggregate values. It instead reads the file as a wall of text and answers by string-matching.
#Data analysis
Articles tagged with #Data analysis
Write the A/B Test Summary With AI
Turn a finished A/B test into a 1-page summary with winner, lift, CI, segment caveats, novelty risk, and a clean ship/hold/kill decision.
AI Budget Narrative: Stakeholder-Ready Story from a Spreadsheet
Turn a finalised budget into a 300-word narrative that names variances, justifies investments, and surfaces risks — the document leadership actually reads.
How to Use AI to Analyse Business Data: From Operational Noise to a 'So What'
Analyse operational data (support tickets, sales calls, web analytics) with AI — one-line answer, three supporting data points, one caveat, and the next analysis to run.
How to Use AI to Explain a Chart or Table: Three Captions a Stranger Can Act On
Generate three caption variants for a chart or table — descriptive, interpretive, actionable — and a 'common misreading' callout so your reader does not draw the wrong conclusion.
Write Chart Takeaways With AI: Turn a Screenshot into a Tight Caption Fast
Use AI to turn each chart in your deck into a 2-sentence takeaway that names the pattern and the implication — not just describes the bars.
How to Use AI for Competitor Analysis: A Structured Teardown from Public Web Data
Assemble a structured competitor analysis with AI — positioning, pricing, GTM motion, strengths, vulnerabilities — plus a fact-check pass that catches invented claims.
AI Competitor Comparison Tables: Build a Credible Matrix Without Hallucinated Facts
A workflow for using AI to assemble side-by-side competitor comparisons that hold up under scrutiny, surface real gaps, and feed strategy decisions.
Write a Dashboard Takeaway With AI
Post a 4-line weekly Slack takeaway your team actually reads — not 'here is the dashboard link.' Lead with what moved, name the cause, surface one surprise, ask the right question.
AI A/B Test Interpretation: Significance, Effect Size, Validity
Read A/B test results with AI as a critical analyst: significance, effect size, sample-size sanity check, validity threats, and the right next action.
How to Use AI to Summarise a 10-K or Annual Report: One-Page Brief for Non-Investors
Compress a 200-page 10-K into a one-page brief — business model, revenue mix, risks, opportunities, soft-pedalled warnings — tailored to your reader's lens.
How to Use AI for Financial Trend Analysis: Spot Revenue, Cost, Margin Shifts
An analyst's workflow for using AI to surface trends, anomalies, and hypotheses in monthly financial data — the inputs, the prompt, the validation checks, and where AI tends to mislead.
Read Out a Funnel Analysis With AI
Identify the step with the biggest gap vs benchmark — not the biggest absolute drop — and surface the one test that has the highest expected ROI, plus the tests not worth running.
Write the Narrative Around Your KPI Movement With AI
Move from 'activation is up 4 points' to 'here is what likely caused it, here is what is still unknown, and here is what data would resolve the ambiguity' — without overclaiming.
Write a Weekly KPI Summary With AI: Numbers In, Executive-Ready Summary Out
Use AI to turn the week's metrics into a sharp KPI summary — TL;DR, 3 wins, 3 risks, and one ask — without losing the narrative.
AI KPI Weekly Report: From Raw Metrics to Comparisons, Callouts, and Narrative
Turn this week's KPI table into a 200-word weekly report with grounded hypotheses, anomaly callouts, and a single 'thing to watch' — in the time it takes to refill your coffee.
AI Organize Market Research
Turn 20+ pages of competitor teardowns and customer-interview notes into a sharp competitive-landscape doc with segments, real gaps, and a named kill-switch assumption — by Thursday.
How to Compress Market Research Into a One-Page Brief With AI
Turn five PDFs and a folder of slides into a decision-ready one-pager with market size, trends, risks, and a recommendation.
AI Qualitative Coding: Code Interview Transcripts Like a Trained Researcher
Use AI to apply open and axial coding to qualitative transcripts at scale, with reliability checks that catch hallucinated codes before they reach your analysis.
Read Out a Retention Cohort Table With AI
Turn a 12 × 12 retention cohort grid into a 3-sentence leadership readout that names the actual problem — week-1 direction, long-tail shape, and the one outlier cohort worth digging into.
AI Survey Open-End Analysis: Cluster 500+ Free-Text Answers Into Real Themes
A repeatable workflow for using AI to cluster open-ended survey responses, extract verifiable themes, and avoid the trap of cherry-picked quotes.
AI Interprets Survey Results
Turn 200 survey responses into a one-page narrative organized by the 2-3 decisions the survey was meant to inform — with verbatim quotes, prior-contradiction flags, and an honest 'too thin to conclude' section.
How to Use AI to Explain a Complex Table: Turn Dense Data into a Reader Digest
Compress a packed table into a one-paragraph plain-English summary plus three 'what to do with this' bullets — without re-listing the cells.
How to Cluster User Feedback With AI Into Action-Ready Themes
Turn hundreds of app reviews, NPS comments, or support tickets into 5-10 themes a PM can act on this sprint.
ChatGPT Data Analysis Workflow — Real Numbers, Not Vibes
Advanced Data Analysis turns ChatGPT into a real Python notebook. Here is how to use it without getting fooled by pretty charts.
ChatGPT File Analysis Workflow — PDFs, Spreadsheets, and Docs
A repeatable workflow for getting answers out of files instead of paraphrases.
Excel / Spreadsheet Analysis Prompts
11 prompts that feed AI schemas and aggregates instead of 5,000 raw rows — clean columns, outlier hunts, pivots, narrative reports, formula explainers, sanity audits.