Remove Download Remove Online Analytical Processing Remove Reporting Remove Snapshot
article thumbnail

BI Cubed: Data Lineage on OLAP Anyone?

Octopai

How much time has your BI team wasted on finding data and creating metadata management reports? However, over time new technologies and tools developed to ease data reporting and analysis. 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 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.