Dimensional modeling organizes a warehouse around fact tables (measurable events) surrounded by dimension tables (axes of analysis: customer, product, date). The resulting star schema is simple to understand and fast to query, because analysis queries boil down to joins between a fact and its dimensions.
Example
FROM fait_ventes f JOIN dim_produit p ON p.produit_key = f.produit_key