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 the 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

Browser not supported