Demonstration · Illustrative data · BI Consulting Services Global Transportation & Trade Operations · GS&SCS
Johnson & Johnson × BI Consulting Services
Transportation & Trade Operations Board — the Power BI layer on top of the production Power App: lanes, clearance, cold chain, and the GxP enhancement backlog in one validated view.
Prepared for Chris
September 2026 · Power BI + Power Platform
Sep 2025 – Aug 2026 · 16 lanes · 3 modes
Region
Mode
Period
Network in scope
64manufacturing sites feeding 16 lanes
Every shipment on this board originates at one of J&J's 64 manufacturing facilities worldwide1 and is tracked from booking through customs release to receipt. In the selected view, shipments moved with arriving on time against a 96.0% target.
1 Site count is J&J's published figure (jnj.com/about-jnj, 2026). Lanes, volumes and every other number on this page are illustrative demonstration data.

Application lifecycle · Transportation & Trade Power App

Where the app sits today, and where this Power BI layer plugs in. First GxP application in the organisation.

POCPrototype built in-house
ProductionValidated release · IQ/OQ/PQ complete
Maintain & enhanceChange control · backlog
Reporting layerThis board · certified dataset
enhancement requests are open against the production app; of them touch GxP-impacting fields and route through formal change control. Median intake-to-release: days.

On-time delivery vs 96.0% target

Monthly, selected lanes · hover for detail

On-time %Target 96.0%Below-target month

Freight spend vs plan

Monthly, USD · selected lanes

ActualPlan

Lane network · origin site to destination market

Stroke width = shipment volume · red = lane below 96.0% on-time in the period · dots = manufacturing sites by region

Lane at or above targetLane below targetThinner = fewer shipments

What this board answers

Three questions the ops lead asks on Monday

Lane ranking · on-time %

All lanes in the selected view, worst first · red line = 96.0% target

Trade compliance · customs holds

Holds raised in the period and how fast they cleared

Released ≤ 24 h24–72 h> 72 h (SLA breach)

SLA breaches (> 72 h) by month

Also from BI Consulting Services

Private AI on your own server

The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.

Private AI Servers — slide 1 of 14
Private AI Servers — slide 2 of 14
Private AI Servers — slide 3 of 14
Private AI Servers — slide 4 of 14
Private AI Servers — slide 5 of 14
Private AI Servers — slide 6 of 14
Private AI Servers — slide 7 of 14
Private AI Servers — slide 8 of 14
Private AI Servers — slide 9 of 14
Private AI Servers — slide 10 of 14
Private AI Servers — slide 11 of 14
Private AI Servers — slide 12 of 14
Private AI Servers — slide 13 of 14
Private AI Servers — slide 14 of 14

Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min