Sumários

Week 5: March 14th

14 Março 2023, 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)

14 Março 2023, 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.

Week 4: March 7th

7 Março 2023, 16:30 • Márcia Cristina Afonso Barros

Multidimensional analysis with Excel: demonstration of pivot tables in Excel; placing attributes on columns and rows of a report; calculating aggregate values such as sums and averages; applying filters to data; creating new attributes with values derived from other attributes.

Week 4: March 7th

7 Março 2023, 15:00 • Márcia Cristina Afonso Barros

Multidimensional analysis with Excel: demonstration of pivot tables in Excel; placing attributes on columns and rows of a report; calculating aggregate values such as sums and averages; applying filters to data; creating new attributes with values derived from other attributes.

Dimensional modeling (part 1)

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