Octopai

JANUARY 21, 2020

This is how the Online Analytical Processing (OLAP) cube was born, which you might call one of the grooviest BI inventions developed in the 70s. OLAP cube is designed as a solution to pre-compute totals and subtotals when the database server is idle. The OLAP cube makes reading data across multiple dimensions manageable.

OLAP 81

OLAP Metadata Online Analytical Processing Data Quality 81

AWS Big Data

OCTOBER 18, 2023

To download and install AWS SCT on the EC2 instance that you created, refer to Installing, verifying, and updating AWS SCT. Download the Redshift JDBC driver. Download and install Amazon Corretto 11. For Connection name , enter a name (for example, olap-azure-synapse ). Deselect Create final snapshot. Choose Next.

Analytics 107

Analytics Data Warehouse Dashboards Testing 107

AWS Big Data

JUNE 21, 2023

Deriving business insights by identifying year-on-year sales growth is an example of an online analytical processing (OLAP) query. We begin with a single-table design as an initial state and build a scalable batch extract, load, and transform (ELT) pipeline to restructure the data into a dimensional model for OLAP workloads.

Data Warehouse 90

Data Warehouse Data Lake OLAP Cost-Benefit 90

AWS Big Data

AUGUST 1, 2024

The following figure shows a daily query volume snapshot (queries per day and queued queries per day, which waited a minimum of 5 seconds). To identify percentile and top running queries, you can download the sample SQL notebook system queries. The data warehouse is highly business critical with minimal allowable downtime.

Data Warehouse 99

Data Warehouse KPI Optimization Cost-Benefit 99