DemoDataWorks

Realistic ERP demo data for SQL, Power BI, and analytics training.

A complete synthetic retail ERP-style dataset with sales, purchasing, inventory, AR/AP, GL, CSV exports, SQLite, DuckDB, and a Power BI dashboard.

Executive Overview.pbix
Executive overview dashboard built in Power BI
  • Synthetic data
  • ERP-style workflows
  • SQL Server + CSV + SQLite + DuckDB
  • Power BI dashboard included
  • Validation checks included

Most free datasets fall apart the moment you try to build something real.

A single spreadsheet or one flat table can't support a real Power BI dashboard, a consultant demo, or a proper SQL practice environment. It's too small, too disconnected, and too unrealistic to hold up under real business questions.

Typical free dataset

  • One flat, disconnected table
  • A few hundred rows — too small for real dashboards
  • No AR/AP, no GL, no inventory movement
  • Random values with no realistic business logic

DemoDataWorks

  • A connected, ERP-style schema
  • Enough volume to build real Power BI dashboards
  • Full order-to-cash and purchase-to-pay flows
  • Coherent, realistic business behavior throughout

Coherent business flows, not disconnected rows.

Every table connects to the next, so you can trace a single transaction from the sales floor all the way to the general ledger — and build dashboards that actually reconcile.

Order to cash

Sales order
Shipment
Invoice
Payment
AR
GL

Purchase to pay

Purchase order
Goods receipt
Vendor invoice
Vendor payment
AP
GL

Inventory

Inventory movements
Inventory balances

A Power BI dashboard, ready to open.

Paid editions include a finished .pbix dashboard and a reusable .pbit template built directly on top of the dataset.

Executive Overview Power BI dashboard screenshot

Executive Overview

Company-wide KPIs at a glance

Sales Performance Power BI dashboard screenshot

Sales Performance

Orders, revenue, and trends by channel

AR Dashboard Power BI dashboard screenshot

AR Dashboard

Aging, collections, and open balances

GL & Finance Power BI dashboard screenshot

GL & Finance

General ledger and financial summaries

Everything you need, in every format you use.

One purchase, every format — no conversion required.

SQL Server database

A full .bak file, ready to restore and query directly.

CSV exports

Every table exported to CSV for any tool or language.

SQLite database

A single-file database for lightweight local practice.

DuckDB database

An analytics-ready file for fast local SQL workflows.

Power BI dashboard

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

SQL query packs

Analysis queries, KPI queries, and an executive summary query.

Documentation

Data dictionary, relationship documentation, and restore instructions.

License options

Individual, consultant, and team/training licenses.

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.

BI demos

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

Analytics training

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

Consulting & client mockups

Prototype a client solution without exposing real business data.

Dashboard KPI validation

Test that your KPI logic holds up against multi-table source data.

Simple, one-time pricing.

Start free, then unlock the full SQL Server Edition whenever you're ready.

Free Sample Pack

$0

Try the data before you buy.

  • Coherent sales-side CSV sample
  • Sample SQL queries
  • Free sample license
Get Free Sample
Most Popular

Individual License

$49

The full dataset, every format, one user.

  • Full SQL Server .bak database
  • Full CSV exports
  • SQLite and DuckDB databases
  • Power BI dashboard + template
  • SQL analysis & KPI query packs
  • Documentation & data dictionary
  • Individual-use license
Buy Individual License

Consultant License

$199

Everything in Individual, cleared for client work.

  • Everything in Individual License
  • Use in unlimited client demos
  • Consultant-use license terms
  • Priority email support
Buy Consultant License

Team / Training License

Contact us

Multi-seat access for teams and training programs.

  • Multi-seat team access
  • Training & bootcamp use
  • Custom invoicing available
  • Volume pricing available
Contact Us

Frequently asked questions

Ready to build something real?

Start with the free sample, or get the full SQL Server Edition with everything included.