DemoDataWorks

Retail

Realistic retail ERP data for SQL, Power BI, and analytics.

A complete synthetic retail ERP-style environment spanning sales, purchasing, inventory, receivables, payables, and the general ledger — delivered with multiple database formats, Power BI, SQL examples, validation, and documentation.

32 connected ERP tables

Buy NowBack to Industries
Included Power BI — Executive Overview
Executive Overview Power BI dashboard screenshot
  • Synthetic data
  • 10 core business industries
  • CSV, SQLite, DuckDB, Parquet, SQL Server & PostgreSQL
  • Power BI dashboard included
  • Validation & documentation

Coherent business flows, not disconnected rows.

Every table connects to the next, so you can trace a single transaction from end to end — and build dashboards that actually reconcile.

Order to cash

Sales order
Shipment
Invoice
Customer payment
Accounts receivable
General ledger

Purchase to pay

Purchase order
Goods receipt
Vendor invoice
Vendor payment
Accounts payable
General ledger

Inventory

Inventory movements
Inventory balances

What the dataset covers

  • Customers, products, and product categories
  • Sales orders and sales invoices
  • Shipments and order fulfillment
  • Customer payments and accounts receivable
  • Vendors and purchase orders
  • Goods receipts against purchase orders
  • Vendor invoices and accounts payable
  • Inventory movements and on-hand balances
  • Chart of accounts and general ledger journals
  • Price lists and item-level pricing

A Power BI dashboard, ready to open.

Every pack includes a populated .pbix dashboard and a reusable .pbit template built directly on top of the dataset.

Executive Overview Power BI dashboard screenshot

Executive Overview

Revenue, margin, sales, inventory, receivables, and payables at a glance.

Sales & Inventory Performance Power BI dashboard screenshot

Sales & Inventory Performance

Product, purchasing, inventory movement, vendor, and delivery performance.

Financial Performance Power BI dashboard screenshot

Financial Performance

Revenue, COGS, receivables, payables, and general-ledger activity.

Everything you need, in every format you use.

One purchase, every format — no conversion required.

CSV, SQLite, DuckDB & Parquet

Every table available in four portable data formats.

SQL Server, ready to restore

Create/load scripts, SQL Server-compatible CSVs, a ready-to-restore .bak file, and a PowerShell loader.

PostgreSQL scripts

Create and load scripts for PostgreSQL.

Power BI dashboard

A populated .pbix report plus a reusable .pbit template.

SQL query packs

Executive, KPI, analysis, and validation queries.

Full documentation

Data dictionary, table relationships, business process guide, KPI reference, database loading guide, Power BI guide, and exercises.

Validation & Quality Checks

Validation report, row counts, and packaged validation queries to help verify the dataset.

Standard Product License

One license covers the full package — see the license file included with your download.

Compare supported output formats

Built for how the data actually gets used.

Power BI portfolio projects

Build a dashboard on data with real depth instead of a toy dataset.

SQL practice

Write joins, aggregations, and window functions against real relationships.

Analytics training

Give students or trainees a shared dataset built for classroom use.

BI & software demos

Show a working demo backed by data that behaves like a real business.

Consulting & client prototypes

Prototype a client solution without exposing real business data.

KPI & model validation

Test that your KPI logic and models hold up against multi-table source data.

Data modeling & reporting practice

Build relationships, measures, reporting logic, and analytical models against connected business data.

Development & testing

Use a realistic dataset to build and test data pipelines and applications.

Data engineering practice

Build and test transformations, pipelines, joins, and data workflows against a realistic relational source.

Get the Retail ERP pack.

One license, everything included.

Retail ERP Demo Database & BI Pack

$14.99USD

one-time purchase · tax included

DemoDataWorks Standard Product License

  • CSV, SQLite, DuckDB & Parquet
  • SQL Server, ready to restore
  • PostgreSQL scripts
  • Power BI dashboard
  • SQL query packs
  • KPI reference & business metrics
  • Full documentation
  • Validation & Quality Checks
  • Standard Product License
Purchase & Download

Frequently asked questions

Need more scale, or a fresh Retail ERP variation?

Generate your own dataset with DemoDataWorks when you need a different company, larger data volume, or a fresh deterministic variation for another project.

Choose an industry, select the scale you need, configure supported options, and generate a complete synthetic business environment.

Generate Your Own

Related industries

Manufacturing

Manufacturing ERP

View pack

Logistics & Supply Chain

Logistics & 3PL

View pack

Software / SaaS

B2B SaaS

View pack
View all industries

Ready to get started?

Browse the ready-made industry packs, or generate your own.

Browse Industry PacksGenerate Your Own