Data mart

A data mart is a subject-focused part of the data environment that provides prepared data for a specific area or group of users. It can be oriented, for example, toward finance, sales, marketing, production or HR and make relevant information available in a form suitable for analysis.

How a data mart works

A data mart usually draws data from a data warehouse or other governed sources. The data is selected, adjusted and organized according to the needs of the area. It can contain aggregations, shared dimensions and defined indicators that make report creation easier.

Data mart and data warehouse

A data warehouse (DWH) is a broader integrated environment for analytical data across the organization. A data mart is usually a narrower, subject-focused layer. A good solution must keep shared definitions and prevent individual data marts from creating isolated “versions of the truth”.

Data mart in reporting

A data mart simplifies access to relevant data and can improve performance and clarity.