DemoDataWorks

Manufacturing

Manufacturing ERP data built for operations, SQL, and BI.

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

46 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.

Purchase to pay

Purchase order
Goods receipt
Supplier invoice
Supplier payment
General ledger

Production

Work order
Material issue
Labor & machine time
Production receipt
General ledger

Order to cash

Sales order
Shipment
Sales invoice
Customer payment
General ledger

What the dataset covers

  • Items, bills of material, and routings
  • Work orders and production tracking
  • Material issues and inventory movements
  • Labor and machine time entries
  • Production receipts, scrap, and quality inspections
  • Purchase orders and supplier invoices
  • Sales orders, shipments, and customer invoices
  • Standard costing and work-in-process
  • Chart of accounts and general ledger journals

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, production volume, scrap rate, and inventory value at a glance.

Operations & Supply Chain Power BI dashboard screenshot

Operations & Supply Chain

Production efficiency, quality, labor by work center, and procurement activity.

Financial Performance Power BI dashboard screenshot

Financial Performance

Revenue, COGS, general-ledger activity, and account balances.

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 Manufacturing ERP pack.

One license, everything included.

Manufacturing 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 Manufacturing 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

Retail

Retail ERP

View pack

Logistics & Supply Chain

Logistics & 3PL

View pack

Construction

Construction & Project Operations

View pack
View all industries

Ready to get started?

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

Browse Industry PacksGenerate Your Own