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

Sign Up for our Newsletter

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

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

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. Expanded our support of Microsoft OLAP cube , an innovative open-source feat. Metadata is everywhere and its success depends on deploying the right resources for its management.

article thumbnail

Prevent Customer Churn: Customer Retention in the Transition to Microsoft D365 F&SCM

Jet Global

You might measure those costs in different ways, including actual dollars and cents, staff time, added complexity, and risk. There are numerous soft costs involving risk and potential business disruption. In other words, switching costs are not just about money. Reporting as a Key Cost-driver.

article thumbnail

CCPA 2020: Getting Your Data Landscape Ready

Octopai

You can evaluate and mitigate compliance risks. As a company’s data landscape grows and evolves, more computing “horsepower” is needed to perform the ETL and OLAP cube processing required to populate data warehouses and drive reports and dashboards. Not Yet CCPA Compliant? On the Horizon: Federal Data Privacy Law.

article thumbnail

Understanding Data Entities in Microsoft Dynamics 365

Jet Global

Reporting and analytics solutions from insightsoftware eliminate complexity, reduce cost, and decrease the risk of lengthy implementations. Jet Analytics provides a pre-built data warehouse , OLAP cubes , and tabular models with a platform for non-technical users to easily create their own reports in Excel or Power BI.