Introduction

The Sample Superstore dataset is used to analyze retail sales performance, profitability, customer segments, regional performance, shipping methods, product categories, and the impact of discounts on profit. This project uses R and the ggplot2 package to create visualizations that help identify important business trends and support better decision-making.

Objectives

Methodology

The analysis was performed using R, ggplot2, dplyr, and plotly on the Sample Superstore dataset.

Dataset Description

The dataset contains 9,994 observations and 21 variables covering retail transactions from 2014 to 2017 across four regions of the United States.

Key variables include:

Graph 1: Total Sales by Product Category

Interpretation

The Technology category generated the highest total sales, followed by Furniture and Office Supplies. This indicates that technology products contribute the largest share of revenue in the Sample Superstore dataset. The visualization helps identify which product categories are the strongest revenue drivers and can assist managers in making inventory and marketing decisions.

Graph 2: Total Profit by Product Category

Interpretation

The Technology category generated the highest overall profit, indicating that it is the most profitable product category. Office Supplies also contributed positively, while Furniture earned comparatively lower profit. This visualization helps identify the product categories that contribute the most to business profitability and supports strategic business decisions.

Graph 3: Total Profit by Region

Interpretation

The chart compares total profit across the four regions. Regions with higher bars contribute more to overall profitability, while regions with lower bars may require improvement in sales strategies or cost management. This visualization helps managers identify the most and least profitable regions for better business planning.

Graph 4: Total Sales by Customer Segment

Interpretation

The Consumer segment generated the highest total sales, followed by Corporate and Home Office. This indicates that Consumer customers contribute the largest share of revenue. The chart helps managers understand customer purchasing patterns and focus marketing strategies on the most valuable customer segments.

Graph 5: Monthly Sales Trend

Interpretation

The line chart illustrates how total sales changed from month to month during the study period. Peaks represent months with stronger sales, while dips indicate lower sales activity. This trend analysis helps identify seasonal patterns and supports better sales forecasting and planning.

Graph 6: Top 10 Products by Sales

Interpretation

This chart identifies the ten products with the highest total sales. These products are the strongest contributors to revenue and may require priority in inventory management and marketing. Understanding top-performing products helps improve business planning and customer satisfaction.

Graph 7: Total Sales by Ship Mode

Interpretation

Standard Class generated the highest total sales, followed by Second Class, First Class, and Same Day. This indicates that customers most frequently preferred the Standard Class shipping option. Understanding shipping preferences helps businesses optimize logistics and improve customer service.

Graph 8: Relationship Between Discount and Profit

Interpretation

The scatter plot shows the relationship between discounts and profit across product categories. Higher discounts are generally associated with lower profits and, in some cases, financial losses. Lower discounts tend to produce higher and more consistent profits. This analysis helps managers balance promotional discounts with profitability.

Interactive Visualization

Description of the Interactive Visualization

The interactive scatter plot illustrates the relationship between sales and profit across different product categories. Users can explore individual data points to understand patterns in product performance and profitability.

Conclusion

This project analyzed the Sample Superstore dataset to identify key sales and profitability trends. Technology products generated the highest sales and profits, the West region was the most profitable, Consumer customers contributed the largest share of sales, and Standard Class was the most commonly used shipping method. The analysis also showed that higher discounts generally reduced profitability. These insights can help managers improve inventory planning, pricing strategies, and overall business performance.