article thumbnail

Reporting Analytics vs. Financial Reporting: Is There a Difference?

Jet Global

It’s also helpful to be able to “slice and dice” income statements by segregating information for different company divisions, product lines, or subsidiaries. Following on the sales example cited above, a user might choose to view sales of different product lines, with a secondary breakdown of those sales by region.

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.