Dimensional modeling Part II - VIDEOCONFERENCE

24 Março 2020, 13:00 • André Osório e Cruz de Azerêdo Falcão

Dimensional modeling
–Retail sales example
–Primary keys and degenerate dimensions
–Date dimension
–Attribute hierarchies in dimensions
–Surrogate keys in dimensions
–Snowflaking
•Dimension analysis
–Intelligibility versus performance
•More about fact modeling
–Measures, additivity, and semi-additivity
–Factless fact tables