article thumbnail

What is business intelligence? Transforming data into business insights

CIO Business Intelligence

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.

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 81
Insiders

Sign Up for our Newsletter

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

article thumbnail

Financial Intelligence vs. Business Intelligence: What’s the Difference?

Jet Global

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.

article thumbnail

Unlock scalability, cost-efficiency, and faster insights with large-scale data migration to Amazon Redshift

AWS Big Data

The following figure shows a daily query volume snapshot (queries per day and queued queries per day, which waited a minimum of 5 seconds). The data warehouse is highly business critical with minimal allowable downtime. The following figure shows a daily usage KPI.

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. Unlike the old connector, the new version uses a snapshot of the DynamoDB table and doesn’t consume read capacity units of your source DynamoDB table.

article thumbnail

Unleashing the power of Presto: The Uber case study

IBM Big Data Hub

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

OLAP 86