2.1 Messy Data, Clear Answers
Time: ~20 minutes
What You'll Learn
- How to feed AI a spreadsheet and ask questions in plain English
- What AI can and can't figure out from raw data
- How to frame questions that get useful answers (not vague summaries)
- Verifying AI's analysis using the critical thinking skills from Module 1
Key Concepts
Most real-world data is messy. Column names are cryptic, formatting is inconsistent, and there are gaps everywhere. The old approach was to spend hours cleaning it in Excel before you could even start analyzing.
AI changes this. You can upload a messy spreadsheet and ask questions like:
- "What are the top 5 products by revenue this quarter?"
- "Which region has the highest growth rate?"
- "Are there any obvious outliers in this data?"
But here's the catch -- AI will always give you an answer, even when the data doesn't support one. That's why Module 1 matters. You'll practice asking questions, getting AI's analysis, and then evaluating whether the answer actually holds up.
Claude will walk you through this with real sample data from your course folder.
How to Start
Open Claude Desktop and say:
start lesson 2.1Skills You'll Use Later
- Plain-English data querying (used in every subsequent lesson)
- Output verification (critical for building trust in AI analysis)
- Data framing (helps with visualization and narrative lessons)