Introduction to Modelling Course

This course will introduce you to modelling in PhixFlow: gathering data, transforming it, exporting and presenting it. In addition to the exercises, there is additional information in the following slides: PhixFlow Training - Introduction to Modelling slides.pptx

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. 

Course Content

This course contains the following exercises:

• 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