4. Modeling Data
Multiple Fact Tables
Filter Context and Flow
Tip: Arrange lookup tables above fact tables to show the filter relationship flows downstream
Be careful when choosing identically named keys - you want to grab one that actually is from a lookup table or one that flows.
