Superstore Retail Dataset
Retail
Beginner
CSVXLSX
CategoryRetail
DifficultyBeginner
Rows10K (9,994)
Columns10
File Size2.1 MB
FormatsCSV, XLSX
LicenseFree for commercial & personal use
Downloads31,220+
Last Updated14 Jul 2026
CreatorDataVix
About this dataset
The Superstore Retail Dataset is the most popular starter dataset in analytics: four years of retail orders across regions, customer segments and product categories, with sales, quantity, discount and profit on every line. It’s the fastest path to your first end-to-end Power BI or Excel dashboard and a great SQL playground for joins, aggregations and window functions.
Dataset Contents
The tables included in this dataset and what each one holds.
| Table | Description | Rows |
|---|---|---|
Orders |
One row per order line with sales, quantity, discount and profit. | 10K |
Returns |
Orders flagged as returned. | 800 |
People |
Regional managers mapped to sales regions. | 4 |
Columns Included
Key columns with their datatypes and meaning.
| Column | Datatype | Description |
|---|---|---|
order_id |
VARCHAR | Unique order identifier. |
order_date |
DATE | Date the order was placed. |
ship_date |
DATE | Date the order shipped. |
segment |
VARCHAR | Consumer, Corporate or Home Office. |
region |
VARCHAR | Sales region. |
category |
VARCHAR | Furniture, Office Supplies, Technology. |
sales |
DECIMAL | Line sales amount. |
quantity |
INT | Units sold. |
discount |
DECIMAL | Discount applied (0–1). |
profit |
DECIMAL | Line profit. |
Skills You Can Practice
Power BI Dashboard
Excel Analysis
SQL Queries
Python Pandas
Data Cleaning
KPIs
Sales Analysis
Profit Analysis
Regional Analysis
Forecasting
Recommended Projects
01
Create a Sales Dashboard
02
Profit by Category
03
Regional Performance
04
Discount vs Profit Analysis
05
YoY Growth Report
06
Top Products
Preview
Click any image to enlarge.
Related Datasets
Frequently Asked Questions
Is this dataset free to download?
Yes. Every dataset on DataVix is 100% free to download — no signup, no paywall, no hidden cost. Just click “Download Dataset”.
How do I download the files?
Click the green “Download Dataset” button. Your download starts instantly as a single package containing all included file formats (CSV, XLSX).
Can I use this dataset for commercial projects?
Free for commercial & personal use. You’re free to use it in your portfolio, client work, YouTube tutorials, blog posts and courses — attribution to DataVix is appreciated but not required.
Which tools does this dataset work with?
It’s ready for Power BI, Excel, SQL, Python. The CSV/XLSX files import directly into Excel, Power BI, Python (pandas) and any SQL database.
Is this real or synthetic data?
It’s realistic, analysis-ready practice data modelled on real-world business scenarios and cleaned for learning — safe to share publicly with no personal or confidential information.