Data warehouses have played a very important role in organizational settings in the recent times. These can be used for sophisticated enterprise intelligence systems that process queries required to discover trends and analyze critical factors in the marketplace. These systems are known as online analytical processing (OLAP) systems. OLAP systems help designers organize data in the warehouse distinctively. The data in data warehouses is organized differently than in traditional transaction processing databases.

See the original post here:
Online Analytical Processing For Data Warehousing