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. OLAP cube is designed as a solution to pre-compute totals and subtotals when the database server is idle. The OLAP cube makes reading data across multiple dimensions manageable.

OLAP 56
article thumbnail

How OLAP and AI can enable better business

IBM Big Data Hub

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. As AI techniques continue to evolve, innovative applications in the OLAP domain are anticipated.

OLAP 60
Insiders

Sign Up for our Newsletter

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

Trending Sources

article thumbnail

Navigating Data Entities, BYOD, and Data Lakes in Microsoft Dynamics

Jet Global

Online analytical processing (OLAP), which enabled users to quickly and easily view data along different dimensions, was coming of age. The challenge with OLAP, however, is that it requires intensive processing power to aggregate data according to various categories or dimensions. Data warehouses have been in widespread use for years.

article thumbnail

Bridge the Gap Between Reporting and Data Visualization in Power BI

Jet Global

The skills needed to create a data warehouse are currently in short supply, leading to long lead times, high costs, and unnecessary risks. Pre-built OLAP cubes, tabular models, and a data warehouse. Boost refresh times with star schemas, tabular models, and OLAP cubes. Leverage incremental refresh to optimize resource usage.

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. OLAP databases excel at queries that require large table scans (e.g.

article thumbnail

Business Intelligence System: Definition, Application & Practice

FineReport

Among these problems, one is that the third party on market data analysis platform or enterprises’ own platforms have been unable to meet the needs of business development. With the advancement of information construction, enterprises have accumulated massive data base. Hoewever, it can be a double-edged sword for enterprises.

article thumbnail

2019 Highlights in Metadata Management

Octopai

What a flashback to see all that we’ve achieved this year in data governance, risk and compliance, data analysis and reporting. Regulations such as GDPR , CCPA , BCBS 239, New York Data Security Act and others are expanding enterprise needs for metadata lineage management and automated metadata management systems.