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. This allows us to measure the performance of the database as opposed to its ability to serve results from cache. Additionally, we disabled query caching so that query results aren’t cached.

article thumbnail

How Aura from Unity revolutionized their big data pipeline with Amazon Redshift Serverless

AWS Big Data

Amazon Redshift is a recommended service for online analytical processing (OLAP) workloads such as cloud data warehouses, data marts, and other analytical data stores. Redshift Serverless measures data warehouse capacity in Redshift Processing Units (RPUs).

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

How gaming companies can use Amazon Redshift Serverless to build scalable analytical applications faster and easier

AWS Big Data

This post provides guidance on how to build scalable analytical solutions for gaming industry use cases using Amazon Redshift Serverless. This post also discusses the art of the possible with newer innovations in AWS services around streaming, machine learning (ML), data sharing, and serverless capabilities.

article thumbnail

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

AWS Big Data

Nonetheless, many of the same customers using DynamoDB would also like to be able to perform aggregations and ad hoc queries against their data to measure important KPIs that are pertinent to their business. A typical ask for this data may be to identify sales trends as well as sales growth on a yearly, monthly, or even daily basis.

article thumbnail

Master Your Power BI Environment with Tabular Models

Jet Global

The simplest model for reporting ERP data involves a direct connection to the database – executing queries against the transactional database in real time, summarizing and organizing selected data points, and displaying a report that you can print, display on screen or save as a data file. The era of big data has arrived.

article thumbnail

How to Build a Performant Data Warehouse in Redshift

Sisense

This blog is intended to give an overview of the considerations you’ll want to make as you build your Redshift data warehouse to ensure you are getting the optimal performance. Redshift, like BigQuery and Snowflake, is a cloud-based distributed multi-parallel processing (MPP) database, built for big data sets and complex analytical workflows.