In a nutshell, here are the two approaches: in Bill Inmon’s enterprise data warehouse approach (the top-down design), a normalised data model is designed first, then the dimensional data marts ...