We recommend you model the data flow in accordance with a data warehouse layer architecture.
For information on a layer architecture, see Architecture of a Data Warehouse.
You do not have to implement all four layers but can decide which structure best suits your needs.
Questions that are central to making this decision include:
● Does the data come from heterogeneous source systems and therefore need to be consolidated first?
● Do I need the data for operational reporting?
● What questions do I want to answer in reporting?
For more information, see:
Simple Model Without Operational Data Store
Modeling Without Persistent Data Storage