PRISM in Action: Transforming Inventory Data Practices for Pet Food Brand Success

An independent brand specializing in vegan-friendly and sustainably sourced pet food and treats approached Square Goose at a critical growth crossroad.

They needed clear direction on making data-driven decisions that support their short, medium, and long-term goals.

DISCOVER: Understanding What Matters Most

We began by focusing on what truly mattered to our client's business through a structured 'Key Questions Workshop'- designed to unify strategic vision across departments.

Workshop Activities:

- Building Partnership: We kicked off with an ice breaker where team members shared stories based on randomized photo prompts, creating a relaxed atmosphere for open discussion.

- Understanding Goals: Team members shared their departmental goals across different time horizons, helping us identify which were most critical for overall business success.

- Identifying Key Questions: Together, we pinpointed the specific questions they needed to ask of their data to drive meaningful actions and decisions.

This discovery phase built a strong foundation of understanding and trust, establishing a partnership where we could provide solutions perfectly aligned with their business needs.

Outcomes:

• A unified strategic vision that brought different departments onto the same page

• A prioritized list of key questions tailored to their specific business goals

• Stronger collaboration among team members, setting the stage for successful implementation

DEVELOP: Transforming Insights into Action

With a clear understanding of the client's needs, we moved into development, where we analyzed their business data to design solutions that would put vital information at their fingertips.

Workshop Activities:

• KPI Driver Tree Workshop: We mapped their key questions to available data, creating a comprehensive framework for analysis.

• Analysis and Reporting Assessment: We determined the most impactful types of analysis needed to answer their key questions.

Through our thorough analysis, we identified 'Inventory Management' and 'Product Availability' as the areas with the greatest opportunity for value creation.

Dashboard Development:

We designed and implemented four interconnected dashboards:

• Inventory Management Overview: Providing key figures for senior management

• Product Availability Dashboard: Showing exactly which products were unavailable and the financial impact of lost sales

• Stock Value Overview: Evaluating stock value across locations to improve ordering processes

• Days On Hand Overview: Displaying how long current stock levels would last, categorized by urgency

  
  

These bespoke solutions gave the client clear steps forward, all supported by reliable data.

DRIVE: Delivering Lasting Value

We didn't just deliver insights and leave. We worked alongside the client to turn those insights into real business growth through implementation and ongoing support.

Implementation Activities:

• Integration into Workflows: We incorporated dashboards into weekly trading meetings

• Team Training: We provided comprehensive training on using the new tools effectively

• Documentation: We created fully-documented process paths for sustainability

• Ongoing Support: We remained available for support and guidance as their team adapted to new ways of working

This ongoing partnership helped the client stay ahead of market changes and continuously improve their operations.

Measurable Results:

• 42% increase in availability across key product lines

• Significant reduction in time to interpret data across departments

• Clearly defined and documented actions from weekly trading meetings

• Increased team focus and accountability with clear data interfaces and responsibility channels

The PRISM Difference

Through our three-step PRISM method, we helped our client transform their approach to inventory management and product availability.

The journey we took together brought clarity and confidence through data-driven insights.

We partnered to discover original opportunities, design clear action plans, and implement sustainable solutions—delivering lasting value at every step of the process.

Today, their team makes confident decisions based on clear data, saving time and reducing stress while building stronger customer relationships through improved product availability.

---

Want to see how the PRISM approach can help your brand grow?

Reach out at: letstalk@squaregoose.co.uk