SKILL PATH · ANALYSIS

Metric Detective

A figure moved. Slice it by the right dimension to find out why, before the meeting.

THE QUESTION

Revenue Fell 18%. Find Out Why.

March revenue came in at £33,900 against £41,200 in February. Your director wants an answer before the meeting, not a spreadsheet. Slice the total by one dimension at a time until you find where the fall actually sits.

£41,200February
£33,900March
-18%Change

Slice it by

Your answer

Where does the fall actually sit?

No slices looked at yet

THE METHOD

How to Chase a Number That Moved

Slice one dimension at a time

Break the total down by each dimension in turn and look for the one where a single value carries most of the change.

Compare the share, not the size

The biggest category usually has the biggest fall in pounds. Look at which one fell most as a share of itself.

Then slice again inside it

Once you have the dimension, slice within that value to find the detail: one region, one week, one account.

Say what would change your mind

If a second dimension explains it equally well, you have found a correlation, not a cause.

Build Your Confidence with Data

Every skill path on Insyt is built around practice like this.