Introduction to Modelling Course
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.
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