Sumários
Case studies in data warehousing
12 Abril 2022, 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.
Dimensional modeling (part 4)
5 Abril 2022, 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)
29 Março 2022, 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.
Dimensional modeling (part 2)
22 Março 2022, 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.
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.