AdventureWorks
Adventure Works 2014 (OLTP version) is a sample database for Microsoft SQL Server, which has replaced Northwind and Pub sample databases that were shipped earlier. The database is about a fictious, multinational bicycle manufacturer called Adventure Works Cycles.
Original source: msftdbprodsamples.codeplex.com
Versions
AdventureWorks2014 (by Jan Motl)
- Ported from MSSQL
Dataset details
- Associated task:
- Regression
- Domain:
- Retail
- Data types:
- Size:
- 233.8 MB
- Count of tables:
- 71
- Count of rows:
- 754,248
- Count of columns:
- 486
- Missing values:
- Yes
- Compound keys:
- Yes
- Loops:
- Yes
- Type:
- Synthetic
- Instance count:
- 31,223
- Target table:
- SalesOrderHeader
- Target column:
- TotalDue
- Target ID:
- CustomerID
- Target timestamp:
- OrderDate
Algorithms
| Dataset version | Target | Algorithm | Author text | Measure | Value |
|---|---|---|---|---|---|
| AdventureWorks2014 | churn | FastProp | getML: Feature Learning with AutoML to build end-to-end prediction pipelines | AUC ROC | 0.9712 |
| AdventureWorks2014 | churn | Relboost | getML: Feature Learning with AutoML to build end-to-end prediction pipelines | AUC ROC | 0.9776 |
| AdventureWorks2014 | churn | Deep Feature Synthesis | featuretools | AUC ROC | 0.9677 |
| AdventureWorks2014 | churn | FastProp | getML: Feature Learning with AutoML to build end-to-end prediction pipelines | Accuracy | 0.9129 |
| AdventureWorks2014 | churn | Relboost | getML: Feature Learning with AutoML to build end-to-end prediction pipelines | Accuracy | 0.9273 |
| AdventureWorks2014 | churn | Deep Feature Synthesis | featuretools | Accuracy | 0.91 |
How to download the dataset
The datasets are publicly available directly from MariaDB database.
- Open your favourite MariaDB client (MySQL Workbench works, but see FAQ)
- Use following credentials:
- hostname: db.relational-data.org
- port: 3306
- username: guest
- password: relational
- Export "AdventureWorks2014" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).