- The AI Operator Weekly
- Posts
- Meet your new data analyst, ChatGPT
Meet your new data analyst, ChatGPT
How to make data-driven decisions in 15 minutes

AI Operators,
This week’s theme is all about human + AI collaboration. A new benchmark shows that AI still can’t match human quality on complex freelance projects — and that’s reassuring news. It means the future belongs to those who know how to work with AI, not compete against it.
And if you’ve ever wished for a data analyst on your team, this week’s guide shows you how ChatGPT can fill that gap by instantly turning your spreadsheets into charts, insights, and ready-to-share reports.
Updates:
🔗 Sign up for this week's live session: Top 10 AI Tools Every Business Needs — happening Friday, 7 November. We’ll discuss the 10 must-have AI tools, explaining what each one does and when to use it.
Today at a glance:
Why “human + AI” is the winning formula
This week’s guide: Data analysis made easy with ChatGPT
Watch my video on building custom GPTs that save time and money
Tools of the week: Voice AI that laughs, Gemini’s Canvas, and a security system for AI agents.
News:
Freelance project research shows AI enhances, doesn’t replace human skills.
A new benchmark from Scale AI and the Center for AI Safety tested top AI models on 240 real freelance projects from Upwork and found that even the best systems only met professional standards in under 3% of cases.
At first glance, that might sound like a setback. But it’s actually great news for anyone wondering where humans fit into an AI-powered future.
The findings show that while AI can generate drafts, designs, and data quickly, it still struggles with complex deliverables that require context, creativity, and quality control — areas where humans excel. In other words, AI isn’t replacing skilled professionals; it’s amplifying them.
The takeaway? Don’t measure AI vs. human performance — measure what’s possible when it’s human + AI working together. That’s where the real productivity gains happen.
Link to the research: https://arxiv.org/pdf/2510.26787
Guide: Data Analysis with ChatGPT
With ChatGPT’s Data Analysis you can instantly turn your data into insights, visuals, and summaries, without any coding skills required.
Simply upload your file, ask questions in plain English, and ChatGPT will run Python code behind the scenes to analyze, visualize, and explain your data.
🧮 What ChatGPT can do
ChatGPT can:
Run calculations, regressions, and simulations
Create static and interactive charts
Summarize patterns, trends, and key takeaways
Handle large datasets (up to 512 MB per file)
Work with up to 10 files per conversation
It becomes your friendly data analyst who speaks plain English and makes complex info digestible.
Step 1: Import your data
ChatGPT supports the most common data formats:
File Type | Extension / Source |
|---|---|
Excel |
|
CSV |
|
| |
JSON |
|
Cloud | Google Drive, Microsoft OneDrive, SharePoint |
✅ Best practices when preparing data
Include clear column headers in the first row
Use simple, descriptive labels
Keep one record per row
🚫 Avoid
Merging multiple tables into one sheet
Leaving blank rows or columns
Embedding key data inside images
🔒 File limits & retention
Up to 10 files per chat
Maximum 512 MB per file (for spreadsheets, ~50 MB is a practical limit)
Files are stored only within the chat and deleted if you delete the conversation or after a short retention period
You can remove uploads manually at any time
Feature availability: Data Analysis is included in ChatGPT Plus, Teams, and Enterprise plans.
Step 2: How ChatGPT interprets your data
Behind the scenes, ChatGPT:
Reads your file to detect its structure.
Generates Python code to perform your request.
Executes that code in a secure, sandboxed environment (no internet access).
Returns the results as text, tables, or charts.
Each analysis runs in its own isolated session with limited runtime resources — deleted automatically when the conversation or workspace is cleared.
Step 3: Ask for insights
Extract specific insights from your data—all you have to do is ask.
Try natural-language prompts like:
“Which region had the highest sales growth this year?”
“Create a bar chart comparing revenue and expenses.”
“Run a correlation between ad spend and conversions.”
ChatGPT can also summarize findings in plain English or create quick executive summaries for reports.
Step 4: Visualize your data
Behind the scenes, ChatGPT uses Python tools to handle your data:
pandas — a powerful data tool that organizes and analyzes tables of information (like an advanced version of Excel).
Matplotlib — a chart-making tool that turns your data into visual graphs and plots.
ChatGPT automatically picks a suitable chart type — or you can ask for a specific one.
You can switch between static and interactive charts using the toggle in the top-right corner.
Interactive chart types include bar, line, scatter, and pie charts.
Click “View Analysis” under any result to see or copy the Python code ChatGPT generated.
Turn on “Always show details” if you’d like to see the code every time.
🚀 Quick-start example
Upload your dataset (.csv, .xlsx, or .json).
Ask: “Analyze this dataset and show the top 5 products by profit margin”
Click View Analysis to inspect or reuse the code.
Switch to interactive chart to explore results.
Save visuals or summaries for your report or presentation.
🧠 Try this prompt:
I've uploaded a CSV with monthly revenue and ad spend.
Create an interactive line chart showing both over time, then calculate the ROI by month.
Media:
Imagine saving $50,000 on consulting, data analysis, and project management by building five simple AI assistants in less than 30 minutes.
In my latest YouTube video, I show you step-by-step how to set them up and integrate them into your business using platforms like OpenAI, Notion, and Google Drive.
Watch it here:
Tools of the week:
Cartesia: Text to speech voice AI that laughs, emotes, and pulls you into a conversation.
Google Canvas: Create or edit a doc, app, presentation, or code.
Auth0: A secure, developer-friendly platform for authentication and authorization that lets you add login, signup, and access control to apps.
TL;DR:
AI is powerful but not perfect, and humans still set the standard.
Join our live session on Friday 7th November: Top 10 AI Tools for Business.
Guide: ChatGPT’s Advanced Data Analysis makes data exploration effortless.
Watch my latest video on building custom GPTs that save you $$$.
Tools of the week: Cartesia, Google Canvas, Auth0.