Capstone Silver: Quality and Serving Layer

Objective:
Build a serving-layer KPI query and define quality controls suitable for production.

Deliverables:

1. Produce monthly claims ratio by product_line.
2. Provide at least 3 data-quality checks.
3. Define freshness SLA and one incident response action.

• 40% Correct KPI logic and grain handling
• 30% Data quality framework quality (tests + thresholds)
• 20% Operational readiness (SLA + ownership)
• 10% Communication clarity