Modeling Fundamentals Orientation Video

Set a solid foundation for co-builds with your Pigment implementation team with the Modeling Fundamentals Certification Learning Path. This learning path consists of 20 micro-lessons. This orientation touches on each micro-lesson and the topics to be covered at a very high level. More detail on each topic is provided in the individual micro-lessons.

Who should take this course?

This course is designed for Modelers who intend to co-build their Pigment solution with the Pigment team. 

Topics Covered

• Explain how multidimensional modeling differs from traditional linear planning in spreadsheets
• Review the fundamentals from a more technical perspective
• Describe the Pigment formula structure and syntax
• Identify how and when to use formula modifiers
• Use the ADD modifier to add a dimension to a block’s structure
• Use the REMOVE modifier to delete a dimension from a block’s structure
• Use the BY modifier to transform the dimensions in a block’s structure
• Use the FILTER, SELECT and EXCLUDE modifiers to update data shown in a block
• Explain the importance of aligned block dimensions for formula operations
• Practice aligning block dimensions for formula operations
• Use a datahub for shared applications and dimensions in Pigment
• Build a Staff Costs application
• Build a Management Reporting application
• Demonstrate your newly acquired knowledge and skills in the certification exam for the Modeling Fundamentals badge

Content Type

• On-Demand
• Video

Course Duration

About 4 minutes 

Before You Begin

Prerequisites: To get up to speed on how to navigate in Pigment and complete the most frequently done tasks, we recommend that everyone completes the Pigment Essentials for Everyone learning path before starting the Modeling Fundamentals learning path.