Pringles required detailed market insights across multiple accounts to track Q1 2024 performance against a pilot period. The core focus was on Share of Shelf (SOS), SKU availability, and in-store promotions.
Analytics Solution
To solve the data integration challenges, we built a custom pipeline:
- Data Integration: Consolidated diverse data sources using Python (Pandas) and structured them in an SQLite3 database for high-efficiency querying.
- PowerBI Dashboarding: Created a user-friendly, interactive dashboard featuring:
- Filters: Slice by account, time period, and specific SKU categories.
- Comparative Analytics: Visualizing SOS and SKU availability against historical pilot data.
- Detailed KPI Tables: Granular views for deep-dive account management.
Business Impact
The dashboard provided Pringles stakeholders with:
- Actionable Insights: Instant identification of trends and areas where SOS was lagging.
- Data-Driven Decisions: Facilitated strategic planning based on real-time SKU data.
- Competitive Edge: Detailed comparison of market performance against key competitors.