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

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

IBM Big Data Hub

SEPTEMBER 25, 2023

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

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

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

OCTOBER 18, 2023

For Connection name , enter a name (for example, olap-azure-synapse ). Deselect Create final snapshot. Provide a meaningful but memorable name for your project (for example, Azure Synapse to Amazon Redshift). To connect to the Azure Synapse source data warehouse, choose Add source. Choose Azure Synapse and choose Next.

Analytics 107

Analytics Data Warehouse Dashboards Testing 107

AWS Big Data

MARCH 20, 2023

Druid hosted on Amazon Elastic Compute Cloud (Amazon EC2) integrates with the Kinesis data stream for streaming ingestion and allows users to run slice-and-dice OLAP queries. The data from the S3 data lake is used for batch processing and analytics through Amazon EMR and Amazon Redshift.

Analytics 52

Analytics Data Processing Slice and Dice Data Lake 52