article thumbnail

BI Cubed: Data Lineage on OLAP Anyone?

Octopai

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. It’s a snapshot of data at a specific point in time, at the end of a day, week, month or year. Saving time and headaches with online analytical processing tool.

OLAP 56
article thumbnail

Build an Amazon Redshift data warehouse using an Amazon DynamoDB single-table design

AWS Big Data

Deriving business insights by identifying year-on-year sales growth is an example of an online analytical processing (OLAP) query. Download the following files to perform the ELT: The Python script to load sample data into our DynamoDB table: load_dynamodb.py. These types of queries are suited for a data warehouse.