Dimensional modeling (part 1)

15 Março 2022, 13:00 • António Ferreira

Dimensional modeling (part 1): measures, dimensions, and facts; approaches to obtaining dimensions; data cube revisited; navigating the data cube; fact tables and dimension tables; fact table grain; dimensional modeling procedure; logical and physical design. Analytical queries in SQL; classic approach; OLAP extensions for SQL-99.