The core of the data warehousing is the STAR Schema data model. This is
also called multi dimensional modeling. It primarily consists of
Dimension Table and Fact tables.
Dimensions could be Customer, Product, Geography, Time etc.
Facts consist of items such as Sales, Cost, Revenue etc.
Once the STAR Schema is designed, it becomes easier to create adhoc
reports using OLAP tools (such as Cognos, MicroStrategy, Business
Objects etc.)