Sumários
Case studies in data warehousing
16 Abril 2024, 13:00 • António Ferreira
Case studies in data warehousing: order management, bus matrix, order requests, customers, prices in multiple currencies, profit and loss breakdown; customer relationship management, feed back to operational systems, outriggers, mini-dimensions, names and addresses, hierarchies; telecommunications, bus matrix, initial model, criticism, revised model; electronic commerce, clickstream, sessions and visits to individual pages, dimensions, fact tables with different grains.
week 7
9 Abril 2024, 16:30 • Márcia Cristina Afonso Barros
ETL processing with Python: automatic transformation and loading of data into dimension and fact files.
week 7
9 Abril 2024, 15:00 • Márcia Cristina Afonso Barros
ETL processing with Python: automatic transformation and loading of data into dimension and fact files.
Dimensional modeling (part 4)
9 Abril 2024, 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.