Multi-location retail & production chain: POS, Postgres/dbt warehouse, email and chat (7 years)

~1.06M line-item POS orders, a Postgres + dbt operations warehouse with demand-forecasting models, ~150K emails and ~54K team messages

Seven years of a multi-location food and hospitality operator with central production, catering and wholesale: line-item POS orders since 2020, a Postgres + dbt operations warehouse since 2022 (production lists, end-of-night counts, waste, inventory, till audits and a demand-prediction model), wholesale and catering orders, customer-service mailbox foldered by request type, executive mailbox, team chat since 2019, ops meeting notes with transcripts, SOPs and accounting.

What's inside

~1.06M POS orders; ~151K emails; ~54K chat messages; ~2,400 documents; ~80 dbt models; ~50 GB total

• ~1.06M POS orders at line-item level (2020–2026)
• Postgres + dbt operations warehouse (~80 dbt models, ~1,100 commits)
• Production lists, inventory counts, waste logs, and demand-prediction model
• Customer mailbox ~36K messages (foldered by inquiry type) + owner mailbox ~115K
• ~54K team-chat messages, meeting notes, and ~100 filed operational decisions
• ~2,400 Drive files, SOPs, and full accounting ledgers

Systems & tools included

Delivery & format

Formats

Database exports, SQL / dbt, MBOX, JSON, Documents

Delivery

Download / S3

Total size

10–100 GB (0.05 TB)

Time span

2019–2026 (7 years)

Origin

First-party company records

Sample

Available under NDA