1. Project Title & Company Review
Rite-Kiosk: Optimizing Sales Performance.
INDUSTRY: Retail Industry.
Rite-Kiosk operates in a competitive retail market, offering diverse products. The company targets individual and corporate customers across multiple geographies. As it expands its reach, understanding sales performance, customer segments, and operational efficiency is critical.
ROLE: Sales Analyst.
2. Business Problem
- Sales performance varies significantly across regions.
- High customer churn in specific categories.
- Suboptimal product profitability and underperforming product segments.
- Limited understanding of time-series trends for planning.
- Inconsistent data preparation methods leading to inefficiencies.
3. Business Objectives
- Explore and analyze Rite-Kiosk's sales performance across regions, categories, and time.
- Identify high-performing and underperforming products and segments.
- Optimize the decision-making process with actionable insights.
4. My Approach
- Data Collection of MS Excel dataset
- Data Preparation.
- Data Exploration & Descriptive Analytics.
- Insight Visualization & Reporting.
- Recommendation.
TOOL USED: Tableau
5. Key Deliverables
Delivered a Tableau dashboard to improve data-driven decision-making.
6. Insights
- The West region had the highest sales, at $107k, followed by the East at $42k, the South at $17k, and the Central region at $14k.
- Products in the Technology Category made the highest sales of $73k, next is the Furniture $59k, and lastly Office Supplies with $49k in sales across the year.
- Based on the sales-to-profit ratio for each product category, Furniture made $2k in profit, while Technology & Office Supplies made $14k and $7k in profit, respectively.
- The months of March, September, and December generated the highest sales of $22k, $29k and $26k, respectively. The other part of the year had their sales plummeting between $4k and $19k.
7. Recommendations
- The marketing team should invest in promoting the Regions with low sales.
- Carry out a survey on the particular product category needed across all regions; this will help channel the right resources to the appropriate region.
- For other months that perform low in sales, an investigation must be thoroughly carried out to find the cause.
- Run a mild discount for months, generating low sales.
- The company can also run a bonus for long-term returning customers for their consistent patronage.