Aller au contenu principal

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.

data-modeling5 min read

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.

← Back to library

Nous contacter