OLAP Courses and Certifications

EuroPython Conference

Cubes Light Weight OLAP FW Server

Explore lightweight OLAP framework server for efficient data analysis and reporting, focusing on Cubes implementation and benefits.

• YouTube
• 40 minutes
• Self-Paced
• Conference Talk

CMU Database Group

Distributed Data Warehouse OLAP Databases - Lecture 23

Explore distributed data warehouse OLAP databases, covering architecture, query processing, and optimization techniques for large-scale analytical systems.

• YouTube
• 1 hour 23 minutes
• Self-Paced
• Free Video

OLAP on Cassandra Data with Arrow, Flight SQL, ADBC, and DuckDB

Explore modern OLAP techniques for Cassandra data using Arrow, Flight SQL, ADBC, and DuckDB. Learn to convert sstable snapshots to Parquet, enable real-time analytics, and leverage Flight SQL for efficient querying.

• YouTube
• 30 minutes
• Self-Paced
• Free Video

USENIX

Bridging the Gap between Relational OLTP and Graph-based OLAP

Explore GART, an innovative system bridging relational OLTP and graph-based OLAP, offering real-time graph analytics with superior performance and data freshness for dynamic applications.

• YouTube
• 20 minutes
• Self-Paced
• Conference Talk

The ASF

Apache Paimon - A Unified Data Lake for Stream, Batch, and OLAP Processing

Explore Apache Paimon's capabilities as a unified data lake system, integrating stream processing, batch operations, and OLAP functionalities for modern data architecture.

• YouTube
• 30 minutes
• Self-Paced
• Free Video

OSACon

Analytics and Real-time Database Workloads: Combining OLTP and OLAP Systems

Explore strategies for optimizing concurrent OLAP and OLTP workloads, focusing on ScyllaDB's workload prioritization features to achieve harmonious performance in distributed systems.

• YouTube
• 25 minutes
• Self-Paced
• Free Video

InfoQ

Time Series and OLAP: Are They Converging? - Insights from QuestDB

Explore the evolution of time series databases, their relationship with OLAP systems, and the shift from monolithic designs to shared-disk engines and "Lakehouse" architectures.

• YouTube
• 47 minutes
• Self-Paced
• Free Video

The ASF

The Practices of Apache Doris in OLAP and Data Analysis at Caitong Securities

Discover how Apache Doris optimizes data analysis and OLAP operations in securities trading through real-world implementation examples and architectural insights.

• YouTube
• 32 minutes
• Self-Paced
• Free Video

The ASF

File Runtime Statistics for Spark Optimization in OLAP and Data Analysis

Discover how to leverage file runtime statistics for optimizing Spark performance and enhancing data processing efficiency in OLAP systems.

• YouTube
• 19 minutes
• Self-Paced
• Free Video

CMU Database Group

Apache Pinot - Real-time OLAP and Vector Search for AI-driven Features

Discover how Apache Pinot handles real-time OLAP and powers AI features like vector search, as presented by StarTree co-founder Xiang Fu to CMUDB class.

• YouTube
• 16 minutes
• Self-Paced
• Free Video

The ASF

OLAP Practice Based on Apache Doris at Xiaomi

Explore Apache Doris' implementation at Xiaomi for OLAP, covering historical context, data dashboards, user behavior analysis, and future developments in big data analytics.

• YouTube
• 36 minutes
• Self-Paced
• Free Video

USENIX

Data Caching for Enterprise-Grade Petabyte-Scale OLAP

Explores Alluxio local cache for petabyte-scale OLAP, optimizing data transfer efficiency in decoupled compute-storage models. Shares insights from Uber and Meta deployments.

• YouTube
• 20 minutes
• Self-Paced
• Free Video

StreamNative

Have Your Real-time OLAP and Upsert It Too - Deep Dive

Discover how Apache Pinot enables native upserts in real-time OLAP systems, managing billions of primary keys while maintaining sub-second freshness and high-performance analytics.

• YouTube
• 29 minutes
• Self-Paced
• Free Video

CMU Database Group

MotherDuck - Building a Cloud Data Warehouse with an In-Process OLAP DBMS

Discover how MotherDuck builds a cloud data warehouse using an in-process OLAP database management system with insights from industry expert Boaz Leskes.

• YouTube
• 12 minutes
• Self-Paced
• Free Video

Career Certificate

Data Warehousing for Business Intelligence

4137 ratings at Coursera

Comprehensive program covering data modeling, SQL, warehouse design, and visualization using MicroStrategy. Develop practical skills to create dashboards and analyze large datasets for business intelligence.

• Coursera
• 32 weeks, 10 hours/week
• Self-Paced
• Paid Course
• 5 courses