Dialogue: Help an Analyst See the Need for a Factless Fact Table
Coach an analyst to model coverage or occurrence events with a factless fact table instead of inventing fake measures.
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.…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in