CIO Business Intelligence

JANUARY 20, 2023

Business intelligence definition Business intelligence (BI) is a set of strategies and technologies enterprises use to analyze business information and transform it into actionable insights that inform strategic and tactical business decisions.

Business Intelligence 140

Business Intelligence Dashboards Data mining OLAP 140

IBM Big Data Hub

DECEMBER 7, 2023

Online analytical processing (OLAP) database systems and artificial intelligence (AI) complement each other and can help enhance data analysis and decision-making when used in tandem. Identifying best practices and benefits In the realm of OLAP, AI’s role is increasingly important.

OLAP 59

OLAP Slice and Dice Cost-Benefit Data Warehouse 59

IBM Big Data Hub

SEPTEMBER 25, 2023

Presto is an open source distributed SQL query engine for data analytics and the data lakehouse, designed for running interactive analytic queries against datasets of all sizes, from gigabytes to petabytes. It excels in scalability and supports a wide range of analytical use cases.

OLAP 88

OLAP Data Lake Data-driven Snapshot 88

AWS Big Data

JUNE 21, 2023

This approach comes with a heavy computational cost in terms of processing and distributing the data across multiple tables while ensuring the system is ACID-compliant at all times, which can negatively impact performance and scalability. This is inefficient from both a cost and performance perspective.

Data Warehouse 82

Data Warehouse Data Lake OLAP Cost-Benefit 82

Sisense

NOVEMBER 12, 2020

The traditional data warehouses solved the problem of processing and synthesizing large data volumes, but they presented new challenges for the analytics process. Cloud data warehouses took the benefits of the cloud and applied them to data warehouses — bringing massive parallel processing to data teams of all sizes.

Data Warehouse 52

Data Warehouse Data Lake OLAP Data-driven 52

Sisense

SEPTEMBER 3, 2019

First, we’ll dive into the two types of databases: OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing). This approach made sense during a time in which the cost of storage was high, so normalizing tables reduced the total footprint. So let’s dive in! OLTP vs OLAP.

Data Warehouse 78

Data Warehouse OLAP Statistics Cost-Benefit 78