Practical application and core solutions
========================================

Build on foundational knowledge and begin applying key Analytics
Accelerator technologies in your environment.

What you will learn
-------------------

- How to set up and query EDB Postgres Lakehouse clusters

- How to work with Apache Iceberg and Delta Lake tables

- How to implement tiered tables with PGD

- How to connect BI tools to the Analytics Accelerator

- How to apply these technologies to BI reporting, historical data
  analysis, and operational analytics

Before you begin
----------------

- :ref:`Analytics Accelerator concepts <Analytics Accelerator concepts>` 

Suggested learning path
-----------------------

1. :ref:`Create a Lakehouse cluster <EDB Postgres Lakehouse>` 

2. :ref:`Configure an Iceberg REST catalog connection <Apache Iceberg>` 

3. :ref:`Query existing Apache Iceberg tables <Apache Iceberg>` 

4. `Query Delta Lake tables <https://enterprisedb.com/docs/edb-postgres-ai/hybrid-manager/analytics/learn/how-to/query-delta-lake-tables>`_ 

5. `Configure PGD node group for analytics offload <https://enterprisedb.com/docs/edb-postgres-ai/hybrid-manager/analytics/learn/how-to/configure-tiered-offload>`_ 

6. `Configure BDR AutoPartition with analytics offload <https://enterprisedb.com/docs/edb-postgres-ai/hybrid-manager/analytics/learn/how-to/configure-tiered-autopartition>`_ 

7. `Query Tiered Tables from PGD and Lakehouse <https://enterprisedb.com/docs/edb-postgres-ai/hybrid-manager/analytics/learn/how-to/query-tiered-tables>`_ 

8. `Connect BI tools to the Lakehouse <https://enterprisedb.com/docs/edb-postgres-ai/hybrid-manager/analytics/learn/use-cases>`_  *(as appropriate)*

Next steps
----------

Once you’ve completed 201, continue with:

👉
