Sumários

Introduction to Physical design of Data warehouses - VIDEOCONFERENCE

5 Maio 2020, 13:00 André Osório e Cruz de Azerêdo Falcão



Student Q/A - VIDEOCONFERENCE

29 Abril 2020, 16:30 André Osório e Cruz de Azerêdo Falcão

Class previously recorded
Support to students questions to subject matters


Student Q/A - VIDEOCONFERENCE

28 Abril 2020, 16:30 André Osório e Cruz de Azerêdo Falcão

Class previously recorded
Support to students questions to subject matters


ETL processes for OLAP Databases in Python Part 2 - VIDEOCONFERENCE

28 Abril 2020, 15:00 André Osório e Cruz de Azerêdo Falcão



Advanced dimensional modeliing with case studies in data warehousing -VIDEOCONFERENCE

28 Abril 2020, 13:00 André Osório e Cruz de Azerêdo Falcão

Case studies in data warehousing:
  • Order management•Process matrix, ordering orders, “remote customer”•Prices in various currencies, scrutinize profits and losses
  • Customer relationship management•Process matrix, “feeding” of operating systems•Bifurcations, mini-dimensions, names and addresses, hierarchies
  • Telecommunications•Process matrix, initial model, reviews, revised model
  • E-commerce•Clickstream, registration of sessions and visits to individual pages•Dimensions, fact tables with different grains