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 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 service is the core of this reference architecture on AWS and can address most analytical needs out of the box. Data subscription and access is fully managed with this service.

Insiders

Sign Up for our Newsletter

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

article thumbnail

The Future of AI in the Enterprise

Jet Global

The optimized data warehouse isn’t simply a number of relational databases cobbled together, however—it’s built on modern data storage structures such as the Online Analytical Processing (or OLAP) cubes. Cubes are multi-dimensional datasets that are optimized for analytical processing applications such as AI or BI solutions.

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).

article thumbnail

Unlock scalability, cost-efficiency, and faster insights with large-scale data migration to Amazon Redshift

AWS Big Data

This includes the ETL processes that capture source data, the functional refinement and creation of data products, the aggregation for business metrics, and the consumption from analytics, business intelligence (BI), and ML. Establishing KPIs and benchmarking them helps measure progress and identify areas for improvement.

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. Deriving business insights by identifying year-on-year sales growth is an example of an online analytical processing (OLAP) query.

article thumbnail

Master Your Power BI Environment with Tabular Models

Jet Global

As a security measure, Microsoft is closing off direct database access to live Microsoft Dynamics ERP data. It updates a dedicated database against which you can perform reporting and analytics. In the world of Microsoft Dynamics 365, that option is going away, or at the very least, it will look somewhat different than it once did.