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? BI groups spend more than 50% of their time and effort manually searching for metadata. 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

What Role Does Data Mining Play for Business Intelligence?

Jet Global

Business intelligence (BI) software can help by combining online analytical processing (OLAP), location intelligence, enterprise reporting, and more. Store and manage: Next, businesses store and manage the data in a multidimensional database system, such as OLAP or tabular cubes.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

How gaming companies can use Amazon Redshift Serverless to build scalable analytical applications faster and easier

AWS Big Data

Sources Data can be loaded from multiple sources, such as systems of record, data generated from applications, operational data stores, enterprise-wide reference data and metadata, data from vendors and partners, machine-generated data, social sources, and web sources. Let’s look at the components of the architecture in more detail.

article thumbnail

How to Build a Performant Data Warehouse in Redshift

Sisense

OLTP vs OLAP. First, we’ll dive into the two types of databases: OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing). An OLAP database is best for situations where you read from the database more often than you write to it. Redshift is a type of OLAP database.