Sumários

Week 6

26 Março 2024, 15:00 • Márcia Cristina Afonso Barros

Project support.

Dimensional modeling (part 3)

26 Março 2024, 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 4

19 Março 2024, 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.

week 4

19 Março 2024, 15:00 • 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.

Dimensional modeling (part 2)

19 Março 2024, 13:00 • António Ferreira

Dimensional modeling (part 2): retail sales example; primary keys and degenerate dimensions; date dimension; hierarchies in dimensions; surrogate keys in dimensions; snowflaking; analysis of dimensional models; additive, non-additive, and semi-additive measures; factless fact tables.