9. Working with and Analyzing OLAP Data
What Is OLAP?
Online Analytical Processing (OLAP) is a category of data warehousing that enables you to mine and analyze vast amounts data with ease and efficiency. Unlike other types of databases, OLAP databases are designed specifically for reporting and data mining. In fact, there are several key differences between your standard transactional databases, such as Access or SQL Server, and OLAP databases.
Records within a transactional database are routinely ...
Get Pivot Table Data Crunching: Microsoft® Excel® 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
