SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

Business analysis glossary

NULL Value

What it is

NULL in a database means a value is missing or unknown. It is not the same as zero or an empty string. Comparisons with NULL do not return true or false in the usual way, so SQL uses IS NULL and IS NOT NULL to test for it.

Why it matters

Mishandled NULLs cause wrong counts, dropped rows and wrong totals. Business rules should say what an empty value means, for example not yet known or not applicable. Analysts must ask this during requirements and check how reports treat empty values, because users usually assume blanks are zero.

Example

A report shows that only forty percent of shipments have a delivery date. The analyst checks and finds the rest are NULL because they are still in transit, not because data is missing. The dashboard label is changed to delivered shipments, and in transit shipments get their own count.

CHECK BEFORE CONTINUING

Keep your work safe