Data Analytics with AI
Use ChatGPT, Claude, Excel Copilot, Power BI Copilot and Tableau GPT to do real data analyst work at 5× the speed. The course every working analyst — and every aspiring one — needs in 2026.
Who this course is for
Working data analysts who are tired of doing the same VLOOKUP for the 200th time. Finance, marketing, ops and product analysts who want to know which AI tools save real time (and which are a marketing demo). Students preparing for data analyst roles who want to walk into the interview with a 2026 toolkit, not a 2022 one.
This course assumes you already know what a pivot table is and have written at least one SQL query. If you don't, start with our free SQL course and Excel course first — both are linked here.
What you'll be able to do at the end
- Drop a 100,000-row CSV into ChatGPT and get a usable summary, chart and outlier report in 5 minutes
- Generate, debug and refactor SQL queries with Claude and ChatGPT — across MySQL, Postgres, BigQuery dialects
- Use Excel Copilot and Google Sheets AI for everyday cleanup and analysis
- Get correct DAX out of Power BI Copilot the first time (with the prompt patterns that work)
- Recognise AI hallucinations in numerical reasoning before they ship to stakeholders
- Build one full reproducible end-to-end analytics report on a real public dataset as a capstone
Full syllabus
Week 1
- The job has not changed. The workflow has. — 2026 analyst stack overview
- Upload your first CSV to ChatGPT — what Code Interpreter actually does under the hood
- The 5 prompt formulas that get useful results: "summarise", "find outliers", "compare", "trend", "join"
- Claude with file attachments — when it's better than ChatGPT and when it's not
- When AI is wrong about your data — three failure modes and how to spot them in 30 seconds
- Mini-project: full first-pass analysis of a public Indian sales dataset (kaggle.com source)
Week 2
- Excel Copilot end-to-end — formulas, charts, pivot tables, summaries
- Google Sheets "Help me organise" + Gemini in Sheets — the free alternative
- Generating pivot tables with natural language — and the cases where it gives you the wrong shape
- Forecast and trendline with AI — Excel's built-in time series + when to fall back to Python
- Mini-project: build a monthly KPI report in 20 minutes (was a half-day job pre-AI)
Week 3
- Generate SQL from natural language — Claude, ChatGPT, and the schema-context prompt pattern
- Debug a broken SQL query with AI — paste the error, get the fix, understand why
- Power BI Copilot for DAX — the prompt patterns that produce correct measures the first time
- Tableau GPT and Tableau Pulse — natural-language exploration of published dashboards
- Mini-project: build a sales dashboard end-to-end using ChatGPT for SQL + Power BI Copilot for DAX + AI for the writeup
Week 4
- When to trust AI in production analysis — the four-question checklist before any number ships
- Catching numerical hallucinations — why LLMs are bad at maths and the patterns to spot it
- Documenting an AI-assisted analysis for auditability — prompts, model version, manual checks
- "Do you use AI?" — what to actually say in interviews (the honest answer, not the safe one)
- Capstone: a reproducible end-to-end analytics report on a real public dataset, with a written methodology readers can audit
What we promise (and what we don't)
Honest scope
This course teaches you to use AI as a force multiplier on top of analyst skills you already have. It does not replace SQL, Excel or statistics — it makes you 5× faster at the parts of those skills that you already understand. If you can't read a pivot table today, AI is not going to fix that for you, and we will be honest about that in lesson 1.
We test every claim in this course on real data. When a tool fails on a specific kind of question (and they all fail on something), we show you the failure and the workaround, not just the happy path.
Weeks 1, 2 and 3 are live now.
Week 1 — ChatGPT & Claude for data exploration, Week 2 — AI inside Excel and Google Sheets, and Week 3 — SQL, Power BI and Tableau with AI are all live. 18 lessons, 130+ interactive blocks, en+hi narration, real prompt formulas, real failure-mode hunting, three mini-projects (Indian e-commerce dataset → 20-minute KPI report → 90-minute end-to-end sales dashboard with methods box). Sign up and open the course →
Week 4 (production patterns + interview prep — the capstone week) ships within the next 3 weeks.
The fastest way to know when each week ships is the community WhatsApp group. We post in there the moment new lessons go live.
Related courses (live today)
- SQL for Data Analysts — write and run real queries in your browser, prerequisite for Week 3.
- Excel & Spreadsheets for Jobs — pivot tables, VLOOKUP, dashboards. Useful before Week 2.
- Power BI for Data Analysts — Power Query, data model, DAX. Useful before Week 3.
- Tableau for Data Analysts — first chart to published dashboard. Useful before Week 3.