Pro: Formulate (2023)

Current Status

Not Enrolled

Price

Free

Get Started

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
Walkthrough 2: % of Parent calculations
Walkthrough 3: Year to date (YTD) and Prior YTD formulas
Walkthrough 4: Top 10 products
Walkthrough 5: Last N Months Trend
Walkthrough 6: Last N Weeks trend with Linear regression
Walkthrough 7: Parameter Date Range
Walkthrough 8: Moving Average
Walkthrough 9: % Total using Measure parameters
Walkthrough 10: Sales Variance (Current and Prior Year)
Walkthrough 11: Top products pie chart
Walkthrough 12: Quick KPIs
Walkthrough 13: Grid KPIs
Walkthrough 14: Formulate KPIs
Walkthrough 15: KPIs and Parameters
Walkthrough 16: Dynamic captions
Walkthrough 17: Data source-driven color logic
Walkthrough 18: Custom visualizations
Walkthrough 19: Custom columns
Scroll to Top