Analytics Accelerator learning paths

Use these learning paths to build knowledge progressively — from foundational concepts to advanced implementations and optimization techniques.

How to use these learning paths

Select the level that matches your current knowledge and goals. Each level links to curated guides with conceptual explanations, how-to articles, and practical tutorials.

For advanced topics and certification, explore official EDB training programs.


Learning path levels

Level 101: Foundations of the Analytics Accelerator

Target audience: Users new to the Analytics Accelerator, those new to modern data analytics concepts, or users seeking a refresher.

Focus: Core ideas, key terminology, the Analytics Accelerator landscape, and reasons behind analytical approaches.

What you will learn:

  • Fundamental concepts of data warehouses, data lakes, and the lakehouse paradigm
  • Key terms such as columnar storage, vectorized query engines, and open table formats (Apache Iceberg, Delta Lake)
  • Overview of the Analytics Accelerator vision with Postgres and core solutions such as EDB Postgres Lakehouse
  • Benefits of separating storage and compute for analytics

Start here: Analytics Accelerator generic concepts


Level 201: Applying the Analytics Accelerator — core technologies and use cases

Target audience: Users with foundational knowledge ready to apply core technologies practically. Suitable for DBAs, data engineers, and developers.

Focus: Hands-on use of EDB Postgres Lakehouse, PGD analytics (including Tiered Tables), and Iceberg/Delta Lake integration. Basic use cases and configurations.

What you will learn:

  • Set up and query EDB Postgres Lakehouse clusters
  • Work with Apache Iceberg and Delta Lake tables
  • Implement basic Tiered Table configurations using EDB Postgres Distributed (PGD)
  • Connect BI tools to the Analytics Accelerator
  • Apply analytics to BI reporting, historical data analysis, and operational analytics

Continue your journey: Analytics Accelerator concepts + How-To Guides


Level 301: Advanced Analytics Accelerator, optimization, and architecture

Target audience: Experienced users, architects, and senior engineers.

Focus: Advanced features, performance tuning, complex architectures, scalability, security, and troubleshooting.

What you will learn:

  • Advanced configuration of EDB Postgres Lakehouse, PGAA, and PGFS
  • Performance tuning for vectorized queries and object storage access
  • Design and implement complex Tiered Table strategies with PGD for optimal cost and performance
  • Manage advanced Iceberg catalogs and integrate third-party catalogs
  • Architect solutions combining the Analytics Accelerator with other data frameworks (Spark, streaming platforms)
  • Troubleshoot complex analytical query performance and data pipelines
  • Apply security best practices for analytical environments

Advance your expertise: Advanced concepts and techniques (expand this section over time)


EDB training and certification

For expert-led instruction and official certification, explore EDB’s training programs and certifications.


Additional guidance


Next steps

Use these learning paths to progress your Analytics Accelerator expertise — from foundational knowledge to advanced optimization and architecture.

Level 101

Learn the foundational concepts of modern data analytics and the EDB Analytics Accelerator.

Level 201

Learn how to practically apply core Analytics Accelerator technologies and use cases.

Level 301

Advanced techniques and architecture patterns for scaling and optimizing Analytics Accelerator implementations.


Could this page be better? Report a problem or suggest an addition!