Course Description
This e-Learning training focuses on the Formulate module within Pyramid.
Formulate allows advanced pro end-users to build custom KPIs, member lists, formulas, scripts, and more, using the Pyramid Query Language (PQL) or MDX. These can then be used in visualizations and queries to customize content or inject formulas and values into data.
In this course, you will receive expert insights around this application; critical for harnessing the potential of Pyramid’s advanced data analysis.
This training is based on Pyramid 2023. You can complete the course on the Pyramid Explore sever; simply sign-up for access. Or you can install this Training Model (2023) onto your own Pyramid environment.
Course Content
UNIT 1: CALCULATIONS
Walkthrough 1: Overview of Formulate and Total Sales formula
You don't currently have access to this content
Walkthrough 2: % of Parent calculations
You don't currently have access to this content
Walkthrough 3: Year to date (YTD) and Prior YTD formulas
You don't currently have access to this content
UNIT 2: PARAMETERS AND LISTS
Walkthrough 4: Top 10 products
You don't currently have access to this content
Walkthrough 5: Last N Months trend
You don't currently have access to this content
Walkthrough 6: Last N Weeks trend with Linear regression
You don't currently have access to this content
Walkthrough 7: Parameter Date Range
You don't currently have access to this content
Walkthrough 8: Moving Average
You don't currently have access to this content
Walkthrough 9: % Total using Measure parameters
You don't currently have access to this content
UNIT 3: GAUGES, KPIS AND THEMES
Walkthrough 10: Sales Variance
You don't currently have access to this content
Walkthrough 11: Top products pie chart
You don't currently have access to this content
Walkthrough 12: Quick KPIs
You don't currently have access to this content
Walkthrough 13: Grid KPIs
You don't currently have access to this content
Walkthrough 14: Formulate KPIs
You don't currently have access to this content
Walkthrough 15: KPIs and Parameters
You don't currently have access to this content
UNIT 4: DYNAMIC CAPTIONS, CUSTOM VISUALS AND CUSTOM COLUMNS
Walkthrough 16: Dynamic captions
You don't currently have access to this content
Walkthrough 17: Data source-driven color logic
You don't currently have access to this content
Walkthrough 18: Custom visualizations
You don't currently have access to this content
Walkthrough 19: Custom columns
You don't currently have access to this content