🗄️Data Mart
A small slice of the warehouse for one team. It holds only what they need.
Think of it like
It is like one shelf from a big library. It is moved to the room where one team works.
Example
The finance team gets a mart with costs, invoices and budgets. It does not see the web click data the marketing team uses.
Why it matters
People find the right table faster when they only see their own. It also makes access rules easier.
Definition
Common mistake
Key takeaways
- 1One team. Built around one group's questions.
- 2Small on purpose. Only the tables that team needs.
- 3Fed by the warehouse. The same source keeps numbers in step.