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 81
article thumbnail

Build a real-time analytics solution with Apache Pinot on AWS

AWS Big Data

Online Analytical Processing (OLAP) is crucial in modern data-driven apps, acting as an abstraction layer connecting raw data to users for efficient analysis. OLAP combines data from various data sources and aggregates and groups them as business terms and KPIs.

OLAP 94
Insiders

Sign Up for our Newsletter

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

article thumbnail

Complexity Drives Costs: A Look Inside BYOD and Azure Data Lakes

Jet Global

For more powerful, multidimensional OLAP-style reporting, however, it falls short. OLAP reporting has traditionally relied on a data warehouse. OLAP reporting based on a data warehouse model is a well-proven solution for companies with robust reporting requirements.

article thumbnail

Top 10 Free and Open Source BI Tools in 2020

FineReport

Tableau Public is similar but removes the download functionality. . Pentaho from Hitachi Vantara offers a suite of open source business intelligence(BI) products that help IT and business users to do data integration, OLAP services, reporting, dashboarding, data mining and ETL capabilities. Pentaho Community Edition .

OLAP 105
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. Download Now. Data Lakes. Key Takeaways.

article thumbnail

Octopai Users Do More with Enhanced Data Lineage Capabilities + Complete BI Data Catalog

Octopai

Download upper and column-to-column lineage to Excel/CSV in order to document, verify development and change requests. When looking to change ETLs for instance, or understand or design an ETL process, it is now possible to download the lineage to Excel in order to document changes as part of the change management process, do sign offs etc.

OLAP 84
article thumbnail

The Enterprise AI Revolution Starts with BI

Jet Global

The optimized data warehouse isn’t simply a number of relational databases cobbled together, however—it’s built on modern data storage structures such as the Online Analytical Processing (or OLAP) cubes. Cubes are multi-dimensional datasets that are optimized for analytical processing applications such as AI or BI solutions. Get Insight Now.