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. Saving time and headaches with online analytical processing tool.

OLAP 81

OLAP Metadata Online Analytical Processing Data Quality 81

CIO Business Intelligence

JANUARY 20, 2023

BI aims to deliver straightforward snapshots of the current state of affairs to business managers. and prescriptive (what should the organization be doing to create better outcomes?). This gets to the heart of the question of who business intelligence is for.

Business Intelligence 144

Business Intelligence Dashboards Data mining OLAP 144

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.

Business Intelligence 78

Business Intelligence Finance Data Warehouse OLAP 78

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. The case for a data warehouse A data warehouse is ideally suited to answer OLAP queries. These types of queries are suited for a data warehouse.

Data Warehouse 104

Data Warehouse Data Lake OLAP Cost-Benefit 104

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). The data warehouse is highly business critical with minimal allowable downtime. The following figure shows a daily usage KPI.

Data Warehouse 113

Data Warehouse KPI Optimization Cost-Benefit 113

IBM Big Data Hub

SEPTEMBER 25, 2023

For traditional analytics, they are bringing data discipline to their use of Presto. 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. It lands as raw data in HDFS.

OLAP 86

OLAP Data Lake Data-driven Snapshot 86