Professional Certificate in Data Analysis
Run a full analytics project with AI as your analyst — frame the question, clean the data, run the stats, query with SQL, build the dashboard, drive the decision — and verify everything. 40 lessons + capstone.
Why this instead of a traditional degree?
- $4,000-$15,000 for a multi-month bootcamp
- Teaches you to hand-code what AI now drafts in seconds
- Heavy on tool mechanics, light on business judgment
- Generic datasets, no decision to actually drive
- Ends at the certificate; the AI half is missing entirely
- Included with Pro subscription
- One realistic business threads through every module
- Every lesson runs real prompts, then verifies AI's work
- A verification habit that catches AI's confident errors
- Produces a reusable playbook + a capstone you self-score
What you'll learn
Use a vague executive ask to produce a sharp, answerable question and a decision-focused brief — separating the assumed cause from the real outcome
Examine real-world data across the six quality dimensions and fix it — reading AI's cleaning, catching silent row drops, and reconciling to a known total
Distinguish statistical significance from business importance in descriptive statistics and hypothesis tests, and resist causation-from-correlation
Examine a regression, distinguish trend from seasonality, and interpret an A/B test — knowing exactly where analysis ends and data science begins
Use plain-English prompts to query databases, then validate AI's SQL — catching the fanout join by reconciling the total to a known number
Examine chart choices, organize a dashboard as a decision surface, and distinguish misleading visuals — truncated axes, dual axes, cherry-picked ranges
Compose an executive recommendation from a validated finding — the so-what, the Minto pyramid, an honest uncertainty range, and a clear ask
Assess any AI analytics output with the verification habit — reconcile numbers, judge significance, own every causal claim — before it reaches a decision-maker
Build a personal AI-analyst playbook, then run a complete analytics project solo in the capstone and score it against a professional rubric
Two complete analyses + a playbook you keep for every future project.
Curriculum
Orientation — Your Path & Your Workbench
See the full pathway from spreadsheet user to complete analyst and where you stand on it, self-assess your prerequisites honestly, and set up the AI workbench and learn-with-AI method you'll use for the entire program.
Orientation — Your Path & Your Workbench
Portfolio Deliverable: Working AI workbench with an analysis-context block and the learn-with-AI method
Start ModuleThe AI-Augmented Analyst Operating Model
The division of labor that runs the whole program — you frame, AI drafts, you verify — plus where AI fits the analytics lifecycle, the real BI-tool landscape with verified pricing, and the ways AI fails an analyst.
The AI-Augmented Analyst Operating Model
Portfolio Deliverable: Your operating model: tool choice with reasoning + the verification habit
Start ModuleFraming the Question
Meet Northwind Outfitters — the business you'll analyze through Module 8. Turn a vague executive worry into a sharp question, design the decision, map the data you'd need, and cut the interesting-but-irrelevant.
Framing the Question
Portfolio Deliverable: A decision-focused analysis brief: sharp question, decision design, data source map, scope
Start ModuleSourcing, Cleaning & Preparing Data
Real data is messy. Learn the six quality dimensions, find the problems with AI, clean and reshape while reading every step — and reconcile to prove your cleaning didn't quietly break the data.
Sourcing, Cleaning & Preparing Data
Portfolio Deliverable: A cleaned, validated dataset with a documented lineage and a reconciliation check
Start ModuleAnalysis & Applied Statistics
The statistics that matter for decisions — descriptive stats read correctly, the right analysis chosen, hypothesis tests in plain language, and the discipline to tell significance from importance and verify AI's math.
Analysis & Applied Statistics
Portfolio Deliverable: A statistical analysis with the right tests, significance-vs-importance judgment, and verified numbers
Start ModuleDeeper Analysis: Regression, Time & Experiments
The advanced analysis that's still analyst work — reading a regression, separating trend from seasonality, interpreting an A/B test honestly — and the precise line where interpreting a model ends and building one (data science) begins.
Deeper Analysis: Regression, Time & Experiments
Portfolio Deliverable: Regression, forecast, and A/B-test interpretations — plus a clear map of the analysis/data-science boundary
Start ModuleSQL & Querying with AI
The analyst's most-listed technical skill in the age where you describe the need in English and AI writes the SQL. Read and validate what it generates, understand joins and aggregation grain, and reconcile every total to a known number to catch the fanout trap.
SQL & Querying with AI
Portfolio Deliverable: Validated queries with a pre-execution review and a reconcile-to-known-total habit
Start ModuleBI Dashboards & Visualization
Turn analysis into a decision surface leaders actually use — the right chart for the question, the inverted-pyramid layout, building with AI (Copilot, Tableau Agent, Looker, Claude), and catching the misleading visuals that hide the truth.
BI Dashboards & Visualization
Portfolio Deliverable: An honest, accessible retention/performance dashboard with the visualization verification habit
Start ModuleStorytelling, Recommendations & Your Playbook
The analyst's highest-paid skill: turning a validated finding into a decision. The so-what discipline, the Minto pyramid and three audience altitudes, an executive readout with honest uncertainty — and the personal playbook you take to every future analysis.
Storytelling, Recommendations & Your Playbook
Portfolio Deliverable: Your AI-Analyst Playbook: the pipeline's prompts, checklists, and standing rules
Start ModuleCapstone — A Fresh Business Challenge
A fresh business you've never seen — FreshCrate, a meal-kit subscription with a stalled-growth mystery. You run the whole pipeline solo, frame the ambiguous ask, catch the traps, deliver the recommendation, and score your own work against a professional rubric.
Capstone — A Fresh Business Challenge
Portfolio Deliverable: A complete analysis packet on a fresh business, self-scored against the pipeline rubric
Start ModuleYour AI Toolkit
You'll use these AI tools throughout the program — the free tiers cover every exercise.
Your analysis workbench: framing, cleaning, statistics, SQL generation, chart choice, and the executive narrative — with you verifying every step
Free / $20/moData cleaning, descriptive statistics, pivot tables, and the capstone rubric scoring
FreeBuild an AI-assisted dashboard (Looker Studio, free) and safely run + validate AI's SQL (SQLite online / DB Fiddle)
Free tierEvery exercise works with free AI tools. Paid BI-native AI (Power BI Copilot, Tableau Agent, Gemini in Looker Pro) is covered in the tool-landscape and dashboard lessons so you can evaluate them at work — but none are required.
About this program
Data analysis is being rewritten in real time. The mechanical half of the job — writing SQL, cleaning columns, generating charts — is now something you describe in plain English and AI drafts in seconds. But AI is confidently, silently wrong on real data: text-to-SQL accuracy falls from about 86% on clean textbook databases to roughly 10% on messy enterprise schemas, wrong queries run without a single error message, and AI-written narratives attribute causes the data never supports. This program lives in exactly that gap. Across 40 lessons, you’ll learn the operating model that makes AI a genuine force multiplier — you frame, AI drafts, you verify — and apply it to every stage of a real analytics project, from a vague executive worry to a recommendation that drives a decision.
The spine of the program is one progressive analysis: Northwind Outfitters, a mid-sized outdoor-gear retailer whose regional sales feel off. You’ll frame the question behind the worry, clean its messy data, run and interpret the statistics, query it with SQL — catching the fanout join that silently doubles revenue — build the dashboard leaders will actually read, and deliver the recommendation. Every module adds an instrument and a verification check. Then the capstone takes the training wheels off: FreshCrate, a meal-kit subscription whose stalled-growth mystery turns out to be a retention problem masquerading as an acquisition one — analyzed end to end and scored against a professional rubric, entirely on your own.
What makes this program different is its verification spine, and its honesty about what a data analyst is. This is the business-analyst craft — interpreting analyses, framing decisions, and telling the story — not the data-science craft of building predictive models; a dedicated lesson draws that line precisely. AI fails in documented, recurring ways — the silent bad join, significance mistaken for importance, the truncated axis, the confident story with the wrong cause — and every module trains the specific check that catches each one. You graduate with two complete analyses, a personal AI-analyst playbook, and the habit that keeps analysts employable through every tool generation: never shipping a number you haven’t reconciled or a “because” you haven’t verified. Module 0’s pathway map shows where this certificate sits on the road to mastery, with the Master Certification (leading the function) and the Data Science certificate (building models) as the marked next steps.
Prerequisites
Complete these 3 short courses before starting the program. They give you the spreadsheet fluency, analysis vocabulary, and chart basics this program builds on — the program's self-assessment in Module 0 tells you exactly where you stand.
AI-powered formulas, data cleaning, pivot tables, and dashboards in Sheets and Excel — the spreadsheet fluency every module builds on.
Turning raw data into insight — exploration, basic analysis, visualizations, and stakeholder presentation with AI. The vocabulary this program deepens.
Chart selection, dashboard basics, and storytelling with data — the visual foundation the dashboards and storytelling modules sharpen further.
Frequently asked
Do I need specific AI tools or subscriptions?
No. Every exercise works with the free tiers of Claude, ChatGPT, or Gemini, plus a free spreadsheet and free tools like Looker Studio and SQLite online. The dashboard module covers the paid BI-native AI landscape (Power BI Copilot, Tableau Agent, Gemini in Looker) so you can evaluate them at work, but none are required for the program.
Data Analysis vs Data Science — which one is this, and which should I take?
This is Data Analysis — the business-analyst track. The rule that draws the line: you learn to interpret models and analyses (regression, forecasts, A/B tests), frame decisions, query data, build dashboards, and tell the story that drives action. The moment the job becomes building, training, and deploying predictive machine-learning models, that's Data Science — a separate craft, covered by our Professional Certificate in Data Science. Take Data Analysis if you want to answer business questions with data and AI; take Data Science if you want to build predictive models. Module 5 has a dedicated lesson on exactly where the boundary sits.
Is this a coding or a Python bootcamp?
No — and deliberately so. In 2026 you describe what you need in plain English and AI writes the SQL and the analysis; your job is to frame the question and verify the output. You'll paste prompts into AI chat tools and work in spreadsheets and free BI tools. The SQL module teaches you to read and validate queries, not hand-write them from scratch — because validation, not authorship, is the skill that matters now.
I've never formally analyzed data. Can I start here?
Module 0 includes an honest self-assessment with a gap-to-course map. If you score low on spreadsheet fluency or basic AI prompting, it routes you to the three short prerequisite courses first. If you've ever pulled insight from a spreadsheet — even informally — you'll likely clear the bar.
What prerequisites do I need?
Three short courses: AI for Google Sheets & Excel, Data Analysis with AI, and Tell Stories with Data and AI. Together they take about 5 hours. The Module 0 self-assessment tells you whether you can skip any of them. (AI for Databases & SQL is an optional booster before the SQL module.)
What do I actually build during the program?
You analyze one realistic business — Northwind Outfitters, an outdoor-gear retailer with a regional-sales mystery — across Modules 2-8: framing the question, cleaning its messy data, running the statistics, querying it with SQL, building its dashboard, and delivering the recommendation. Then the capstone hands you a completely different business (FreshCrate, a meal-kit subscription) to analyze solo. You finish with two complete analyses plus a personal AI-analyst playbook.
How long does it take to complete?
About 6 weeks at 4 hours per week — roughly 24 hours total, split between ~15 hours of lessons and ~9 hours of hands-on analysis practice. Fully self-paced, and the capstone rewards learners who don't rush it.
Will AI replace data analysts?
The evidence points the other way. AI is absorbing the mechanical work — writing SQL, first-draft cleaning, generating charts — but it's confidently wrong a lot on real data: text-to-SQL accuracy collapses from ~86% on clean data to ~10% on real enterprise schemas, and wrong queries run silently. That shifts the analyst's value to framing, judgment, and verification — catching the errors AI can't see it's making. This program trains exactly that combination, which is why it's more durable than the tool skills alone.
What makes this different from the Data Analysis with AI course?
The course teaches individual skills in about 2 hours — basic analysis, exploration, presentation. This program integrates everything into a working system across 40 lessons: a full analytics pipeline on a realistic business, applied statistics you interpret correctly, SQL you validate, dashboards you make honest, a recommendation that drives a decision, and a capstone you run solo. It's the difference between knowing the pieces and having run a complete project with them.
Is the certificate recognized by employers?
The certificate carries a verifiable credential ID. More practically, the program produces artifacts you can show — a cleaned dataset with a reconciliation, a statistical analysis, a validated SQL workflow, an honest dashboard, an executive recommendation, and a capstone scored against a professional rubric. In interviews, walking through how you caught an AI fanout join that doubled revenue lands harder than any certificate line.
Do I need to know statistics already?
No. The program teaches the statistics that matter for decisions — reading them correctly, telling significance from importance, and resisting causation-from-correlation — at an interpretation level, not a derivation level. There are no proofs or matrix calculus (that's the data-science side). If a task genuinely required calculus, you'd be on the data-science track; here, you interpret, and AI computes while you verify.
I'm a working analyst already. What's in this for me?
The AI layer, systematized, plus the verification discipline. Most working analysts use AI casually. This program gives you the full operating model: where AI fits each pipeline stage, its documented failure modes (the silent fanout join, the confident-but-wrong narrative, the misleading chart it picked), and the verification habit that catches each one — plus a playbook that turns scattered prompting into a repeatable system, and the storytelling frameworks (Minto, so-what, three altitudes) that get your work acted on.
What comes after the certificate?
Two directions. To go deeper in the analyst craft toward leadership — governing an org's metrics layer, running experimentation programs, leading an analytics function — the pathway continues to the Master Certification tier. To learn to build predictive models, the Professional Certificate in Data Science is the sibling track. Module 0 shows you the full map, and the capstone's final lesson marks exactly where you stand and both next climbs.