The Modelling Concepts training 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 the PhixFlow Fundamentals course and the Introduction to Modelling Course. This is important as the concepts covered in this Modelling Concepts course will build on your knowledge gathered in the Fundamentals and Introduction to Modelling courses.

Help

1. Context Help: Each of the main sections in PhixFlow, such as Screens, has a context help page on the right. This contains links to useful pages in the PhixFlow help that will guide you through key tasks. Click on the  Help tab to show or hide this panel. It can also be defaulted to shown or hidden in your user settings. 
2. Help: Each of the main sections in PhixFlow has its own area in the PhixFlow help. While the context help provides links for key tasks, the help contains all the pages.
3. Properties: Every item in PhixFlow has an associated help page that explains its properties, simply click on the   Help in the property editor to access it.
4. Support: Can't find what you need? Or have a specific question? Contact our support team who will be happy to help you. See Support Home

Tips

1. Any of the images in this course can be enlarged by clicking on them.
2. The  Apply button saves changes made in the editor. The  Apply and Close button will save all changes and close the editor.
3. In certain circumstances, edits made to screens do not appear immediately. If you are not seeing the change you are expecting then close the screen and reopen it again.
4. Property tabs can be pinned so they remain open. To achieve this click on the  Pin/Unpin Selected Objects in the tab header.
5. Property tabs can be dragged to create additional columns:
   1. 

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

Application Home Screen

PhixFlow is divided into key areas, each of which is designed to handle a different aspect of application creation:

• ERD: Entity Relationship Diagrams (ERDs) allow us to define the data that backs your application and the relationships between data objects, see Understanding ERDs.
• Workflow: Workflows model business processes from end to end, showing the actual components of your application that performs each activity. They visually depict a detailed sequence of business activities and information flows needed to complete your business process. 
• Screens: Screens allow application users to interact with data. Users drag and drop templates and components to design a screen or customise their own using CSS; see Designing Screens.
• Analysis Use Analysis Models to process large data sets and create integrations with your existing data sources; see Analysis Models for Batch Processing Data.
• Actionflows: An actionflow is a diagram in which you create the functionality of your application in the form of actions. This item is not shown on the home screen but is accessible through buttons and click events associated with screen content.