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

.xlsx

CSV

.csv

PDF

.pdf

JSON

.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:

  1. Reads your file to detect its structure.

  2. Generates Python code to perform your request.

  3. Executes that code in a secure, sandboxed environment (no internet access).

  4. 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

  1. Upload your dataset (.csv, .xlsx, or .json).

  2. Ask: “Analyze this dataset and show the top 5 products by profit margin”

  3. Click View Analysis to inspect or reuse the code.

  4. Switch to interactive chart to explore results.

  5. 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: