Technical communities · SINGAPORE
Singapore analytics workshops: a field name may leave out the measurement unit
Confirm the value’s documented unit before converting it or labelling a chart.
By Boardzip · Published · Updated
Boardzip uses AI-assisted guide research, writing and review. Read how we research guides and check sources →
Start with these checks
- The exercise includes dataset definitions as well as rows
- Participants can trace a chart measure to its documented unit
- A transformation can be checked with a small public example
The problem
A Singapore spreadsheet learner downloads a public table whose measure has no unit in its header and guesses the scale from the size of its values before building a chart.
Look beyond the short header
Keep the public dataset link, field description and any explanatory notes with your working file. Data.gov.sg’s content guidance recommends omitting measurement units from column headers. An abbreviated name can therefore be intentional; it is not evidence that the values have no unit. Find the actual definition before deciding how the chart should describe them.
- Data.gov.sg: Data types ↗ · Source checked
Write down the unit and remaining uncertainty
Record what the documentation establishes about the measure, including its scale where supplied. If the unit is absent from the available description, retain that uncertainty and ask the source owner. A familiar range of numbers is only a clue. Multiplying until the values look plausible can create a convincing chart whose labels no longer describe the input.
Show a conversion as a separate operation
When a conversion is supported, keep an original value beside the transformed value and record the rule you applied. Work through one small example before changing every row. Check whether all compared fields use the same documented unit and concept. Converting a unit does not by itself make different measures suitable for comparison.
Choose a session that reads the data definition
Bring the source note, your proposed label and the example calculation. Ask the facilitator to inspect their relationship before discussing chart appearance. Boardzip’s free search can help find analytics and visualisation workshops; check whether the advertised exercise includes metadata and transformations. A ready-made chart template may provide no opportunity to resolve the unit you are missing.
Questions and answers
Can I infer the unit from a familiar-looking value?
Use the source’s definition. The size of a number does not establish its measurement unit or scale; leave the point unresolved if the documentation does not answer it.
Does the guidance mean every public dataset omits units?
No. It is a recommendation in the cited data.gov.sg content guidance. Read the actual dataset’s field definitions and notes rather than assuming a universal naming rule.
Sources and further reading
These references provide the guide’s source context and further reading. They do not confirm a current event, admission or an available place; check each listing’s organiser terms for those conditions.
- Data.gov.sg: Data types ↗Source checked
Each date belongs to the linked source check. These references provide source context; a recorded date does not by itself establish a completed independent review. Current event admission is checked separately in each listing. How to read the source dates →
Current listings to check
Topic matches from the verified Singapore feed. A matching topic does not confirm audience suitability, accessibility or available places; read the organiser’s terms.
No current verified listings match this guide’s search terms. Try a broader search or suggest an organiser we should check.
Browse the broader event category →Suggest a relevant organiser →