OLAP Courses and Certifications

Choosing between Multidimensional and Tabular Models in SSAS

26 ratings at Pluralsight

Microsoft’s SQL Server Analysis Services (SSAS) is considered to be one of the top online analytical processing (OLAP) technologies. This course compares the two major semantic data model types by SSAS and how to assess which one to use in practice.

• Pluralsight
• 1-2 hours
• On-Demand
• Free Trial Available

ChariotSolutions

A Look at Polyglot Data and Event Sourcing - Lecture 24

Explore polyglot data and event sourcing to choose the right data model for your problem, focusing on multiple representations and avoiding accidental complexity.

• YouTube
• 47 minutes
• On-Demand
• Free Video

Databricks

Slowly Changing Dimensions Type 2 in Data Lakes - Tech Chat

Explore Slowly Changing Dimensions Type 2 in data lakes using Delta Lake, focusing on market segmentation for a climbing eCommerce site. Learn to track historical and current data effectively.

• YouTube
• 1 hour 1 minute
• On-Demand
• Free Video

Optimizing Speed and Scale of Real-Time Analytics Using Apache Pulsar and Apache Pinot

Explore Apache Pulsar and Apache Pinot's synergy for high-speed, scalable real-time analytics in Cloud Native environments. Learn how these powerful tools enable efficient event streaming and ad-hoc data analysis.

• YouTube
• 33 minutes
• On-Demand
• Free Video

Optimizing Speed and Scale of Real-Time Analytics Using Apache Pulsar and Apache Pinot

Explore real-time analytics optimization using Apache Pulsar for event streaming and Apache Pinot for low-latency OLAP, enabling scalable, high-performance data processing and ad-hoc querying.

• YouTube
• 40 minutes
• On-Demand
• Free Video

EuroPython Conference

Advanced Database Programming with Python

Explore advanced database programming with Python, covering locks, distributed transactions, and transaction isolation for robust production environments.

• YouTube
• 31 minutes
• On-Demand
• Conference Talk

EuroPython Conference

Slicing and Dicing with Cubes - Light-weight OLAP Framework and Server

Explore lightweight OLAP framework for efficient data analysis, slicing, and dicing using Cubes. Learn server implementation and advanced techniques for multidimensional data processing.

• YouTube
• 2 hours 3 minutes
• On-Demand
• Conference Talk

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
• On-Demand
• Conference Talk

Oracle

Database Consolidation With Persistent Memory

Discover how Exadata leverages Intel PMEM and RoCE 100Gbs infrastructure to accelerate OLTP and OLAP workloads, optimizing database performance and consolidation.

• YouTube
• 17 minutes
• On-Demand
• 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
• On-Demand
• Conference Talk

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
• On-Demand
• Free Video

Data Council

Cubing and Metrics in SQL - Extending Apache Calcite for Advanced Analytics

Explore Apache Calcite's SQL extensions for metrics, measures, and analytic expressions. Learn to define data models, use them in queries, and perform cross-dimensional calculations for advanced analytics.

• YouTube
• 36 minutes
• On-Demand
• Free Video

Data Council

Data Warehouses are Gilded Cages - What Comes Next

Explore DuckDB's potential to revolutionize data analytics, shifting from centralized warehouses to powerful local processing. Learn how this approach can enhance efficiency and user control in data management.

• YouTube
• 40 minutes
• On-Demand
• Free Video

The ASF

Building a Semantic and Metrics Layer Using Calcite

Explore semantic layers for efficient data management. Learn to define business views, query measures, and optimize performance using Apache Calcite's advanced features.

• YouTube
• 40 minutes
• On-Demand
• Free Video

CMU Database Group

Row vs. Column Storage and Compression in Database Systems - Lecture 5

Explore row vs. column storage, compression techniques, and real-world database applications with insights from CMU's Andy Pavlo and StarTree's Xiang Fu.

• YouTube
• 1 hour 28 minutes
• On-Demand
• Free Video