Teacher’s Edition
Module 07
Documents, Data, and Artifacts
Working with files: CSVs, contracts, handbooks, financial data. A messy 50-row CSV that takes an hour to analyze by hand. Claude finds the anomalies in under a minute, if you ask the right way.
Charter Oak Strategic Partners · Claude Mastery Program · Version 1.0 · Confidential · Not for distribution to participants
Everything before this module was text-in, text-out. This module introduces the work that occupies most business hours: files. CSVs, contracts, handbooks, financial data. Claude reads uploaded files, analyzes their contents, compares documents, finds patterns in data, and produces formatted outputs. For participants who think of Claude as a writing assistant, this is the module that recategorizes it as a business analyst.
The productivity claim becomes concrete here. Analyzing a messy 50-row CSV by hand takes an hour. Claude does it in under a minute. Reading a 20-page contract for dollar amounts takes 45 minutes. Claude does it in 30 seconds. The savings are not marginal. They are order-of-magnitude.
Opening — 5 minutes
“Claude reads files. CSV data, text documents, PDFs, code files, images. You upload them. Claude analyzes them. This changes what is possible.”
“Two things to know. First: Claude reads what you upload. It does not have access to your hard drive, your email, or your databases. You hand it the file, and it works with what you gave it. Cowork, which we cover in Module 10, changes this. But for now, it is upload-based.”
“Second: the quality of the analysis depends on the quality of the prompt. ‘What can you tell me about this data’ produces a description of the columns. ‘Identify the three largest revenue drivers, flag data quality issues, and format the output as an executive briefing’ produces an analysis you can send to your boss. Same file. Same tool. Different prompt. Different result.”
Live Demo: The Messy CSV — 20 minutes
demo-data/module-07/quarterly-sales-messy.csv— 51 rows of Q4 2025 sales data with intentional quality issues.demo-data/module-07/data-detective-exercise.md— Exercise instructions, expected findings, key metrics.The CSV contains deliberate problems that Claude should catch. Blank units_sold fields in several rows. A deal marked as “Pipeline” status mixed in with “Closed Won” records, which would inflate revenue if included. A customer listed as “Unknown Customer” with no sales rep assigned. A row with a discounted price well below the standard price, suggesting a negotiated deal that may not be representative. Missing sales rep names on two records.
The exercise file lists all expected findings. Key metrics: approximately $850K total revenue (exact figure depends on whether the Pipeline deal and rows with missing data are included or excluded). The interesting trends: Enterprise segment outperforming SMB, one rep (Johnson) carrying a disproportionate share, Q4 seasonal pattern visible in deal timing.
Know these numbers before the demo. When Claude surfaces them, confirm aloud: “That is correct. The data has five quality issues, and Claude found all of them because we asked it to look.”
Upload the CSV. First, send the vague prompt: “What can you tell me about this data?”
“Watch the output. It describes the columns. It gives you a count of rows. It might calculate a total. This is what 90% of people get from Claude because this is how they ask.”
New conversation. Upload the same CSV. Send the structured prompt from the exercise file: specify that you want a data quality audit, summary metrics, and three executive-ready insights.
“Same file. Different prompt. Look at the difference.”
Point to the data quality findings. “It found the blank fields. It found the Pipeline deal mixed in with closed deals. It found the unknown customer. We did not tell it what problems to look for. We told it to look for problems. The specificity was in the instruction to audit, not in listing every possible issue.”
Live Demo: Document Analysis — 10 minutes
demo-data/module-07/employee-handbook-excerpt.txt— PTO, attendance, electronic communications, safety policies.The employee handbook excerpt contains several policies that a careful HR attorney would flag. The attendance policy states that three consecutive days of no-call, no-show constitute “voluntary resignation.” This is legally risky in many jurisdictions because it can be interpreted as constructive termination without proper notice or process. The jury duty policy requires employees to “remit” (return) any compensation received from the court, which some states prohibit. The electronic communications policy grants broad monitoring authority without specifying limits, which may conflict with state privacy laws. The drug testing policy references “reasonable suspicion” testing without defining the criteria for suspicion, opening the door to inconsistent application.
You do not need to be an employment lawyer to teach this demo. You need to know that Claude will flag these issues and that the flags are legitimate. If a participant who works in HR challenges a specific finding, acknowledge it: “The specifics depend on your state’s laws. The point is that Claude identified policy language worth reviewing with counsel. That is the analysis skill.”
Upload the handbook excerpt. Send the prompt: “Identify any policies in this document that could create legal risk for the employer. Explain why each one is problematic and suggest specific revisions.”
“This is Analysis. Claude reads the document, identifies risk, explains the reasoning, and proposes solutions. A junior HR associate might take two hours on this. Claude takes 30 seconds.”
Live Demo: Financial Data — 10 minutes
demo-data/module-07/quarterly-financials.csv— Five quarters of P&L data plus Q4 2025 budget.The financial CSV shows six rows: Q4 2024 through Q3 2025 (actuals), Q4 2025 (actual), and Q4 2025 (budget). The story: Q4 2025 missed the revenue budget by approximately $600K. Gross margin compressed from a budgeted 42% to actual 37.6%. Headcount came in at 192 versus a budgeted 202, suggesting either a hiring freeze or attrition. Operating expenses ran close to budget despite the revenue miss, meaning the company did not cut costs to match the shortfall.
Claude should connect these data points into a narrative: “Revenue missed plan by X. Margin compressed because Y. Headcount ran below plan, which may have contributed to the revenue miss through reduced capacity.” This is the kind of analysis a FP&A analyst produces for CFO reviews. The prompt should specify the audience (CFO), the format (variance narrative), and the scope (explain the Q4 miss vs. budget).
Upload the CSV. Send the prompt: “Write a variance analysis explaining Q4 2025’s underperformance versus budget. Audience: CFO. Include revenue, margin, headcount, and operating expense variances. Identify the root causes and connect them.”
“Watch how Claude calculates the variances, identifies the margin compression, connects the headcount shortfall to capacity, and writes it in the language a CFO expects. This is not a summary. This is analysis.”
Group Exercise: The Data Detective — 25 minutes
“Each group uploads the messy CSV and writes their own analysis prompt. The challenge: find all the data quality issues, calculate the key metrics, and identify the three most important trends.”
“When you are done, each group presents their findings. Then I reveal the answer key. We score: did you catch the missing values? The unassigned rep? The negotiated discount? The Pipeline deal that should not be in the revenue total?”
Groups that write “analyze this CSV” will get mediocre results and blame the tool. Push them toward specificity: “What exactly do you want to know? Are you looking for data quality issues, revenue trends, rep performance, or all three? What format should the output take?” The exercise teaches prompting as much as it teaches data analysis.
Debrief — 10 minutes
“Two things to remember from this module. First: Claude handles messy data without you needing to clean it first. But it needs to be told to look for problems. If you assume the data is clean, Claude will too.”
“Second: the quality of the analysis scales directly with the specificity of the prompt. ‘Analyze this’ produces column descriptions. ‘Identify the three largest revenue drivers, flag data quality issues, and format the output as an executive briefing’ produces work you can send upstairs.”
| Segment | Activity | Time |
|---|---|---|
| Opening | File types and capabilities | 5 min |
| Demo | Messy CSV: vague vs. structured | 20 min |
| Demo | Employee handbook policy analysis | 10 min |
| Demo | Financial variance analysis | 10 min |
| Exercise | Data Detective group challenge | 25 min |
| Debrief | Takeaways | 10 min |