Case Study: Enterprise Operational Dashboard & Deliverable Architecture
Transforming static, filter-heavy spreadsheets into a dynamic, cross-pod capacity and deliverable-tracking engine.
Background
Legacy onboarding and training required team members to manually filter a massive, organization-wide brief and deliverable list for every single query. Creative resources and project managers relied on saved browser bookmarks to navigate complex, static spreadsheets—leaving the team without visibility into deliverable complexity, client review status, or direct asset links.
Objective
Moving Away from Static Spreadsheets: Transformed filter-dependent, bookmark-heavy lists into a custom Power BI tracking dashboard with direct asset links and deliverable-level modules.
Real-Time Capacity Alignment: Built dual color-coded calendars comparing pod-wide deliverables against personal assignments to clarify bandwidth and drop-dead dates.
Organic Organizational Adoption: What started as a personal operational tool was adopted across pod designers, Art Directors, and Creative Leadership, eventually scaling into an enterprise-wide capacity model.
Key Takeaways
Eliminating Friction in Daily Execution: Replaced repetitive manual queries with a streamlined, deliverable-level view sorted by creative resource. Features include dual color-coded calendars (pod-wide vs. personal), real-time Client Review Date vs. Drop-Dead Date tracking, direct server folder links, dedicated "Status Notes," and bolded "AR" (Asset Review) indicators for instant Art Director visibility.
Standardizing Pod Governance: Adapted the deliverable widget into a standardized Workload Module deployed directly onto the Pod Tracker at the request of Creative Leadership. Upgraded static calendar boxes into a dynamic capacity tool that established party alignment across designers, Art Directors, and Project Managers.
Enterprise Capacity Modeling: Scaled the underlying Power BI architecture into an overarching creative tracker concept across all Enterprise Retail Media Pods. Provides executive leadership with a 10,000-foot view of cross-pod capacity, enabling dynamic resource sharing, preventing designer burnout, and safeguarding billable utilization across client accounts.
Strategy
Deliverable-Level Architecture: Built custom tracking modules that surface brief names, deliverable IDs, status notes, folder links, and delivery leads without requiring manual spreadsheet filters.
Color-Coded Visual Triggers: Integrated clear calendar coding (e.g., tracking Client Review Dates vs. Due Dates) to immediately highlight overdue items, items due today, and upcoming milestones within a 5-day window.
Phased Organizational Rollout:
Phase 1 (Individual Capacity): Designed for personal task execution and historical brief lookup.
Phase 2 (Pod-Wide Integration): Deployed across pod design teams to surface task complexity and resolve bandwidth constraints.
Phase 3 (Enterprise Resourcing): Expanded to cross-pod capacity modeling for executive leadership.
Strategic Outcomes and Insights
Operational Efficiency: Completely eliminated repetitive manual filtering and bookmark navigation, providing instant access to live assets and historical brief context.
Cross-Functional Alignment: Established a single source of truth across Designers, Art Directors, and Project Managers—reducing status meeting overhead and clarifying handoff timelines.
Scalable Infrastructure: Proved that a localized operational solution could be adapted into enterprise-level resourcing architecture to protect team bandwidth and billable efficiency..
Learning and Impact
From Personal Productivity to Enterprise Standard: A localized operational fix can organically scale into an organizational standard when built to solve real workflow friction.
Proactive vs. Reactive Capacity Management: Moving from static program calendars to deliverable-level tracking allows leadership to spot bandwidth bottlenecks and asset review (AR) delays before they threaten campaign deadlines.
Cross-Functional Trust: Embedding direct folder links, clear status notes, and dual color-coded timelines bridges the gap between designers, Art Directors, and Project Managers, drastically cutting down status-meeting overhead.