Data Warehouse Architecture Best Practices

A data warehouse should consist of at least three layers. You could design each of these three layers with several individual sub-layers.

Those three layers could be named Staging, Core and Access but several other names could be used as well like Landing, Sourcing, Integrated, Enterprise, Analytic, Application, etc. After all, they are just names.

In addition to the three layers, other components could be useful like a data lab, and “big data”, as well as support for advanced analytics.