Remove Definition Remove Measurement Remove Online Analytical Processing Remove Slice and Dice
article thumbnail

Simplify Online Analytical Processing (OLAP) queries in Amazon Redshift using new SQL constructs such as ROLLUP, CUBE, and GROUPING SETS

AWS Big Data

Solution overview Online Analytical Processing (OLAP) is an effective tool for today’s data and business analysts. This feature helps us clearly understand the aggregation grain, slice and dice data, and apply filters when business users are performing analysis. The results were consistent across multiple runs.