Unified Dashboard:
Converting Ad-hoc Tool into Functional Product
PROJECT CONTEXT & OVERVIEW
My Role
Senior Design Consultant
Team
2 Business Consultants, PowerBI Developers & Data Analytics Team
Tech Stack
Power BI (Native visuals + Custom JSON Theme)
Core Business Goal
Redesign the dashboard into a scalable, modern product that caters to diverse team needs without sacrificing clarity or performance.
Problem Context
What started as a small side project grew organically into a mission-critical tool used by multiple teams.
However, without a central design vision, it became a dumping ground for nested widgets and disconnected KPIs.
Translating Insights into Design Requirements
The Hand-off
I was provided with a comprehensive research audit, a multi-step action plan, and Client's global brand guidelines. The primary objective was to move from a widget-centric view to a task-centric view while ensuring 100% brand fidelity.
Key Insights to Solutions
Insight from Team
Design Translation
Fragmented KPIs
Created a unified Primary KPI Row for global visibility.
Deep Nesting
Leveraged a sticky header for global navigation and action buttons for progressive disclosure, reducing click-depth and visual clutter.
Fragmented Visual Identity
Developed a centralized Power BI JSON Theme to translate Client's brand guidelines into the dashboard environment.
Multi-team Access
Designed modular Team Tabs that share a common UI framework.
VISUAL STRATEGY & TECHNICAL CONSTRAINTS
Performance-Driven Minimalism
Minimalist Backgrounds
I opted for a clean, plain background strategy to minimize file size and optimize rendering times. This ensured that Client's brand aesthetic was maintained through layout and typography rather than through heavy graphical assets that might compete with complex DAX queries.
Data-to-Ink Optimization
I stripped away non-essential native borders and gridlines, allowing the data itself to define the visual structure and reducing the overall "noise" of the interface.
Navigation & Information Architecture
Sticky Header Navigation
I leveraged a persistent header to allow users to switch between different team sections instantly. This ensured that no matter where a user was in their data journey, they never lost their global context.
Progressive Disclosure
Each dashboard section was designed with a "Summary-First" mindset. High-level widgets provided the "at-a-glance" health of a metric, while dedicated Action Buttons allowed power users to deep-dive into granular detail pages without cluttering the primary view.
Technical Implementation: The JSON Theme
Systemic Consistency
I authored a custom JSON Theme file to translate Unilever’s global brand guidelines into a unified visual language for Power BI. This standardized brand-specific color palettes, corporate typography, and specific visual padding, ensuring that future team additions would automatically inherit a brand-compliant 'Product' look.
The Solution
Designing the Narrative
To solve the 'Dumping Ground' problem, I moved away from a flat widget layout to a tiered information architecture. The goal was to provide a high-end 'Product' experience that felt like a native Unilever digital asset, ensuring every user—from C-suite to regional analysts—could find their specific truth without being overwhelmed.
The Global Entry Point (The Sticky Header)
I implemented a Persistent Sticky Header that served as the dashboard's "North Star."
Instead of just a raw number, I standardized every widget to include essential data points
Universal Access
No matter how deep a user scrolled or drilled, the primary team sections remained accessible.
Visual Anchor
This reduced the "where am I?" friction that plagued the previous nested version.
The Summary-First Framework
Each team section was redesigned as a High-Level Snapshot.
The Hero Metric
Use of Client's corporate typography with bold weights for primary values to ensure immediate legibility
The Trend Indicator
Standardized color-coding based on the Client's brand palette to provide intuitive, accessible context
The Call-to-Action
A clear, minimalist button labeled "View Details" or "Analyze Further."
Progressive Disclosure
The most significant UX win was the Action Button Logic.
Intentional Discovery
Instead of cramming 20 tables onto one page, I used high-level widgets as "gateways."
Contextual Detail
Clicking an Action Button takes the user to a dedicated sub-page that inherits the specific filters of that section, allowing for a deep-dive analysis without the visual noise of other teams' data.
A Unified Design Language
To ensure the 'wide audience' felt they were using a professional, corporate-grade tool, I enforced a strict visual hierarchy derived from Unilever’s design language
Primary (The What)
Bold sales figures utilizing Unilever's primary font
Secondary (The How)
Comparative percentages in brand-compliant accent colors
Tertiary (The Context)
Metadata and filtering status utilizing neutral brand grays to reduce visual noise
Qualitative outcomes & results
Definition of Done
In the absence of long-term post-launch analytics, the success of the revamp was measured against the Definition of Done established in the original Action Plan: the successful transition from a fragmented utility into a unified, high-performance analytical product fully aligned with Unilever’s global brand identity.
Drastic Reduction in Cognitive Load
By moving from a "dumping ground" of 50+ nested widgets to a Summary-First model, the dashboard now follows a clear information hierarchy.
Codified Client's Standards
The client's internal developers can now add new pages or KPIs that automatically inherit the correct client's typography and brand-specific color palettes, ensuring the Product look remains consistent and professional as the business grows.
Systemic Scalability
The creation of a centralized Power BI JSON Theme transformed the dashboard from a static file into a living design system.
Outcome
The client’s internal developers can now add new pages or KPIs that automatically inherit the correct typography, colors, and padding, ensuring the "Product" look remains consistent as the business grows.
Navigation Efficiency & Task Speed
The implementation of Sticky Header Navigation and Action Button Logic fundamentally changed how users interact with the data.
Outcome
Instead of a linear scroll or deep-menu diving, users now have a "Two-Click" path to any granular detail page, significantly reducing the time-to-insight for regional managers.
Accessibility & Inclusive Design
The legacy dashboard lacked a standardized color or contrast strategy.
Outcome
The revamp introduced a WCAG-compliant color palette derived from Client's accessible brand variants. This ensured that the 'wide audience'—including color-blind stakeholders - could interpret sales data accurately while maintaining high brand fidelity.
Stakeholder Professionalization
The most immediate qualitative win was the shift in internal perception.
Outcome
The dashboard transitioned from being viewed as a 'clunky side project' to a primary, native client's digital asset. Stakeholders are now confident using it in high-level executive meetings as it reflects the company's global standards for quality and clarity.
Conclusion & Reflection
Reflecting back
This project was a masterclass in systematizing design within technical rigidity. Redesigning a "Frankenstein" dashboard into a professional product required a fundamental shift from ad-hoc widget management to a unified architectural vision.
Drastic Reduction in Cognitive Load
By moving from a "dumping ground" of 50+ nested widgets to a Summary-First model, the dashboard now follows a clear information hierarchy.
Brand Fidelity vs. Platform Performance
Translating the Client's Global Brand Guidelines into a Power BI environment required balancing high-end aesthetics with technical efficiency. The decision to use Performance-Driven Minimalism - plain backgrounds and optimized JSON themes - ensured that brand standards were met without compromising data load times for a global audience.
Scalability through Design Engineering
By building a reusable JSON Theme file and a Sticky Header navigation model, I delivered a scalable UI framework rather than a static dashboard. The client’s internal teams can now expand the tool while maintaining 100% brand consistency and visual integrity
Intentional Information Architecture
The implementation of Progressive Disclosure via Action Button logic solved the core "Dumping Ground" issue. It reinforced that in high-density data environments, a designer's most valuable contribution is the ability to manage cognitive load by hiding complexity until it is explicitly requested by the user.
The revamped dashboard successfully transitioned from a fragmented side project to a primary client's digital asset.
It now serves as a high-performance, brand-compliant "Single Source of Truth" that satisfies both executive-level overviews and granular regional analysis.