This course will introduce you to modelling in PhixFlow: gathering data, transforming it, exporting and presenting it.

Recommendations

It is easier to work through the course if you can see the instructions and PhixFlow at the same time, using either two screens or a split screen.

Run PhixFlow in Google Chrome or Mozilla Firefox. 

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. 

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.

Course Content

This course contains the following chapters:

• 1 Creating new models
• 2 Reading data from files into PhixFlow
• 3 Creating Datasources and Database Collectors
• 4 Merging Sets of Data
• 5 Reading data from Excel spreadsheets
• 6 Enriching Data Sets
• 7 Collecting data from a database using a supplied query
• 8 Transforming data
• 9 Filtering on pipes
• 10 Aggregating in pipes
• 11 Exporting data to databases
• 12 Exporting data to files
• 13 Using the Windows Bar
• 14 Creating Tasks and Task Plans
• 15 Editing Models
• 16 Populate intro models with data
• 17 Creating and Configuring Data Views
• 18 Create further Views
• 19 Introduction to Filters
• 20 Advanced Filters
• 21 Setting default sort orders
• Next Steps