Superstore Profitability Analysis

This project involved an in-depth exploration of the Superstore's sales, customer, and product data. The core objective was to move beyond top-line revenue figures and uncover the true drivers of profitability. Using Tableau, a dynamic "Business Performance Dashboard" was developed to visualize critical insights that empower departments across the organization to collaborate on strategies for growth, cost reduction, and improved customer service.

Dataset

• Data Type: Synthetic dataset
• Purpose: It was synthetically generated for analytical and visualization practice, ensuring no real user or proprietary data is used while maintaining the statistical integrity and relational complexity found in genuine platform data.
• About: This dataset contains transactional sales records from a fictional retail company called "Superstore," representing a sample of orders processed between 2014 and 2018.

Objectives

• Identify and rank the top customers by their net profitability, not just revenue.
• Analyze the revenue and profit contribution from each customer segment (Consumer, Corporate, Home Office) for key accounts.
• Pinpoint the "Strategic Accounts" that are most critical to the company's financial health.

Dashboard

Key Findings

• Customer Profitability Tiers: Identified and segmented the top customers by their actual profit contribution, with Anna Andreadi emerging as the most profitable customer, generating over $108K in profit.
• Revenue vs. Profit Analysis: Discovered critical nuances in customer value. For instance, while a customer like Chuck Magee generates significant revenue across all segments (Corporate, Consumer, Home Office), his overall profitability is lower than Anna Andreadi's, suggesting potential differences in product mix, discounting, or shipping costs.
• Segment Performance: Broke down revenue generation by customer segment (Consumer, Corporate, Home Office) for each top customer, providing a clear view of which segments are the most valuable and how they contribute to each key account's profile.

Technologies

• Excel
• Tableau

Featured Deliverables

• Tableau Dashboard: Business Performance

Getting Started

1. Clone this repo (for help see this tutorial).
2. Raw Data is being kept here within this repo.