Skip to content

Job simulations / FREE RESOURCE

Data analyst job simulation: campus events

Clean a synthetic dataset, calculate attendance rates and write a decision memo.

2026 edition · By EgoTECH · No login required
← All job simulations

Fictional practice brief · Suggested effort: 2–4 hours · Not a job offer, hiring test or certificate.

Your assignment

A fictional campus organization has a limited event budget. Recommend which event formats to repeat. The dataset intentionally includes a duplicate and a missing value so you must explain your cleaning decisions.

Download starter brief / data

1. Audit the data

Describe each column and row grain. Count rows, locate duplicates and missing check-ins, and preserve the raw file.

2. Analyze responsibly

Calculate attendance rate as check-ins divided by registrations for valid rows. Compare event formats and report sample sizes.

3. Build a small report

Show a table or chart of format-level results and a cost-per-attendee calculation. Avoid claiming a format caused higher attendance.

4. Make a recommendation

Write a 200-word memo with one recommendation, one caveat and one data collection improvement. Include your reproducible queries or script.

Review your submission

Choose 0 = missing, 1 = partial, or 2 = demonstrated with evidence. The result is your self-assessment.

Self-review: 0 / 8

Reviewer guidance

Remove the exact duplicate E03 once and document it. Do not replace a missing check-in count with zero without justification. For a pooled attendance rate, divide total valid check-ins by total registrations for the same included rows; do not average percentages with unequal denominators.

Notes save on this device. Avoid entering passwords or sensitive information.

Keep exploring