Data model

Excel's data model is an internal database that stores several tables linked together by relationships. It lets you analyze related tables in a single PivotTable, without lookup formulas, and handles large volumes of data. It is built on the same engine as Power BI.

Example

A Ventes table linked to a Produits table by the product code, analyzed together in a PivotTable.

Related concepts

The whole glossary