Problem Statement:
A leading retail superstore chain wants to identify which products, regions, and customer segments are profitable and which aren’t, to make smarter marketing and inventory decisions.
Questions Answered:
- Which product sub-categories are most/least profitable?
- What customer segments drive the most revenue?
- Are discounts affecting profit?
- What are the top-performing regions and states?
Tools Used:
Tableau
Skills Demonstrated:
Data visualization, calculated fields, interactivity, drill-downs, dashboard design
Dashboard Preview
Business Recommendations:
- Prioritize high-performing sub-categories like Phones, Chairs, and Copiers in promotions and stock planning to maximize profits.
- Reevaluate underperforming sub-categories such as Tables, Bookcases, and Supplies, which are consistently unprofitable. Consider reducing discounts or phasing them out.
- Focus regional investments in the West and East regions, especially within the Consumer segment, where both sales and profits are strongest.
- Reassess the Corporate segment’s pricing strategy. Despite decent sales, profits are relatively low, indicating possible over-discounting or inefficiency.
- Identify and nurture top customers (e.g., Sean Miller, Tamara Chand) through loyalty programs or personalized marketing to encourage repeat purchases.
- Set smarter discount strategies based on profitability. Scatterplot analysis shows that higher discounts don’t always lead to higher profits.
- Plan proactively for seasonal sales peaks in November and December. Consider launching targeted campaigns and bundles in Q4.
