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

IBM Big Data Hub

SEPTEMBER 25, 2023

Large, untested workloads run the risk of hogging all the resources. They ingest data in snapshots from operational systems. Next, they build model data sets out of the snapshots, cleanse and deduplicate the data, and prepare it for analysis as Parquet files. In some cases, the queries run out of memory and do not complete.

OLAP 86

OLAP Data Lake Data-driven Online Analytical Processing 86

Jet Global

APRIL 20, 2020

This practice, together with powerful OLAP (online analytical processing) tools, grew into a body of practice that we call “business intelligence.” Such BI methodologies are built on a snapshot of what happened in the past. It enabled finance professionals to view, filter, and analyze their data along multiple dimensions.

Business Intelligence 78

Business Intelligence Finance Data Warehouse OLAP 78

AWS Big Data

AUGUST 1, 2024

Effective planning, thorough risk assessment, and a well-designed migration strategy are crucial to mitigating these challenges and implementing a successful transition to the new data warehouse environment on Amazon Redshift. The data warehouse is highly business critical with minimal allowable downtime.

Data Warehouse 115

Data Warehouse KPI Optimization Cost-Benefit 115