Data Storytelling
Project workbook ยท Path 69

Create a three-chart narrative that explains a service change, uses honest denominators and ends with a supported decision.

The case

A fictional library compares help-desk activity before and after a new booking form. The later period has more requests, so raw failure counts alone are misleading. The case supports descriptive comparisons, not a causal claim about the form.

PeriodRequestsResolved on first contactReopened
Before1007012
After16012016
STAGE 1

Choose a decision question

A story begins with a question a reader can answer, not with a favorite chart. Identify the audience, the decision and the evidence available. Keep descriptive statements distinct from explanations of cause. The fictional manager wants to know what improved and what needs further investigation.

Your task

Write one decision question and three evidence statements.

Required output

Story brief

Record your result and evidence here or in a separate file.

Review gate

No statement attributes the change to the form as a proven cause.

If the gate is not met

Add the missing comparison or remove the causal wording.

STAGE 2

Calculate comparable measures

Use denominators that match the question. First-contact resolution is resolved requests divided by all requests; reopening rate is reopened requests divided by all requests in this simplified case. Name the denominator because other organizations may define reopening differently. Preserve both counts and rates so volume remains visible.

Your task

Calculate both rates for both periods and reconcile the raw counts.

Required output

Metric table

Record your result and evidence here or in a separate file.

Review gate

Resolution is 70% then 75%; reopening is 12% then 10%.

If the gate is not met

Write numerator and denominator beside every percentage.

STAGE 3

Design honest charts

Choose a chart that makes the comparison easy to inspect. A bar chart normally needs a zero baseline; a rate chart should label percentage units. Avoid 3D effects and decorative scales that exaggerate change. Provide the underlying table and do not rely on color alone to identify the periods.

Your task

Create volume, resolution-rate and reopening-rate charts with direct labels.

Required output

Three-chart draft

Record your result and evidence here or in a separate file.

Review gate

All plotted values match the table and the comparison remains clear in grayscale.

If the gate is not met

Remove decoration before adding more annotation.

STAGE 4

Connect the narrative

Sequence context, evidence and implication. Explain that request volume rose while both selected rates improved. A useful narrative also names limitations: sample periods, case definitions and potential changes in request difficulty. The recommendation should be proportionate to the evidence rather than a celebration of an untested explanation.

Your task

Write a 300-word narrative and one next investigation step.

Required output

Narrative with decision

Record your result and evidence here or in a separate file.

Review gate

The reader can find the denominator and the limitation without reading notes elsewhere.

If the gate is not met

Move essential caveats next to the affected claim.

STAGE 5

Rehearse questions

Questions reveal where a visual is ambiguous or a claim overreaches. Prepare to explain definitions, arithmetic and missing evidence. If you do not know an answer, record the data needed rather than inventing it. Use feedback to improve the artifact, not to defend every initial design choice.

Your task

Answer five likely reviewer questions and revise one chart annotation.

Required output

Review log

Record your result and evidence here or in a separate file.

Review gate

Answers distinguish observed values from assumptions and unknowns.

If the gate is not met

Trace each answer to the case table or label it unknown.

Final project

Deliver the metric table, three charts, narrative, source note and question log. Create one deliberately misleading chart in a separate appendix and explain the specific correction.

Critical condition

Chart values and denominators agree, and descriptive changes are not presented as proven causal effects.

CriterionPointsEvidence
Evidence and correctness30Calculations, source use and results match the supplied case; limitations are honest.
Required artifacts30All five stage outputs and the capstone handoff are present and inspectable.
Reasoning and decisions20Choices, assumptions, alternatives and the case-specific critical condition are explained.
Reproducibility10A reviewer can follow the stated steps and distinguish expected from observed results.
Clear communication10Labels, units, structure and evidence references make the work easy to review.

Score at least 80/100, supply every required artifact, and satisfy the path-specific critical condition. Rework missing evidence before marking complete.

Worked reference

Requests rose 60%, from 100 to 160. First-contact resolution rose by 5 percentage points, from 70% to 75%. Reopened requests rose from 12 to 16, while the reopening rate fell from 12% to 10%. Both the count and rate statements can be true.

Boundaries

This is a descriptive communication exercise; it does not estimate statistical significance or causal impact.