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. You can remove this filter in your test to view data for all regions. In this post, we discuss how to use these extensions to simplify your queries in Amazon Redshift.

article thumbnail

Master Your Power BI Environment with Tabular Models

Jet Global

It updates a dedicated database against which you can perform reporting and analytics. That stands for “Online Analytical Processing,” and it’s a paradigm that goes back a little more than two decades, to a time when database performance and computational power were far less robust than they are today.