Assessments
Assessments are built around a star database schema with Answer records at the center, and two branches for Questions and Samples. Samples group multiple answers in a coherent set (ex: they were entered at the same time), but otherwise can be seen as a transparent link to connect an answer to a profile. Questions are used as a metric to measure a profile on. They can also be grouped into a coherent set, through a questionnaire.
Recorded answers form an OLAP Cube that supports a variety of use cases to analyze how profiles' metrics change over time.
Example: Tracking an athlete performance
| Question | Height |
|---|---|
| Question | Weight |
| Question | Time on 100m sprint |
| Sample.account | Mathew |
| Sample.account | Joe |
Example: Implementing a suppliers compliance program
| Question | Does your company has a Code of Conduct? |
|---|---|
| Question | Has your company conducted an materiality assessment? |
| Sample.account | Trucks & co |
| Sample.account | Minesota Accountant Services |
Learn more about building an ESG product »
Unit systems
Each measurement recorded as a part of an answer has an associated unit. The following unit systems are suppported:
- standard (kg, m, etc.) - see wikipedia definition
- imperial (lbs, ft, etc.) - see wikipedia definition
- rank, a unit for generic numbers that can be compared with less than and greater than operators (ex: score, points, etc.)
- enum, a unit for a finite set of values for which ordering is not meaningful (ex: gender, country code, yes/no/NA, etc.)
- freetext, an escape unit for comments and other free form text.
For storage and performance reasons, the scale is also encoded in the units (ex: kilograms and grams exist as unit models). The APIs support conversion between units whenever a linear equivalence exists (ex: kg to g, or kg to lbs).
- Need help?
- Contact us
- Curious how it is built?
- Visit us on GitHub