Measure unique corporate training participants without confusing enrollments, cohort transfers, attendance and program completion.
Index
One person may switch cohorts or retake a module. Adding enrollments as unique learners artificially increases the program's reach.
What the quote needs to include
Separate identity, enrollment by offering and attendance by session. Do not infer learning from platform access or enrollment counts alone.
Reporting does not certify competence or official recognition of training.
Request mappings among participant records, course offerings and attendance events. People may have several email addresses or change employers, so identity should not depend exclusively on those fields. Agree with coordinators what completion means: attendance requirements, submitted work or another program condition. Apply the valid rule to the relevant offering and allow inspection. Test withdrawal, transfer and return in a later edition. If the current platform already exports reliable enrollment and attendance, a reconciliation layer may suffice. The project should answer capacity or reach questions without turning access records into evidence of learning. Separate organizational access rights when employers can view only their own participants.
Specific acceptance criteria
- Keep stable identity without deduplicating only by name.
- Retain history for cohort transfers.
- Define enrolled, attending and completing populations separately.
The exception that determines acceptance
One person switches cohorts after two sessions. Acceptance must count one participant while preserving enrollments and attendance without duplication.
Reference for assessing scope
Official Power BI modeling guidance
Prepare your project with Quantum9
Discuss this scope with Quantum9 and bring an anonymized sample for discovery.