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