PHIXFLOW TRAINING
INTRODUCTION TO MODELLING WORKBOOK
PhixFlow Version 6
10 February 2016
!worddav348d3085035cf3d99341a92e32d0d000.png|height=150,width=900!Table of contents
1 Creating new models
1.1 Create a new model
1.2 Adding modelling components to your model
1.3 Moving modelling components on the pane
1.4 Saving changes to your model
2 Reading data from files into PhixFlow
2.1 Create a new File Collector
2.2 Set up File Collector and Stream
2.3 Pause file data
2.4 Run Analysis on Stream
2.5 View Stream data
3 Creating Datasources and Database Collectors
3.1 Create a new Datasource
3.2 Create a Database Collector from the Datasource schema browser
3.3 Create a Stream automatically from a Database Collector
3.4 Run Analysis on Stream
3.5 View Stream data
4 Merging Sets of Data
4.1 Run Analysis on Stream
4.2 View Stream data
5 Reading data from Excel spreadsheets
5.1 Set up File Collector and Stream
5.2 Pause file data
5.3 Run Analysis and view Stream data
6 Enriching Data Sets
6.1 Copy data from merge
6.2 Create lookup into reference data
6.3 Enrich a data set using a Lookup Pipe
7 Collecting data from a database using a supplied query
7.1 Collect data from a database using a supplied query
7.2 Enrich customer data with last billed amount
8 Transforming data
8.1 Reformat post codes to remove all spaces and make upper case
8.2 Generate short code for Counties
8.3 Categorise bills as "LARGE" or "NORMAL"
8.4 Set special processing flag
8.5 Run stream
9 Filtering on pipes
10 Aggregating in pipes
11 Exporting data to databases
11.1 Reviewing your exported data
12 Exporting data to files
13 Using the PhixFlow task bar
14 Creating Tasks and Task Plans
14.1 Creating Tasks and Task Plans
14.2 Scheduling Task Plans
15 Editing Models
15.1 Drag existing modelling components into a modelling view
15.2 Remove an object from a model view
15.3 Permanently delete an object
16 Populate models with data
17 Creating and configuring Stream Views
17.1 Finding Streams and Stream Data
17.2 Create New Stream View
17.3 Editing a Stream View
18 Create further Stream Views
18.1 Create a line chart (time series)
18.2 Setting an upper limit
18.3 Setting a lower limit
18.4 Fixing the scale
18.5 Create a 3D bar chart
18.6 Create a 3D pie chart
18.7 Create an aggregate view
18.8 Create a pivot view
18.9 Finding views in the Views List
19 Introduction to Filters
20 Advanced Filters
20.1 Create a filter using an expression
20.2 Set default filter on a view
20.3 Using the same filter on other views
21 Setting default sort orders
22 Building dashboards
22.1 Create a new dashboard
22.2 Remove dashboard elements
22.3 Add view
22.4 Set dashboard to maximise on opening
22.5 Apply filters on dashboards
22.6 Using background filters
22.7 Using prompt for value filters
23 Creating linked views
23.1 Create a linked view
23.2 Make update of driven views automatic
24 Extra exercises
24.1 Update database exporter
24.2 Update File Importer