We might design a Data Mart which will be a natural starting-point for Performance Reports and KPIs.

Products in the Products Table are organised in a hierarchy, which we show we show as a 'self-referencing' relationship.
We discuss the technique in this Hierarchies Model, and an example of how it is used is in this Product Catalogs Model.