Case Study · Analytics & Benchmarking

Every number,
in context.

A statistic on its own tells you almost nothing. Is 64 good? It depends on what comparable units score, what this unit scored last year, and the world it operates in. ASG built the platform that answers all three questions at once.

Client
National multi-program nonprofit (anonymized)
Engagement
Analytics, KPI & benchmarking platform
In production
Since 2014
Partner
Arizona Software Group
This unit vs its peers peer median this unit
01 / The Challenge

They were collecting the data. They just couldn’t tell what it meant.

Every location reported its numbers faithfully. But a number with nothing to compare it to is just a number, and leadership had no way to turn thousands of them into a judgment.

Was a unit doing well or struggling? Improving or sliding? Carrying its weight given the community it served? Answering any of those meant pulling reports from separate systems by hand, lining them up in spreadsheets, and hoping the comparison was fair. By the time the picture came together, the moment to act had passed.

No peer context

A score meant nothing without knowing what comparable units achieved. There was no fair, automatic way to line like against like.

Trends were invisible

A single year hid the story. Was this stability, a one-off, or the start of a slide? Nobody could see the shape of the line.

Numbers without a world

The same result means different things in a wealthy suburb and a struggling rural county. Internal data alone couldn’t account for that.

By the numbers
120+ KPIs
Tracked, scored, and benchmarked across the organization
900+ units
Compared against true peers, automatically and fairly
7 sources
Internal and external data unified into one model, including the US Census
10 yrs
Of history, so every trend line is long enough to trust
02 / The Approach

Three ways to read a number, in one place.

Insight comes from comparison. We built the platform around three lenses, so any metric can be read against its peers, against its own past, and against the real world it operates in, without anyone assembling a spreadsheet.

Lens 01 · Horizontal

Compare like with like

Rank a unit against true peers, not the whole organization. Peer median and quartiles turn a raw score into a position: ahead, typical, or behind.

Lens 02 · Vertical

Stability and trend over time

Read the same metric across years. Is it climbing, flat, or volatile? A trend line and a stability band separate a real shift from ordinary noise.

Lens 03 · External

Account for the real world

Blend in outside data such as the US Census, so performance is judged against the demographics and economics each unit actually faces.

03 / Sample Dashboards

What leadership actually sees.

Illustrative views built from sample data. The same metric, read three ways.

Horizontal · Peer comparison
Where this unit stands among peers
0 25 50 75 100 Unit 447182 Unit 221074 Your unit69 Unit 309863 Unit 118558 Unit 553654 Unit 074247 peer median

Your unit sits above the peer median, fourth of seven comparable units. The same number against the full organization would have looked merely average.

Vertical · Trend & stability
The same metric, ten years deep
40 50 60 70 FY19 FY20 FY21 FY22 FY23 FY24 FY25 This unit Peer avg

Below its peers five years ago, this unit has climbed steadily and now leads them. A single year would have missed the most important fact: the direction.

External · Scatter against US Census data
Performance in the context of the community served
0 25 50 $30k $50k $70k $90k Your unit Median household income — US Census Participation / 1,000 residents

Each dot is a unit, placed by the median household income of the community it serves (US Census) against its participation rate. The trend line is what income alone would predict. Your unit sits well above it, outperforming the demographics it was dealt, which a raw ranking would never reveal.

04 / The Data

One model, fed from many sources, internal and external.

The comparisons are only as fair as the data behind them. We pull from the systems that already run the organization and enrich them with trusted outside data, then reconcile it all into one model every dashboard reads from.

Internal sources keep the metrics current and accurate. External sources, like the US Census, give every number the real-world context that makes a comparison meaningful rather than misleading.

Internal

Statistical reporting

The activity and outcome metrics captured by units on the ground, the raw material of every KPI.

Internal

Personnel & structure

Who and what each unit is, so peers are grouped fairly and the org structure is always right.

Internal

Financial & giving

The funding side of the picture, joined to activity so efficiency and effort can be read together.

External

US Census

Income, population, and demographics for each community, the backbone of the contextual scatter plots.

Internal

Geographic data

Location and catchment, so units are matched to the communities they actually serve.

External

Economic indicators

Regional economic context to separate a unit’s effort from the headwinds or tailwinds around it.

External

Public benchmarks

Sector reference points that put the whole organization in a wider national frame.

Unified

One reconciled model

All of it cleaned, matched, and reconciled into a single source the dashboards read from.

For the first time, a number on the screen actually means something. We can see who needs help, who’s quietly excelling, and who just happens to sit in an easy ZIP code. That changed how we lead.
05 / The Results

From raw numbers to decisions leaders trust.

Fair comparison, automatically

Like units are compared to like, with peer median and quartiles, so no one is judged against a standard they could never meet.

The direction, not just the dot

Every metric carries its own history, so leaders see whether a unit is climbing, holding, or sliding before it becomes a crisis.

Context from the real world

Census and economic data reveal the units outperforming their circumstances, and the ones coasting on an easy hand.

Hours of spreadsheets, gone

The manual assembly that used to delay every comparison is replaced by dashboards that are current the moment data lands.

Attention where it counts

Leadership can find the units that need help and the ones worth learning from, instead of reacting to whoever shouts loudest.

One shared source of truth

Everyone argues from the same reconciled data, so the conversation is about what to do, not whose numbers are right.

Arizona Software Group

We turn the data organizations already collect into decisions they can trust.