01 — Project Overview
The Data-Intensive
Launch Phase
Launching a new pharmaceutical product is one of the most critical and data-intensive phases in the healthcare industry. Success depends on continuously monitoring commercial performance, physician adoption, market penetration, prescription trends, regional performance, and marketing effectiveness.
However, these insights often reside across multiple disconnected systems, making it difficult for business leaders to gain a unified view of launch performance. Otsuka sought to build a centralized Drug Launch Analytics Dashboard that would enable commercial, sales, marketing, and leadership teams to monitor product performance in near real time.
"The objective was to transform fragmented datasets into actionable insights that supported faster business decisions throughout the product launch lifecycle."
As the Product Designer, I was responsible for designing an enterprise analytics experience that translated complex healthcare and commercial data into intuitive dashboards, allowing stakeholders to quickly identify trends, monitor KPIs, and make data-driven decisions.
02 — Problem Statement
Fragmented
Reporting Lines
Drug launch performance was being tracked through multiple reports, spreadsheets, and disconnected BI tools, creating several operational challenges:
Commercial teams lacked a single consolidated view of product launch health metrics.
Regional performance comparisons required time-consuming manual spreadsheet data assembly.
Leadership teams spent significant time preparing status updates for weekly business reviews.
Identifying underperforming markets was slow and reactive due to fragmented datasets.
Furthermore, marketing campaign effectiveness could not be easily correlated with commercial sales outcomes, making it difficult for decision-makers to prioritize sales efforts. These limitations reduced operational agility during one of the most critical phases of the product lifecycle.
03 — Goals & Criteria
Setting
Success Targets
04 — Responsibilities
My Design Role
As the Product Designer, I partnered with business stakeholders, BI engineers, and product managers to create a user-centric analytics experience, responsible for:
Discovery
Conducting stakeholder workshops and business requirements definition.
Info Architecture
Structuring dashboard information architecture and defining critical KPIs.
Dashboard Design
Designing low-fidelity wireframes and high-fidelity Power BI interfaces.
Handoff & QA
Building interactive prototypes for client validation and conducting Design QA.
05 — Interactive Prototype
Power BI Drug Launch
Data Simulator
Adjust the "Months Post-Launch" slider and parameters to simulate the logarithmic growth curve of NRx (New Prescriptions), HCP Adoption, and Market Penetration.
Rexulti Launch Metrics
NORTH AMERICA06 — Design System
Reusable Framework
A reusable analytics design framework was created to ensure consistency across Otsuka dashboard experiences. Key reusable components included:
07 — Research & Discovery
Stakeholder Context
Interviews & Alignment
- • Stakeholder interviews with commercial and marketing teams.
- • Workshops with business analysts to identify reporting pain points.
- • Benchmarking enterprise analytics dashboards for healthcare.
KPI Audits
- • Analysis of existing launch reports and spreadsheets.
- • Prioritization of high-value, launch-critical KPIs.
- • Mapping user journeys across different organizational roles.
Research revealed that users preferred dashboards capable of answering business questions immediately rather than presenting large volumes of raw data.
08 — Design Process
Enterprise BI Process
09 — Journey Flow
Commercial Analytics
Interaction Flow
10 — Key Decisions & Features
Design Decisions
Executive Summary First
The dashboard opened with high-level KPI cards, allowing leadership teams to understand overall launch performance within seconds.
Layered Analytics
Information was progressively disclosed through drill-down interactions, enabling users to move from summaries to detailed regional insights.
Visual Storytelling
Related metrics were grouped into analytical sections that told a cohesive business story, helping users understand not just what changed but why.
Interactive Filtering
Global filters enabled users to quickly compare launch performance across products, regions, and reporting periods without navigating multiple sub-pages.
13 — Technical Challenges
Navigating Constraints
Data Complexity
Simplifying highly complex healthcare and pharmaceutical commercial data matrices.
Power BI Constraints
Designing custom layout grids optimized specifically for standard Power BI capabilities without requiring custom visual plugins.
14 — Final Solution
The Analytical Hub
The final solution transformed fragmented reporting processes into a unified analytics platform that enabled business users to monitor launch performance through intuitive visualizations, interactive exploration, and actionable insights. The dashboard combined executive summaries with detailed analytical capabilities, empowering stakeholders to move from observation to decision-making within a single interface.
15 — Business Impact
Measured Outcomes
16-19 — Project Completion
Summary & Learnings
Designing enterprise analytics for pharmaceutical product launches reinforced the importance of translating large, complex datasets into clear business narratives. Effective dashboard design is not about displaying more data — it is about presenting the right information, in the right context, at the right time.