AI for your role

AI for Data Analysts

Spend less time writing SQL and building reports, and more time on the questions that change decisions.

Get the Data Analyst brief
The shift

How AI is changing the Data Analyst role

In 2026, AI handles much of the routine work a Data Analyst faces, from turning a plain-language question into SQL to building standard dashboards and cleaning messy data. Language models draft the query, explain the outlier, and turn a chart into a written takeaway. What still rests with the analyst is framing the right question, judging whether a number is trustworthy, and turning findings into a decision the business actually makes.

What AI can take off your plate

  • Writing routine SQL queries from a plain-language question
  • Building and refreshing standard recurring dashboards
  • First-pass data cleaning, joins, and deduplication
  • Generating summary statistics and exploratory charts
  • Turning a finding into a first-draft written summary

What stays distinctly human

  • Framing a vague business question into a measurable analysis
  • Judging data quality and spotting a misleading result
  • Choosing the metric that actually reflects the goal
  • Telling the story so a decision genuinely changes
  • Owning the recommendation and its tradeoffs
Tools

Five AI tools for Data Analysts

ChatGPT (with Advanced Data Analysis)
Upload a CSV and have it profile the columns, flag missing values, and chart your key metric — a fast first pass you then verify.
Try it →
Claude
Great for explaining a surprising result, drafting a clear stakeholder summary, or turning a tangle of numbers into a plain-English narrative.
Try it →
Julius AI
Chat with your spreadsheet or database in natural language to run analyses and build visualizations without writing code.
Try it →
Microsoft Copilot in Excel
Generates formulas, pivots, and charts from a description and explains what a messy sheet is doing.
Try it →
Hex
A collaborative notebook with an AI assistant that writes SQL and Python cells from natural language and builds shareable data apps.
Try it →
Prompts

Five prompts to try today

Paste these into Claude or ChatGPT and replace the bracketed parts with your own details.

1. Write and explain a SQL query
I have tables [describe tables and key columns]. Write a SQL query to answer: [question]. Then explain what the query does step by step and list any assumptions it makes about the data.
2. Stress-test a finding
Here is my finding: [result]. What are the most likely data-quality issues, wrong joins, or confounders that could produce this, and how would I check each one before I present it?
3. Turn a chart into a takeaway
Here is a summary of my data: [paste numbers]. Write a three-sentence takeaway for [audience] that leads with the decision it implies and avoids jargon.
4. Design the right metric
The team wants to measure [goal]. Propose 3 candidate metrics, explain what each captures and misses, and flag how each could be gamed or misread.
5. Debug a broken query
This SQL returns [wrong output/error]: [paste query]. The tables look like [describe]. Find the bug, rewrite it correctly, and explain what went wrong.
The playbook

Every AI play for Data Analysts

The full library of tools, prompts, and tricks for your role — updated every week. Tap any card for a step-by-step walkthrough and examples.

✦  New tools, prompts, and tricks are added every week — and go straight to subscribers in their morning brief. Skip the scrolling and get yours delivered free. Get my free brief →
Loading the library…

A day in your inbox

This is the kind of brief a Data Analyst gets, every weekday morning.
Monday morning
✦ Personalized for: Data Analyst
Today's Tool
Ask an AI to profile a new dataset first
Drop a fresh export into ChatGPT's Advanced Data Analysis and ask it to profile every column, flag nulls, and plot your target metric. You get a starting picture in minutes — just verify the generated code before trusting a number.
Today's Prompt
Make AI argue against your result
Paste a surprising number and ask: "What data-quality issues, leakage, or confounders could produce this, and how do I test each?" It turns a shaky finding into one you can defend.
Today's Trick
Ask for the query's assumptions
When AI writes you SQL, ask it to list every assumption baked into the joins and filters. It surfaces the silent mistakes — wrong grain, dropped rows — before they reach a dashboard.

Get the Data Analyst brief

One AI tool, one prompt, and one trick for Data Analysts, every weekday morning. Free.

Almost there — we just emailed you a confirmation link. Click it to activate your brief.
Free forever. Unsubscribe anytime. We use your role only to personalize your brief.