Introduction to OLAP

  • Philo Janus
  • Guy Fouché


Online analytical processing (OLAP) is a technique for aggregating data to enable business users to dig into transactional data to solve business problems. You may be familiar with pivot tables from Microsoft Excel or other reporting solutions—for example, taking a list of order details (Figure 1-1) and creating a table that shows the total for each product ordered by month (Figure 1-2).
Figure 1-1.

Tabular order data

Figure 1-2.

Summarizing products by month ordered


Business Intelligence Transactional Data Data Mart Pivot Table OLAP Query 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Philo Janus and Guy Fouché 2010

Authors and Affiliations

  • Philo Janus
  • Guy Fouché

There are no affiliations available

Personalised recommendations