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

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.

Insiders

Sign Up for our Newsletter

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

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. But data alone is not the answer—without a means to interact with the data and extract meaningful insight, it’s essentially useless.

article thumbnail

What Will Enterprise Data Lineage Look Like in 2020?

Octopai

Octopai is able to locate all data items defined by different metadata descriptions throughout multi-source data environments, enabling organizations to find the common origins of this data, and get a full understanding of the pathways the data has undergone to this point. Metadata Management Automation Increases Accuracy.

article thumbnail

How to Build a Performant Data Warehouse in Redshift

Sisense

First, we’ll dive into the two types of databases: OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing). By using metadata about where the data is stored, it allows the query engine to skip over chunks of data that it knows are not within the bounds of your query’s parameters.