Amazon Redshift/Redshift Spectrum/ Elastic Search

Amazon Redshift Spectrum can help you balance the need for adding capacity to the Redshift as well as operational optimization (reducing re-index overhead). Redshift spectrum allows you to directly query from S3 at scale and seamlessly integrate that with redshift (Spectrum Use case – Historical data and infrequently accessed data). Amazon Redshift Spectrum Extends Data Warehousing Out to Exabytes.

Redshift will provide visibility of Customer Lifetime Value, Churn Rate, Average Order Size, Profitability, and Cost-to-Serve for actionable insights.

Analytics insights could be integrated and automated into the actionable business process through AI. Elastic search service allows customer intelligence analysis and AI automation to be near real-time.