Datasets

Event Tickets and Direct Costs Dataset

Compare net ticket receipts with event capacity and direct vendor costs.

A practical workbook exercise for event finance and venue analysts. Work from the underlying records, compare the relevant totals and explain how you reached your result.

About the dataset

This original synthetic dataset contains 684 source records across three related tables. The records are fictional and designed for descriptive business analysis.

Dataset details

IndustryEvents and venues
FormatsExcel workbook and CSV files
Source records684
Related tables3
Fields across table schemas13
Reporting cutoffSeptember 30, 2026
CurrencyUSD for monetary fields
SourceOriginal synthetic data created for Jolene.pro Workbook Studies

What's included

  • Events: 12 records and 4 fields. One event.
  • Tickets: 600 records and 5 fields. One paid ticket, with full-refund flag.
  • Costs: 72 records and 4 fields. One direct vendor cost assigned to an event.

Recommended analysis

  • Which events cover their direct costs?
  • How do refunds affect ticket receipts?
  • What share of capacity was sold and retained?
  • Which direct cost categories dominate?

How to work with the data

Use the following relationships to connect the source tables:

  • Tickets.event_id → Events.event_id
  • Costs.event_id → Events.event_id

Check the row grain before joining. Aggregate repeated child records to the required level before combining totals, so parent amounts are not counted more than once.

You can explore the workbook in Excel or Jolene.pro, or use the CSV files with SQL, Power BI and other analysis tools.

Definitions and assumptions

  • Ticket amount is gross cash received inclusive of applicable tax. Refunded tickets reverse the full amount.
  • No sponsorships, complimentary tickets or overhead are modeled. Ticket sales are not confirmed attendance.

Use the field definitions and nullable-column guidance in the included data dictionary. Interpret blank values and reporting dates according to the scenario notes.

Downloads

The complete dataset ZIP includes the Excel workbook, three matching CSV files, a data dictionary, scenario notes, a source-row preview and license details.

Reuse and attribution

These are synthetic records, not customer data or industry benchmarks. Reuse is allowed under Creative Commons Attribution 4.0 International (CC BY 4.0). Credit Jolene.pro and identify any changes you make.

Creative Commons Attribution 4.0 International license

Leave a comment