Superstore Dataset
The Superstore dataset represents a retail store selling to customers in the US from 2018 to 2021. It is fictional data. It is useful as an exercise in data modelling and DAX.
Data
There are several tables:
- Transactions – this is a fact table. It contains several numerical fields, sales, Quantity and Profit. These are values that we want to group and aggregate. It has a lookup field (foreign key) into the four tables below
- Products – a dimension table that lists each product and grouping into categories and subcategories
- Customers – a dimension table that lists each customer and their segment
- Locations – a dimension table that lists the post code and broader geographical attributes (City, State, Region)
- Orders – a dimension table that lists each individual order, the dates when it was ordered and shipped and the ship mode (how it was shipped)
These are available in a single Excel spreadsheet here. Each dataset is a separate Excel table.