jocapc/ContosoRetailDW

---
license: mit
language:
- en
tags:
- finance
---

# Contoso Retail Data Warehouse – Dataset Overview

This dataset represents the **Contoso Retail Data Warehouse**, a sample analytical model
commonly used for demonstrations involving SQL, ETL, BI, data modeling, and analytics.
This data is used in the [Synapse tutorial](https://docs.azure.cn/en-us/synapse-analytics/sql-data-warehouse/sql-data-warehouse-load-from-azure-blob-storage-with-polybase#create-the-external-tables)

In this distribution, **each table is stored as a separate ZIP file**.
Every ZIP contains pipe-separated text files representing that table’s data.

```

ContosoRetailDW/
├── DimCustomer.zip
│ ├── QID8828_20170924_35754_1.txt
│ ├── QID8828_20170924_35754_2.txt
│ └── ...
├── FactSales.zip
│ ├── QID8927_20170924_35812_1.txt
└── ...

```

These files can be imported into SQL databases, Fabric Warehouse/Lakehouse, Synapse, or any analytics platform that supports delimited text ingestion.

---

# 📊 Table Overview

Tables are grouped into **Dimension** and **Fact** tables.

---

# 🟦 Dimension Tables

### DimAccount
Chart of accounts used for financial reporting and planning.

### DimChannel
Sales channels such as online, in‑store, catalog, and partner routes.

### DimCurrency
List of global currencies with ISO codes and attributes.

### DimCustomer
Retail customers with demographic and location attributes.

### DimDate
Calendar table used for time‑based analytics.

### DimEmployee
Employee information including roles, departments, and hierarchy.

### DimEntity
Organizational units used for budgeting and planning.

### DimGeography
Countries, cities, and regions with geographical details.

### DimMachine
Details about IT or production machines tracked by the business.

### DimOutage
Outage and downtime classifications.

### DimProduct
Products sold by Contoso, including SKU‑level details.

### DimProductCategory
High-level product categories.

### DimProductSubcategory
Subcategories nested under product categories.

### DimPromotion
Marketing promotions and discounts applied during sales.

### DimSalesTerritory
Sales regions and territories.

### DimScenario
Scenario classifications such as Actual, Budget, Forecast.

### DimStore
Retail store locations with size, type, and related attributes.

---

# 🟥 Fact Tables

### FactExchangeRate
Daily or periodic currency exchange rates.

### FactInventory
Inventory levels by product, store, and date.

### FactITMachine
Operational metrics for machines in DimMachine.

### FactITSLA
Service Level Agreement (SLA) performance metrics for IT assets.

### FactOnlineSales
Transaction-level online sales including customer, product, and amounts.

### FactSales
Comprehensive sales transactions across all sales channels.

### FactSalesQuota
Sales targets per employee, region, or period.

### FactStrategyPlan
Strategic financial and operational planning measures.

---

# 📥 Usage Notes

- Can be loaded using:
- BULK INSERT / COPY INTO / PolyBase / OPENROWSET
- Azure Fabric, Synapse, Data Factory
- Python, Spark, or other ETL frameworks
- This dataset follows a classic **star schema** used for retail analytics.