Watch the explanation. Practice the skill.
Capstone: produce a reproducible decision analysis
Deliver calculations another person can repeat and inspect.
Captions appear here during playback.
Capstone: produce a reproducible decision analysis
Deliver calculations another person can repeat and inspect.
Video playback is unavailable. Read the descriptive transcript below, go directly to practice, or open the video file.
Source-based teaching example · Fictional data · Reviewed 2026-10-03. Microsoft Mark · locally synthesized. On a small screen, use fullscreen for diagram details or read the transcript.
Read the descriptive transcript
0:00 · What you will learn
Deliver calculations another person can repeat and inspect.
What appears on screen
Deliver calculations another person can repeat and inspect.
0:06 · The idea
Keep original rows, validation decisions, formulas and results together. Explain missing records and unequal tasks. A polished chart cannot replace that evidence.
What appears on screen
Keep original rows, validation decisions, formulas and results together. Explain missing records and unequal tasks. A polished chart cannot replace that evidence.
0:21 · One useful term
Reproducible analysis. An analysis whose inputs, choices and calculations can be followed and repeated.
What appears on screen
An analysis whose inputs, choices and calculations can be followed and repeated.
0:32 · A worked example
The worked package traces source rows through validation to rates and a decision note. Missing duration stays missing. Unresolved records prevent a general comparison claim.
What appears on screen
The worked package traces source rows through validation to rates and a decision note. Missing duration stays missing. Unresolved records prevent a general comparison claim.
0:45 · Your turn to think
Does a smaller known subtotal prove overall savings when work is still missing? Pause and decide before continuing.
What appears on screen
Does a smaller known subtotal prove overall savings when work is still missing? Pause the video if you need more time.
1:04 · Why this answer works
No. State the incomplete coverage and unmatched workload. Keep exclusions and formulas inspectable.
What appears on screen
No. State the incomplete coverage and unmatched workload. Keep exclusions and formulas inspectable.
1:14 · Check 1
Preserve source rows and cleaning decisions.
What appears on screen
Preserve source rows and cleaning decisions.
1:19 · Check 2
Check formulas independently.
What appears on screen
Check formulas independently.
1:24 · Check 3
Limit conclusions to comparable known work.
What appears on screen
Limit conclusions to comparable known work.
1:30 · Now try a different case
Open the lesson and try its different practice case. Use every check in the full task. Watching alone does not mark the lesson complete.
What appears on screen
Open the lesson Try the new case Check and revise The full task and its requirements are in the linked lesson.
Watching explains the example. Complete the lesson practice to check what you can do. Explore all visual lessons →