Ideal usage patterns

Amazon Redshift is ideal for OLAP using your existing BI tools. Enterprises use Amazon Redshift to do the following:

• Running enterprise BI and reporting

• Analyze global sales data for multiple products

• Store historical stock trade data

• Analyze ad impressions and clicks

• Aggregate gaming data

• Analyze social trends

• Measure clinical quality, operation efficiency, and financial performance in health care

With the Amazon Redshift Spectrum feature, Amazon Redshift supports semi-structured data and extends your data warehouse to your data lake. This enables you to:

• Run as-needed analysis on large volume event data such as log analysis and social media

• Offload infrequently accessed history data out of the data warehouse

• Join the external dataset with the data warehouse directly without loading them into the data warehouse