# Data mart

> A small, focused slice of the company's data, shaped for one team.

- Level: Intermediate
- Topics: Data
- URL: https://tidbit.legios.com.ar/data-mart/
- In Spanish: [Data mart](https://tidbit.legios.com.ar/es/data-mart/)

A **data mart** is a set of tables built for one part of a business, like sales, finance or marketing. It holds only the data that team needs, already cleaned, joined and named in the words they use. Where a data warehouse tries to cover the whole company, a data mart covers one subject.

Most data marts are carved out of a warehouse. The data team takes the raw orders, customers and payments, and builds a sales mart with a table of orders per day, per store and per product, ready to plug into a dashboard. Finance gets its own mart with invoices and margins. Today this is often just a separate schema inside the same warehouse, built with tools like dbt, rather than a separate machine.

Marts make life easier for analysts: fewer tables, clearer names, faster queries. The risk is the opposite of their strength. If every team builds its own mart with its own definition of "revenue", the numbers stop matching across meetings. That is why marts work best when they all come from the same warehouse and share definitions.

## An analogy

If the data warehouse is a central supermarket warehouse, a data mart is the neighborhood store: fewer products, picked for the people who shop there, and easy to find.

## Keep in mind

- A subset of data organized for one team or subject.
- Usually built from a data warehouse, often as its own schema.
- Simpler and faster to query than the whole warehouse.
- Marts with different definitions of the same metric cause mismatched numbers.

## Go deeper

- [Data mart on Wikipedia](https://en.wikipedia.org/wiki/Data_mart)
- [What is a data mart? (IBM)](https://www.ibm.com/think/topics/data-mart)

## Related terms

- [Data warehouse](https://tidbit.legios.com.ar/data-warehouse/): A database built for analysis: years of history, from many sources, in one place.
- [Dashboard](https://tidbit.legios.com.ar/dashboard/): One screen of charts and numbers that shows how something is doing at a glance.
- [Database schema](https://tidbit.legios.com.ar/database-schema/): The blueprint of a database: which tables exist, their columns and how they connect.
- [dbt](https://tidbit.legios.com.ar/dbt/): A tool for writing data transformations as SQL files, with tests and docs, like software.