Octopai

JANUARY 21, 2020

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. Saving time and headaches with online analytical processing tool.

OLAP 56

OLAP Metadata Online Analytical Processing Data Quality 56

Jet Global

APRIL 20, 2020

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. It enabled finance professionals to view, filter, and analyze their data along multiple dimensions.

Business Intelligence 78

Business Intelligence Finance Data Warehouse OLAP 78

AWS Big Data

OCTOBER 18, 2023

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that provides the flexibility to use provisioned or serverless compute for your analytical workloads. Modern analytics is much wider than SQL-based data warehousing. Solution overview AWS SCT uses a service account to connect to your Azure Synapse Analytics.

Analytics 92

Analytics Data Warehouse Testing Dashboards 92

CIO Business Intelligence

JANUARY 20, 2023

BI tools access and analyze data sets and present analytical findings in reports, summaries, dashboards, graphs, charts, and maps to provide users with detailed intelligence about the state of the business. Whereas BI studies historical data to guide business decision-making, business analytics is about looking forward.

Business Intelligence 143

Business Intelligence Dashboards Data mining OLAP 143

AWS Big Data

MARCH 20, 2023

In this post, we share how Poshmark improved CX and accelerated revenue growth by using a real-time analytics solution. High-level challenge: The need for real-time analytics Previous efforts at Poshmark for improving CX through analytics were based on batch processing of analytics data and using it on a daily basis to improve CX.

Analytics 52

Analytics Slice and Dice Data Processing Data Lake 52

AWS Big Data

JUNE 21, 2023

Deriving business insights by identifying year-on-year sales growth is an example of an online analytical processing (OLAP) query. We begin with a single-table design as an initial state and build a scalable batch extract, load, and transform (ELT) pipeline to restructure the data into a dimensional model for OLAP workloads.

Data Warehouse 76

Data Warehouse Data Lake OLAP Cost-Benefit 76

IBM Big Data Hub

SEPTEMBER 25, 2023

But what most people don’t realize is that behind the scenes, Uber is not just a transportation service; it’s a data and analytics powerhouse. This blog takes you on a journey into the world of Uber’s analytics and the critical role that Presto, the open source SQL query engine, plays in driving their success.

OLAP 92

OLAP Data Lake Data-driven Snapshot 92