CoursinAI
Start learning
All courses
Intermediate$59

AI Data Analysis Lab

Clean a messy spreadsheet, ask answerable questions, audit the calculations, and deliver a chart-led decision note.

7 lessons 4h Intermediate

Course overview

AI can accelerate analysis, but it cannot rescue an unclear question or an untrustworthy table. This lab begins with the sheet itself: structure, definitions, missing values, and the checks that make a conclusion defensible.

What you will build

You will take a small operational dataset from raw rows to a one-page decision note. The work includes a data dictionary, a cleaning log, a validated calculation, an honest chart, and a reproducible handoff.

Inside the lab

  • Reshape a spreadsheet into one row per observation with clear headers.
  • Ask for an analysis plan before asking for an answer.
  • Inspect formulas, generated code, filters, and denominators.
  • Choose a chart that matches the decision—not the prettiest option.
  • Protect sensitive data and neutralize spreadsheet-export risks.

Best for: intermediate learners working in ChatGPT, Excel with Copilot, or similar analysis tools. Python and Copilot availability depend on license and update channel.

Last reviewed September 2026. Lessons cite current OpenAI, Microsoft, NIST, and OWASP documentation.

Your route through the course

Syllabus

7 lessons + knowledge check
  • Make the data usable
    • Reshape the table and write a data dictionary
    • Write an analysis contract
  • Analyze and visualize
    • Analyze with ChatGPT and audit the calculation
    • Use Excel copilots without losing the workbook
  • Audit and communicate
    • Make an honest chart and decision note
    • Capstone: deliver a reproducible analysis
01Understand

One clear idea in ordinary language.

02Practice

Apply it to a realistic situation.

03Build

Finish something useful enough to keep.

04Check

Test quality, safety, and your understanding.