Course 2: Modelling Concepts

This course describes some of the internal workings of PhixFlow to give you a better understanding of how to create well-designed models. This course covers techniques that will allow you to create all but the most advanced models.

Before Starting

Before starting this course, ensure you have completed:

• PhixFlow Fundamentals course - this covers the basics of all areas of PhixFlow
• Course 1: Introduction to Modelling - this covers covers modelling basics and introduces you to key terms used in the Modelling Concepts course

It is important the above courses are completed before starting this course as the concepts covered in this Modelling Concepts course will build on your knowledge gathered in the Fundamentals and Introduction to Modelling courses.

Course Content

This course contains the following chapters:

• 1 Populating Models With Data
• 2 Using Excel Templates
• 3 Combining Data Sets
• 4 Picking latest sales update for each customer
• 5 Breaking-out into multiple output records
• 6 Reading from specific Excel worksheets
• 7 Enriching data directly from database tables
• 8 Merging data sets directly from database tables
• 9 Filtering Table Output
• 10 Merging and Enriching Recordsets
• 11 Static Tables and Static Pipes
• 12 Show All Successors, Show All Predecessors, Show Models
• 13 Rolling Back Tables
• 14 Attribute Scripting
• 15 Creating and using macros
• Modelling Concepts Next Steps