Recommendations for Modeling the Data Flow 

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 data analysis?

●      Which questions do I want to answer through analyzing this data?

For more information, see:

Simple Model Without Operational Data Store

Modeling with All Layers

Modeling Without Persistent Data Storage