Background
Johnson & Johnson relies on complex global supply chains to ensure its vital pharmaceuticals, consumer products, and medical devices reliably get to the consumers who depend on them.
Since the Covid-19 pandemic began, keeping these supply chains strong has been more important, and more challenging, than ever.
The Challenge
Legacy BI limits real-time supply chain visibility.
Johnson & Johnson runs a global supply chain for pharmaceuticals, consumer products, and medical devices.
Supply chain managers relied on a suite of data applications to triage problems across that chain, combining first- and third-party data, tracking historical trends against targets, and flagging anomalies that needed attention.
The tools worked, but the legacy BI platform underneath them had outgrown the job. Managers couldn’t flexibly build new dashboards or reports. Changing an application was slow and expensive. And data extracts weren’t delivering the real-time view managers needed to act during the COVID-19 pandemic, when supply chain pressure was at its highest.
The Solution
Modernizing supply chain analytics with Looker.
Johnson & Johnson’s data engineering and visualization teams brought in DAS42 to build a lighter, more flexible platform, one that kept the same look, feel, and workflow integration managers already knew.
The rebuild covered three components:
- OTIF (on-time, in-full): whether a customer received every unit of every line in the promised fulfillment window
- Delivery Control Tower: a connected, personalized dashboard of supply chain metrics and events for real-time prioritization
- QBR (quarterly business review): performance, reliability, and customer experience reporting
Johnson & Johnson chose Looker for the rebuild. Looker’s extension framework made it possible to build a fully customized interface that still matched the legacy system’s look and feel, so supply chain managers didn’t have to relearn their tools mid-crisis.
The Results
Modernized supply chain analytics with minimal disruption.
DAS42 migrated four existing applications and built a new one on the Looker Embed SDK and extension framework in a few months.
The extension framework lets Johnson & Johnson’s own developers use Looker’s standard visualizations and features while keeping a fully custom interface on top.
The customized interface, built to match the legacy system, cut the need for staff retraining and change management. Supply chain managers kept the real-time analytics and triage capabilities they depended on, at a moment when supply chain strain was widespread across the industry.
We work as an extension of our clients’ teams, solving the data problems that stand between them and a business decision.
Real clients, real results.
