A compact star schema and a wider loyalty model.
This page shows the reporting structures behind the two cases, from a small interview model to a broader simulation model with loyalty entities.
Star schema
Transactions, date, item, site.
Loyalty model
Customers, cards, campaigns, stations.