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