Objective: Inside Sherpa, a retail company specializing in chip sales, sought a strategic recommendation supported by data for an upcoming category review. The focus was on understanding current purchasing trends and customer behaviors.
- Imported transaction and purchase behavior data.
- Conducted data cleaning, identifying outliers, and imputing missing brand names for products.
- Key Performance Indicators (KPIs) included total sales, sales per store, monthly sales per store, and quantity sold.
- Explored customer segmentation based on life stages, age groups, and preferred brands.
- Analyzed brand performance and popularity.
- Assessed the impact of new trial layouts, providing data-driven recommendations on whether to roll out the trial layouts across all stores.
Here is a short picture summary of visualisations using Seaborn and Plotly Express.
This analysis provides valuable insights into customer behavior and trends, guiding strategic decisions for Inside Sherpa's chip sales.
- This power BI dashboard offers insights on Sales, customers and store details
- Sales : by month, year, affluence, lifestages , brand etc
- Customers : by store, by year , by affluence , by lifestages etc
- Detailed Breakup of each store on : sales, average order value, sales per month, quantity sold etc.
Page 1 : Sales Details