Master the art of advanced data modeling with the Formulate course, tailored for professional users seeking to build custom KPIs, member lists, formulas, and scripts using Pyramid Query Language (PQL) or MDX.
This course empowers you to inject complex business logic into your analyses, enhancing the depth and precision of your data insights. By the end, you’ll be adept at leveraging Pyramid’s Formulate module to create sophisticated, reusable calculations that drive impactful decision-making.
In order to replicate the walkthroughs in this course, please download and install this Training Data Model (2023).
🕑 6 hours
Course Content
Walkthrough 1: Formulate overview and building a 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
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
Walkthrough 10: Sales Variance (Current and Prior Year)
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
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
