Analysis Model Window Layout

You are here, below is a simplified view of the screen editor.

1. The Toolbar provides screen specific options, such as displaying existing tables which can be added to the canvas and the option to create new tables or file collectors.
2. The Repository and Property Editors are displayed to the right of the canvas. They provide navigation to locate existing items, the ability to create new items and access to the options for each editable item.
3. The Canvas area where the Analysis Model will be configured. New items, such as Tables and File Collectors, can be added to the canvas by dragging on the associated toolbar icon, existing items are added by dragging the items from the repository onto the canvas.
4. Steps, such as Tables and Datasources appear on the canvas and are connected by pipes. Pipes perform different roles such as allowing data to flow through (solid lines) or performing lookups (dashed line) to retrieve additional information such as looking up a product code and returning its name.

Analysis Models Overview

Analysis Models are the graphical representation of the processing that will be carried out by PhixFlow. Analysis Models  They define how data is collectedimported, transformed, viewed, analysed and exported. They are made up of modelling objects , each of which performs one or more of these functions. For example a datasource allows PhixFlow to connect to an external source for the purposes of retrieving and writing dataDatabase; a Table (formerly known as a stream) allows you to write functions that will to manipulate the data , such as removing invalid records or normalising a namecalculating a value.

The Analysis Models are the main back-end process in PhixFlow and run whenever the generation of a Table is requested. This can be triggered in three two ways:

1. Run Analysis

1. : An ad-hoc request from a model, by clicking the 

   Insert excerpt
   _run_analysis _run_analysis nopanel true

    in the Table's pop-up toolbar.
2. Scheduling a Task: By a task plan

1. .

As PhixFlow runs the analysis steps, it reports on progress using messages in the System Console. You can open the system console up at any time by clicking the icon

• Datasources
• Database Collectors 
• File Collectors 
• Tables (Table Propertiess) 
• Database Exporters 
• File Exporters

Getting Started

1. Importing Data from Excel
2. Importing Data from a Database
3. Viewing Data (Understanding Data Views)
4. Transforming Data
5. Exporting Data
6. Creating Dashboards and Reports

Downloads

1. Example Data
2. Example Application

Learn More