This article will give you the pros and cons of different datawarehouse architectures, so that you can choose which one is best for your customer. As a BI architect, my job is to be objective. Try not to defend the things you know, but try to keep an open mind.
We will limit our scope to 3 popular architectures: Datavault, Anchor modeling and Inmon 3NF.
Example domain: Nasa Facilities. This is just a simple listing of Nasa centers and facilities. Each Centers hosts one or more facilities.
Modelled in Data Vault 2.0
MODELLED in Inmon style 3NF
MODELLED IN ANCHOR MODELING