Snapshot

About: Predictive analytics tool for building and analyzing commercial plans. Combines diagnostic analytics and scenario planning to support individual and collaborative decision-making.

Role & scope: UX design + research lead; data visualization lead. Owned discovery, problem framing, design workshop facilitation, and usability testing. 

Team: 5 UX (including me), PM, Front end, backend, data foundation, modeling, & business stakeholders.

Timeframe: 2 Years

Key Decisions (type / authority):

  • Scope- Recommended & Facilitated alignment

  • Research plan-  Decided

  • Standard of evidence- Decided

  • Information Architecture- Decided

  • Design System- Decided

  • Final Design Direction- Decided

Problem

Brief I received: The initial request was to create reports for the analytics team, so they could better support sales planning. After discovery, I found the problem was deeper than report access. Data was fragmented across silos, teams spent a lot of time wrangling it, and insights were difficult to translate into actionable sales plans.

Reframed problem: Sales planning was mostly driven by individual past experience, which kept teams locked into familiar patterns and chasing incremental wins. As company growth goals demanded new ways to outpace the market, the planning process did not give teams a consistent way to turn data into shared decisions that they could sell to a retailer.

Research

Methods: Stakeholder interviews (3), user interviews and observation (15), qualitative analysis, design workshop, usability testing (24 users, 6 iterations).

Artifacts: Experience map, personas, high fidelity prototypes.

Learnings

  • Turning data insights to selling stories: Sales teams wanted to be seen as retail business partners, rather than just suppliers. This required effective storytelling to help retailers better understand their shelf experience. Forming this story from data was a major challenge.

  • Understanding commercial plan impact: A lot of planning was done from habit, often relying on instinct more than data. Evaluating last year’s performance, this year’s progress, and next quarter’s forecast was not a standardized methodology.

  • Excessive data wrangling: Teams were spending a lot of time cleaning and organizing data to create reports. This is time that could be better spent analyzing, planning, or talking to retailers.

  • Data Silos: Teams were looking at different reports, with different data, speaking different languages (figuratively). Data needed to be centralized so that everybody had the same source of truth. Reports needed to be democratized so that all roles were able to extract insights.

  • Experimentation: Teams became tired of trying to stack small, short term wins to keep up with the market. They wanted plans that generate long-term, sustainable growth. It was important to give teams a way to experiment, challenge assumptions, and re-think their typical approaches.

Options and Tradeoffs

Since project kickoff, the team had a project direction in mind. Through discovery, I surfaced alternatives and tradeoffs to present to the team, then facilitated alignment.

Speed to Deliver vs Completeness/Scalability

  • Strategic Planning: Upstream planning process focused on market trends, and company strategy.

  • Tactical Planning: Further downstream, disaggregating company strategy into a retail level plan. 

  • Both: Ensuring the tool can support and connect these two processes.

Role Scope

  • Analytics Team: A more advanced reporting tool that can help the analytics team uncover insights for the business teams.

  • Business Team: A more generalized tool that supports the business functions directly (Marketing, Sales, and Finance).

Decision & What We Shipped

I pushed the team to expand the scope to include strategic planning rather than going deep only on tactical planning. The bigger gap was not within any single reporting task. It was the disconnect between strategy and execution. So instead of overbuilding one part of the workflow, we chose to prototype the end-to-end decision process.

We also decided to support all core commercial roles, not just analytics.

  • The problem existed in the business process, not just the reporting. The analytics team owned the data interpretation because the broader process lacked a consistent, data-driven methodology. Targeting analytics as the main users would have preserved this dependency rather than solving it.

  • Revenue Growth Management was not owned by any single role. It was a cross-functional sensemaking process that drove commercial planning. A tool that only served the analytics team would have been antithetical to the underlying philosophy of RGM. As a result, the MVP needed to express a different operating model by supporting Marketing, Customer Development, and Finance.

Impact

  • Adopted across 31 of 32 brands in the portfolio.

  • Used by 1,523 total users,including 300 monthly active users

  • Supported management of 1,859 projects

  • Provided portfolio visibility into $4B in incremental net sales

Learnings

  • Next bet and owner (functions only) + one durable takeaway.

Proof hooks: leading indicator to watch, success threshold, planned experiment.