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 96

Analytics Data Warehouse Data Lake Metadata 96

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

AWS Big Data

JUNE 21, 2023

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.

Data Warehouse 105

Data Warehouse Data Lake OLAP Cost-Benefit 105

AWS Big Data

AUGUST 1, 2024

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. To identify percentile and top running queries, you can download the sample SQL notebook system queries.

Data Warehouse 115

Data Warehouse KPI Optimization Cost-Benefit 115

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

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