Nora NA Analyst Nora wants to model campaign participation but thinks the lack of a numeric measure disqualifies it from being a fact table. If she invents a fake metric, the warehouse will encode confusion instead of event truth. No $ numeric measureavailable Yes/No occurrence question Fake measures createfalse semantics A fact can represent occurrence The row itself can be the measurable unit when the analytic question is “did it happen?” or “who was covered?” Invent a score column Makes the table look familiar but teaches the wrong semantic lesson. A clean factless fact instead of a fake metric table.…
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in