This guide introduces you to Pyramid’s powerful analytics ecosystem and how it transforms raw data into meaningful, actionable insights. You will explore how calculations, business logic, and scripting work together to support accurate analysis, dynamic reporting, and data-driven decision-making. From understanding different calculation types to using tools such as Formulate and Prequel scripting, this course will equip you with the knowledge to build flexible, interactive, and consistent analytical solutions within Pyramid.
1. Pyramid ecosystem
This video introduces Pyramid’s analytics ecosystem, showing how raw data is transformed into dashboards and reports through data preparation, calculations, and modeling. It highlights tools like Formulate and Discover, along with no-code and pre-built options that support efficient and flexible data analysis.
2. Calculations
In Pyramid Analytics, calculations convert raw data into insights using three types: granular for detailed accuracy, semantic for aggregated analysis, and context for real-time, dynamic reporting.
3. Formulate
The Formulate module enables users to create and manage calculations, including custom formulas, KPIs, and scripts. It supports consistent analysis, reusable logic, dynamic data filtering, and interactive dashboards with advanced business rules.
4. Model
The video explains how calculated metrics enhance analysis by enriching dimensions, enabling dynamic segmentation, and supporting custom groupings. It also shows how advanced business logic can create multiple measures from existing data.
5. Present, Publish and Illustrate
The video introduces Prequel scripting and its role in creating dynamic queries and calculations. It shows how Prequel connects to multiple data sources, supports advanced analysis, and enables real-time, flexible data interactions through both graphical and native scripting.