AI for Data Analysis with ChatGPT and Claude
Upload a spreadsheet, ask questions, get charts — safely.
Taught by Niraj Thapa · Analytics Lead
What you'll learn
- Explain how ChatGPT and Claude analyse uploaded files and where each approach breaks
- Prepare a spreadsheet so an AI tool reads it correctly the first time
- Ask analytical questions that produce specific, checkable answers
- Clean duplicates, dates, blanks and inconsistent categories with a documented change log
- Produce presentation-ready charts and summaries and export them
- Verify AI-generated numbers and apply a privacy checklist before uploading any data
About this course
AI for Data Analysis with ChatGPT and Claude is a beginner course for marketers, operations staff, founders, analysts and anyone who lives in spreadsheets but does not write code. You will learn how the data analysis features in ChatGPT and Claude actually work, how to prepare and upload an Excel or CSV file, how to ask questions that produce reliable answers, and how to clean messy data, build pivot-style summaries and generate charts you can paste into a report. A full lesson is devoted to verifying the numbers, because AI makes confident arithmetic mistakes, and another to privacy: what you may and may not upload, how business plans differ from consumer accounts, and how to anonymise data first. No programming is required. By the end you will run a complete analysis from raw export to presentable chart in under an hour, and know exactly when to trust the result.
Course content
7 lessons- 1How AI Data Analysis Works (and Where It Breaks)What happens when you upload a file, why the tools write code behind the scenes, and the failure modes to expect.Preview
- 2Preparing and Uploading Your SpreadsheetTidy data principles, file formats, size limits and the columns to remove before anything leaves your computer.
- 3Asking Good Analytical QuestionsTurn vague curiosity into precise, answerable questions and make the tool explain its method before it computes.
- 4Cleaning Messy Data With AIFix duplicates, inconsistent categories, broken dates and blanks while keeping a change log you can show anyone.
- 5Charts and Summaries You Can PresentChoose the right chart, ask for clean labelled visuals, and turn results into a short summary for a report or deck.
- 6Verifying the NumbersCross-check AI results with filters and pivots, catch the classic mistakes, and make any analysis reproducible.
- 7Privacy, Governance and Working SafelyWhat you may upload, how business and consumer plans differ, anonymising data, and a checklist for your team.