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.

Advanced

English

After completing this module, you should be able to:

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.

Available in the following mission:

Infrastructure and Architecture v1

Topics

Inclusive and exclusive queries

30 mins

Queries based on generated or reformatted data

30 mins

SQL functions

30 mins

Reports and performance

10 mins

Configuring rules to improve report performance 

25 mins

Database tuning to improve report performance

20 mins

Reports databases

10 mins

Aggregated data

10 mins

Basics of the Common Data Model

10 mins

Class structure of the Common Data Model

10 mins

Designing enterprise data access with Pega Live Data

10 mins

Module Quiz

25 mins