Case Study · Johnson & Johnson · Capacity Model · 2025

From blank page to a Power BI dashboard the planners actually use.

Wireframing the Product Report screen — three passes, in pencil.

The J&J Capacity Model needed a screen that answered one question for any product, on any site, in any month: are we hitting the plan?

Before I touched Power BI, I worked the layout out by hand. These are the wireframes — the same ones I'd hand to a stakeholder before opening the build tool. The end-state polish came later; the thinking came here.

1
screen wireframed
3
layout iterations
12
design decisions logged
5
KPIs surfaced top-of-page
01

Zoning the page

No widgets. No labels. Just where things live, and why.

Information architecture
Sketch 01 Pure zoning — the first thing I scribble on a napkin before any data, fonts, or color get in the way.
02

Three layout directions

Same zones, rearranged. Which order serves the planner best?

Layout exploration
A
Chart-led. Giant trend chart up top, KPIs demoted to a sidebar.
+ Story first. − Hides the headline number.
B
KPI-led, chart-centered. Headlines first, trend in the middle, raw table grounded at bottom.
+ Everyone gets their answer fast. Chosen ✓
C
Sidebar-led. Big left rail with gauges, chart and table sharing the right.
+ Quality signals dominate. − Cramps the table.

Why B won

Planners open this page asking "is supply meeting plan?" — they need the number first. B answers that in the KPI strip before the eye even reaches the chart. Chart-led (A) buries the headline; sidebar-led (C) starves the detail table. B keeps every audience served in order: executives at the top, planners in the middle, analysts at the bottom.

03

The chosen layout, annotated

Every region defended in writing — this is the page I handed to engineering.

Detail wireframe
Sketch 03 Twelve annotated decisions. Each one defends a region against the question "couldn't this just be a table?".