Power Pivot is the Excel add-in that manages the data model: it lets you create relationships between tables, calculated columns and measures written in the DAX language. It feeds PivotTables over large volumes of data coming from several sources.
Example
Total ventes := SUM(Ventes[Montant])