# Analytics qualification fundamentals: synthetic exercise worksheet

Curriculum reviewed: 2026-10-25. Use public or synthetic data only.
Do not include client evidence, credentials, private identifiers or raw receipts.

## Goal
a one-page explanation of a sample qualification and its limits; no live tenant required.

## Outcomes
- Distinguish authoring from qualification.
- Explain an independent oracle.
- Read the eight boundary states.
- Identify the decisions a human must own.

## Synthetic case
Describe a Sales report built from order headers and order lines. State which grain you intend and which independently established expectation you would compare.

## Review each lesson
### 1. A correct-looking report can be wrong
Follow an order-header versus order-line mistake across the pipeline.
Expected output: a written explanation naming the observation, its scope and its limits.
Your notes:

### 2. The source-to-report chain
Locate source, meaning, Bronze, Silver, Gold, semantic, report and release boundaries.
Expected output: a written explanation naming the observation, its scope and its limits.
Your notes:

### 3. The independent oracle
Separate a business expectation from the code being tested.
Expected output: a written explanation naming the observation, its scope and its limits.
Your notes:

### 4. What a green gate means
Read qualified, blocked, stale, unknown and not-applicable without expanding the claim.
Expected output: a written explanation naming the observation, its scope and its limits.
Your notes:

### 5. People and permissions
Keep grain ratification, source reads, deployment consent and business acceptance explicit.
Expected output: a written explanation naming the observation, its scope and its limits.
Your notes:

### 6. Your first proof review
Annotate a sample result with scope, observation time and the unanswered questions.
Expected output: a written explanation naming the observation, its scope and its limits.
Your notes:

## Failure case
Generated definitions exist but a required execution observation is missing. Explain why qualification cannot pass and name the next required observation. Do not fabricate a receipt or change a frozen expectation.

## Evidence table
| Claim | Expected observation | Available evidence | Missing/stale | Next owner/action |
| --- | --- | --- | --- | --- |
| | | | | |

## Limitations
This worksheet is a completion check, not live qualification, business acceptance or a professional award. Pro assessment and certification policy remain planned. Keep optional live results in customer-controlled custody.