Thomas Eapen · Selected work
Reporting and analytics
Comparing a plan, a saved snapshot and observed activity, then checking the detail behind a difference.
Use consistent definitions
Keep calculations consistent between a summary and its supporting detail.
Make changes visible
Bring the plan, saved snapshot and observed activity into the same view.
Trace the difference
Move from a question in the overview to the records that explain it.
One set of inputs. Two reporting views.
All groups, activities, values and review rules are independently invented.
Compare the overview
Group totals · illustrative hours
Group A
Within range -2 hGroup B
Review +6 hGroup C
Within range -2 hShared scale: 0–200 h. Review when the absolute change from snapshot is at least 5 h.
Inspect the supporting detail
Group B · the same inputs, grouped by activity
The overview flags this group. Its activity rows explain the difference.
| Activity | Plan | Snapshot | Observed | Change |
|---|---|---|---|---|
| Activity A | 84 | 78 | 82 | +4 |
| Activity B | 60 | 58 | 60 | +2 |
| Activity C | 48 | 44 | 44 | 0 |
| Group B total | 192 | 180 | 186 | +6 |
Activity A
- Plan
- 84
- Snapshot
- 78
- Observed
- 82
- Change
- +4
Activity B
- Plan
- 60
- Snapshot
- 58
- Observed
- 60
- Change
- +2
Activity C
- Plan
- 48
- Snapshot
- 44
- Observed
- 44
- Change
- 0
Group B total
- Plan
- 192
- Snapshot
- 180
- Observed
- 186
- Change
- +6
Activity A: +4 h · Activity B: +2 h
Reconcile before interpreting. The detail totals match the overview: 192 planned, 180 at snapshot and 186 observed hours for Group B.
Same definitionsSame totals
Colleagues contributed to the visual design of the original reports. These new illustrative views preserve the comparison and drill-down approach, with independently invented data.