Sumários
Dimensional modeling (part 4)
28 Março 2023, 13:00 • António Ferreira
Dimensional modeling (part 4): hierachies and bridge tables; multivalued dimensions; fact tables of types transaction, periodic snapshot, and accumulating snapshot; modeling recommendations; rules to follow; mistakes to avoid.
Dimensional modeling (part 3)
21 Março 2023, 13:00 • António Ferreira
Dimensional modeling (part 3): slowly changing dimensions (SCD); types of SCD techniques; monster dimensions and outriggers; role-playing dimensions; conformed dimensions. Master Data Management; relation with operational systems and data warehouses; implementation procedure; principles for effective master data management; expected benefits and reasons for failure.
Week 5: March 14th
14 Março 2023, 16:30 • Márcia Cristina Afonso Barros
Dimensional modeling with Excel: conversion of a single retail sales table into dimension tables with descriptive attributes and a fact table with foreign keys and measures in Excel; using the dimension and fact tables in Power BI to generate reports.