Dimensional Modeling :

Dimensional data is a core component of modern Business Intelligence and Data Warehousing implementations. Dimensionally organized data offers a more effective and adaptable solution to businessanalytics needs than can be achieved with relational data structures. Virtually anyone involved in business intelligence and data warehousing projects needs to have fundamental knowledge of the pathway from business questions to business analytics. 

Dimensional Modeling