Data engineering·Modelling for analysis
the finance team has its own set of tables, shaped for their questions, built from the shared ones.
Data mart
Also calledmart, departmental warehouse
A subset of the warehouse modelled for one team or one subject area. Built on conformed dimensions it is a useful presentation layer; built independently from source it becomes a second warehouse with its own definition of revenue, which is how organisations end up with four numbers for one metric. The distinction between those two outcomes is entirely whether the shared dimensions came first.