Pringles sought to gain detailed insights into their market performance across various accounts. They needed a comprehensive dashboard to track key performance indicators (KPIs) for Q1 2024 and compare them against a pilot period. The main KPIs included Share of Shelf (SOS), SKU availability, MSL adherence, in-store promotions, and off-shelf displays.
Several challenges needed to be addressed:
- Diverse KPIs: Tracking multiple KPIs, each with specific measurement criteria.
- Comparative Analysis: Comparing current data with historical data to identify trends and areas for improvement.
- Data Integration: Consolidating data from various sources and ensuring accuracy.
- User-Friendly Visualization: Creating an interactive dashboard for easy data interpretation and exploration.
To address these challenges, I developed a KPI dashboard using Python, Pandas, SQLite3, and PowerBI.
- Data Integration: Integrated data from multiple sources, ensuring all necessary KPIs were included. Cleaned and structured the data using Pandas to ensure accuracy.
- SQLite Database: Stored the preprocessed data in an SQLite3 database for efficient querying and retrieval.
Creating dashboard using PowerBI
- Filters and Selectors: Allowing users to filter data by account, time period (Q1 2024 vs. Pilot), and other relevant parameters.
- Comparative Charts: Visualizing the comparison of KPIs between Q1 2024 and the pilot period using bar charts, line graphs, and pie charts.
- Detailed Tables: Providing granular details on each KPI for deeper insights.
- Enhanced Data Visibility:
- The dashboard provided a clear and comprehensive view of Pringles’ performance across various KPIs, making it easier for stakeholders to understand and analyze the data.
- Actionable Insights:
- By comparing Q1 2024 data with the pilot period, stakeholders could identify trends, strengths, and areas needing improvement. This facilitated data-driven decision-making.
- Improved Competitive Analysis:
- The dashboard enabled a detailed comparison of Pringles’ performance against competitors, highlighting areas where Pringles was outperforming or lagging.
- User-Friendly Interface:
- The interactive and intuitive interface of the Streamlit dashboard allowed users to easily navigate and interact with the data, enhancing the overall user experience
