Capstone · Operations team monitoring field devices

Quality report for device readings

Field devices send timestamps, some without an offset, and monthly meter readings where a missing month and a zero reading look alike in the current dashboard.

Produce clean timestamps, a monthly table that keeps zeros and gaps apart, and a short report on which devices need configuration fixes.

Checkpoints

1. Timestamps with offsets kept; offset-less values quarantined.
Timestamps need an offset
2. Monthly readings pivoted; never-reported months stay missing.
Pivot monthly values, keeping zeros and gaps apart
3. Unknown regions labelled; missing durations left missing.
Label unknown categories, keep missing numbers missing

Final quality report

Write it in your private notes below (saved to your account) or in your own document. It isn't auto-graded; use it to practise the handoff interviewers ask about.

Count of quarantined timestamps by device configuration problem.
Why a missing month must not be shown as 0, with one example.
Which gaps can be backfilled from source and which can't.
A check to run on every new delivery.