How would you design a data model that supports both real-time operational reporting and historical analytical reporting from the same data sources?

Sample answer preview

Supporting both real-time operational reporting and historical analytical reporting from the same sources is a common but challenging requirement. These two use cases have fundamentally different characteristics that require a thoughtful architectural approach.