article thumbnail

Build a real-time analytics solution with Apache Pinot on AWS

AWS Big Data

Online Analytical Processing (OLAP) is crucial in modern data-driven apps, acting as an abstraction layer connecting raw data to users for efficient analysis. Business metrics – Providing KPIs, scorecards, and business-relevant benchmarks. Anomaly detection – Identifying outliers or unusual behavior patterns.

OLAP 109
article thumbnail

Build an Amazon Redshift data warehouse using an Amazon DynamoDB single-table design

AWS Big Data

Typical use cases for DynamoDB are an ecommerce application handling a high volume of transactions, or a gaming application that needs to maintain scorecards for players and games. Deriving business insights by identifying year-on-year sales growth is an example of an online analytical processing (OLAP) query.