Course 1: Introduction to Modelling

This course introduces how modelling works in PhixFlow, including gathering data, transforming it, exporting and presenting it. You will also learn the basic techniques that will allow you to create simple models. 

Before Starting

Before starting this course, ensure you have completed:

• PhixFlow Fundamentals course - this covers the basics of all areas of PhixFlow

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
• Introduction to Modelling Next Steps

Beyond this Course

Once you have completed this course, if you would like a more in-depth understanding and to learn advanced techniques, we recommend you complete the Course 2: Modelling Concepts.