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. It helps you see your mission-critical metrics at different aggregation levels in a single pane of glass. This will allow for a smoother migration of OLAP workloads, with minimal rewrites.

article thumbnail

Business Intelligence vs. Reporting: Finding Your Bread and Butter

Jet Global

As we will outline below when discussing the technical execution differences between reporting and BI, with business intelligence, it’s possible (and required) to universally define goals and performance equations through KPIs and metrics that are calculated in the BI environment indefinitely.

article thumbnail

What Is Embedded Analytics?

Jet Global

As a result, end users can better view shared metrics (backed by accurate data), which ultimately drives performance. When treating a patient, a doctor may wish to study the patient’s vital metrics in comparison to those of their peer group. Interactivity can include dropdowns and filters for users to slice and dice data.