Skip to main content

Define data mart

Short answer

A data mart is a focused subset of a data warehouse serving one department like sales or finance, cheaper and faster to query. It can be dependent (from warehouse) or independent (from sources). Example: a bank's Loan Marketing mart holds only customer, loan product, and campaign data for the loan team.

Define Data Mart with example.

A data mart is a small, focused subset of a data warehouse that serves the needs of one department, business line or subject area, such as sales, marketing or finance. It contains only the data relevant to that group, so it is cheaper, quicker to build and faster to query than a full enterprise warehouse. It can be dependent (loaded from the enterprise warehouse) or independent (loaded directly from sources).

Example: A bank's enterprise warehouse covers loans, deposits, cards and HR. The Loan Marketing data mart holds only customer, loan product and campaign data, and is used by the loan marketing team.

✓ Answer checked by Claude Opus 5.5 (high effort)

Related questions

All Data Mining chapter 1 questions →