Transforming Pharmaceutical Insights: A Power BI Dashboard Overhaul
A leading multinational pharmaceutical company relied on a Power BI dashboard to track brand performance and drug success. However, the existing dashboard was cluttered and inefficient, requiring up to two days of back-and-forth effort to gather and present data for Monthly Performance Review (MPR) discussions. The goal of this transformation was to create a streamlined, human-centered dashboard that enables leadership to make informed, data-driven decisions in minutes.
Pharmaceutical
UX Designer + Researcher
Users, SMEs, Product Stakeholders
Challenge
Cumbersome Data Collection: Gathering and validating data required significant manual effort, slowing decision-making.
Cluttered Interface: The dashboard lacked a structured hierarchy, making insights difficult to interpret.
Inefficient Collaboration: Users had to manually compile reports for MPR discussions, leading to delays.
Limited Utilization of Power BI Features: The existing design didn’t fully leverage Power BI’s capabilities for advanced analytics and visualization.
Results
10X Faster Decision-Making: The redesigned dashboard reduced the MPR preparation time from two days to mere minutes.
Enhanced Data Clarity: A structured information architecture and modern design reduced clutter, allowing users to extract meaningful insights quickly.
Improved Collaboration: The dashboard now enables seamless data-sharing, ensuring all stakeholders are aligned.
Optimized Power BI Features: The solution leveraged the latest Power BI functionalities, maximizing operational efficiency.
360°view
brand performance and drug success.
+50%
Faster, smarter decisions.
2 Days
Saved, Eliminated manual effort
Process
Stakeholder Interviews & Thematic Analysis We conducted in-depth interviews with over 20 leaders, analyzing their workflows, data interpretation needs, and challenges with the existing dashboard. Thematic analysis helped uncover recurring pain points, such as difficulties in navigating insights and inefficiencies in data validation and self service.
Persona Development Based on our research, we defined three key user personas:
Creator - Owner: Responsible for gathering and validating data before uploading it to the dashboard.
Narrator: Crafts MPR narratives and collaborates with teams to validate data.
Decision Maker: Uses insights to measure brand performance, ask the right questions, and make informed decisions.
Ideation Workshop Using Idea Trigger cards, we facilitated a collaborative workshop to explore new opportunities, map user journeys, and define key scenarios. Power BI cards were introduced to showcase new features that could enhance operational efficiency.
Designing the Dashboard of Tomorrow We adopted a minimal, modern design approach, ensuring:
A clear information hierarchy for effortless data consumption.
The use of brand colors and ample whitespace to enhance readability.
Intuitive visual aids to present brand and category performance effectively.
Delivery & Implementation The final dashboard was delivered through an iterative process, including:
Post-iteration refinements based on user feedback.
Development team orientation to ensure smooth integration.
Thorough audits and User Acceptance Testing (UAT) before deployment.
“ This new dashboard has completely changed how we work. We used to spend days gathering and organizing data for MPR meeting now, it’s all there in minutes. It’s clearer, faster, and makes decision-making so much easier.”
Senior Leader
Multinational Pharma Company
Conclusion
This transformation turned a time-consuming, complex dashboard into an intuitive and powerful decision-making tool. By aligning with user needs and leveraging modern data visualization techniques, the redesigned dashboard enables leadership to derive meaningful insights rapidly, ensuring timely and effective strategic decisions.