Retail Sales Analysis · Step 1 of 5

Introduction

A comprehensive analysis of a retail dataset containing 9,994 transactions over four years (2014-2017) to identify sales patterns, profitability drivers, and growth opportunities.

Project Overview

I conducted a comprehensive analysis of a retail dataset containing 9,994 transactions over four years (2014-2017) to identify sales patterns, profitability drivers, and growth opportunities for a national retail chain. Using Excel for data preparation and Tableau for visualization, I created an interactive dashboard that provides actionable insights to optimize sales strategy and improve profit margins.

Business Challenge

The retail chain needed to optimize operations across regions and product categories to improve overall profitability. Key challenges included:

  • Inconsistent Performance: Significant variations in regional and product category profit margins
  • Pricing Strategy: Unclear impact of discounting on overall profitability
  • Resource Allocation: Uncertainty about where to focus marketing and inventory investments
  • Growth Planning: Limited visibility into emerging trends and opportunities

Project Goals

  1. Identify the most and least profitable regions, categories, and products
  2. Analyze the impact of discounting on profit margins
  3. Discover seasonal sales patterns for inventory planning
  4. Understand customer segment performance across regions
  5. Develop actionable recommendations to increase overall profitability

Key Business Questions

To guide my analysis, I focused on answering these critical business questions:

1. Profitability Analysis

  • Which regions generate the highest profit margins, and why?
  • Which product categories and sub-categories should be prioritized or reconsidered?
  • What are the top 5 and bottom 5 products by profitability?

2. Pricing Strategy

  • How do different discount levels affect overall profit margins?
  • Is there an optimal discount threshold that maintains profitability?
  • Do discount impacts vary across product categories?

3. Seasonal Patterns

  • When do sales peak and trough throughout the year?
  • Are there consistent seasonal patterns across all four years?
  • How should inventory and marketing be adjusted for seasonality?

4. Customer Insights

  • Which customer segments deliver the highest value?
  • How does segment performance vary by region?
  • What targeting strategies could improve overall profitability?

5. Growth Opportunities

  • Which regions and products show the strongest growth trajectory?
  • What specific actions could increase profit margin by at least 3 percentage points?
  • Where should resources be allocated for maximum return?

Tools & Technologies

Microsoft Excel Tableau Data Cleaning Pivot Tables Time Series Analysis Profitability Metrics