Reporting data architecture and performance optimization

This module focuses on architecting scalable and high‑performing reporting solutions in Pega applications. You learn how data modeling, query design, aggregation strategies, and reporting architectures influence system performance and scalability, and how to apply design patterns that improve reporting efficiency. You explore how Pega Platform™ generates SQL for reports, how query and aggregation choices impact performance, and how to use structures such as the Pega Common Application and reporting databases to support reusable, optimized reporting data architectures. The module emphasizes performance optimization and alignment with Pega Platform and database best practices.

Avanzado

Inglés

Después de completar este módulo, podrá hacer lo siguiente:

Evaluate data modeling and reporting architecture impacts on performance and scalability.

Design efficient queries for reporting data retrieval and aggregation.

Apply the Common Application for standardized and reusable reporting structures.

Optimize report and database performance using rule‑ and database‑level techniques.

Align reporting designs with Pega Platform and database best practices.

Disponible en la siguiente misión:

Infrastructure and Architecture v1

Temas

Inclusive and exclusive queries

30 minutos

Queries based on generated or reformatted data

30 minutos

SQL functions

30 minutos

Reports and performance

10 minutos

Configuring rules to improve report performance 

25 minutos

Database tuning to improve report performance

20 minutos

Reports databases

10 minutos

Aggregated data

10 minutos

Basics of the Common Data Model

10 minutos

Class structure of the Common Data Model

10 minutos

Designing enterprise data access with Pega Live Data

10 minutos

Cuestionario del módulo

25 minutos