Thomas Eapen · Selected work

Reporting and analytics

Comparing a plan, a saved snapshot and observed activity, then checking the detail behind a difference.

Synthetic example · independently invented dataOne-page print edition · A3 landscape
01 / ALIGN

Use consistent definitions

Keep calculations consistent between a summary and its supporting detail.

02 / COMPARE

Make changes visible

Bring the plan, saved snapshot and observed activity into the same view.

03 / FOLLOW UP

Trace the difference

Move from a question in the overview to the records that explain it.

Synthetic demonstration

One set of inputs. Two reporting views.

All groups, activities, values and review rules are independently invented.

01

Compare the overview

Group totals · illustrative hours

Group A

Within range -2 h
Plan168
Snapshot162
Observed160

Group B

Review +6 h
Plan192
Snapshot180
Observed186

Group C

Within range -2 h
Plan144
Snapshot150
Observed148

Shared scale: 0–200 h. Review when the absolute change from snapshot is at least 5 h.

02

Inspect the supporting detail

Group B · the same inputs, grouped by activity

Observed − snapshot+6 h

The overview flags this group. Its activity rows explain the difference.

Synthetic Group B activity detail in illustrative hours; change is observed minus snapshot.
ActivityPlanSnapshotObservedChange
Activity A847882+4
Activity B605860+2
Activity C4844440
Group B total192180186+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 definitions
Same 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.