AWS Big Data

MARCH 7, 2023

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.

Analytics 68

Analytics Data Warehouse Data Lake Metadata 68

AWS Big Data

FEBRUARY 28, 2023

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.

Online Analytical Processing 71

Online Analytical Processing OLAP Slice and Dice Analytics 71

Jet Global

AUGUST 14, 2019

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.

Enterprise 70

Enterprise OLAP Business Intelligence Cost-Benefit 70

Jet Global

OCTOBER 2, 2019

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.

Enterprise 40

Enterprise OLAP Business Intelligence Cost-Benefit 40

Jet Global

OCTOBER 22, 2020

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.

Modeling 52

Modeling OLAP Reporting Sales 52

Sisense

SEPTEMBER 3, 2019

First, we’ll dive into the two types of databases: OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing). To check if the distribution method you’ve chosen is reasonably distributed across your nodes, you can query SVV_TABLE_INFO and measure the skew of your table. So let’s dive in!

Data Warehouse 78

Data Warehouse OLAP Statistics Cost-Benefit 78

AWS Big Data

APRIL 4, 2024

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

Big Data 64

Big Data Data Warehouse Advertising OLAP 64