Data mart

A data mart is a subject-oriented part of a data warehouse, organised around one team or set of questions, such as credit risk. The warehouse integrates data across the business; the mart focuses on one area.

Example

For illustration, a row can capture one loan at month end, its balance and days past due, and its score at origination and segment. A risk analyst can compare month-end balances and past-due levels across origination scores.

What goes into a credit risk data mart

Start by stating what one row represents. In a credit risk mart, that might be one loan at each month end, with balance and days past due recorded for that loan and date.

Readers can filter or group the records by dimensions such as date and product. In a Kimball-style star schema, date and product can be shared dimensions across data marts.

Dependent and independent data marts

A dependent data mart is loaded from the central warehouse. Since it draws on the warehouse, teams can use a shared basis for their numbers.

An independent data mart is loaded directly from source systems. When teams build marts this way, their numbers can drift from one another.

Questions we get asked

What does a star schema mean in a data mart?

A star schema organises a data mart around facts and dimensions. Loan balances can be facts, with date and product as dimensions for filtering or grouping.

What are conformed dimensions in a data mart?

Conformed dimensions are shared dimensions used across data marts. Date and product are examples, giving teams a common basis for those dimensions.

Why keep a loan's score at origination in the mart?

It keeps the original score available for comparison with the loan's later monthly snapshots. Those snapshots can include balance and days past due, so the mart can show the score recorded at origination alongside later loan information.

A credit risk mart can hold loan snapshots, and the lending data warehouse article shows how month-end snapshots help assess whether a falling portfolio Gini means the scorecard weakened.