Superstore Dataset

The Superstore Dataset is a popular retail analytics dataset containing transaction-level information from a fictional superstore business. It includes 9,994 data records and 21 columns covering order details, customer information, geographic data, product information, sales, quantity, discounts, and profit.

The dataset covers orders from 2014 through 2017 and includes information across different customer segments, product categories, regions, and shipping methods. Therefore, it provides a useful structure for studying retail sales and business performance.

Because the data combines operational and financial attributes, users can analyze sales trends, product performance, regional results, customer segments, and the relationship between discounts and profitability.

Key Features

• 9,994 retail transaction records
• 21 data columns
• Order and shipping information
• Customer and customer-segment information
• City, state, postal code, and regional data
• Product and category information
• Sales and quantity data
• Discount information
• Profit and loss information
• Data covering 2014–2017
• Suitable for business intelligence and data visualization

Data Included in the Dataset

The dataset contains several groups of information that support different types of retail analysis.

Order and Shipping Data

The dataset includes:

• Row ID
• Order ID
• Order Date
• Ship Date
• Ship Mode

These fields can help users study order volumes, shipping methods, delivery patterns, and sales trends over time.

Customer Information

Customer-related fields include:

• Customer ID
• Customer Name
• Segment

The segment field identifies groups such as Consumer, Corporate, and Home Office. This information can support customer segmentation and purchasing analysis.

Geographic Information

The dataset includes:

• Country
• City
• State
• Postal Code
• Region

These fields allow users to compare sales and profitability across different geographic areas.

Product Information

Product-related fields include:

• Product ID
• Category
• Sub-Category
• Product Name

The main categories include Furniture, Office Supplies, and Technology, with multiple sub-categories underneath them.

Sales and Profit Information

The financial fields include:

• Sales
• Quantity
• Discount
• Profit

These attributes allow users to analyze revenue, units sold, discount levels, and profitability.

Applications of the Dataset

Sales Analysis

The dataset can help analyze sales performance across products, categories, regions, customers, and time periods. For example, users can compare sales by year, region, or product category.

Profitability Analysis

Sales alone do not show the complete business picture. Therefore, users can combine sales, discounts, and profit to identify profitable and loss-making products or categories.

Customer Segmentation

The customer segment field supports analysis of Consumer, Corporate, and Home Office groups. Researchers can compare purchasing behavior and business performance across these segments.

Regional Analysis

Geographic fields allow users to study sales and profit across states, cities, and regions. As a result, businesses can explore regional differences in performance.

Product Performance Analysis

Product, category, and sub-category information can help identify products with strong sales, high profit, low profit, or negative profit.

Discount Analysis

The discount field can be analyzed alongside sales and profit to understand how discount levels relate to profitability. This makes the dataset useful for pricing and promotional analysis.

Business Intelligence Dashboards

The structured data works well for dashboards and interactive reports. Users can build visualizations in tools such as Power BI, Tableau, Excel, or Python-based analytics environments.

Machine Learning and Data Science

The dataset can also support educational machine learning projects involving sales prediction, profit analysis, customer segmentation, and exploratory data analysis.

Why Use the Superstore Dataset?

The dataset combines multiple business dimensions in one structured source. Therefore, users can analyze customers, products, geography, orders, sales, discounts, and profit without combining several unrelated datasets.

Moreover, its manageable size makes it suitable for learning and practicing data analysis. Users can work with spreadsheets, SQL, Python, Power BI, Tableau, or other analytics tools.

The dataset also provides enough dimensions for users to move beyond simple sales totals and investigate relationships between products, customers, regions, discounts, and profitability.

Who Can Use This Dataset?

The dataset can be useful for:

• Data analysts
• Business intelligence professionals
• Data science students
• Machine learning students
• Business analysts
• Retail analytics researchers
• Power BI learners
• Tableau users
• Excel users
• Python and SQL learners
• Academic researchers

Conclusion

The Superstore Dataset provides a practical resource for retail analytics, business intelligence, and data science projects. With 9,994 transaction records and 21 columns, it combines order, customer, product, geographic, sales, discount, and profit information in one dataset.

Furthermore, users can apply the data to sales analysis, profitability research, customer segmentation, regional comparisons, product analysis, and interactive dashboard development. Therefore, it can serve as a useful dataset for both learning and practical analytics projects.

The dataset is sourced from Kaggle.