All Units

Introduction 

  1. Architecture

Core Concepts 

  1. Installation
  2. Configuration

Data Connectivity 

  1. Basics
  2. Mitsubishi Electric FA
  3. OPC Classic
  4. OPC UA
  5. DeviceXPlorer
  6. SNMP
  7. Modbus
  8. Web Services
  9. Databases
  10. Other Connectivity Options

Dashboard Visualization 

  1. Basics
  2. Symbols
  3. Commanding
  4. Navigation
  5. Aliasing
  6. Asset Navigator
  7. Alarm Viewer
  8. Grid Viewer
  9. Trend Viewer
  10. Recipes
  11. Schedules
  12. Fault Viewer
  13. Camera Integration
  14. Helper Controls
  15. Advanced Controls
  16. 3D Graphics
  17. Security
  18. Cloning

Clients 

  1. Basics
  2. Desktop Deployment
  3. Web Browser Deployment
  4. Mobile Deployment
  5. KPI Self-Service Dashboard

Data Historian 

  1. Basics
  2. Visualization
  3. Calculations
  4. Data Exchange
  5. Advanced Architectures

Asset Organization 

  1. Basics
  2. Defining Assets
  3. Commanding
  4. Asset Templates
  5. Visualization
  6. Bulk Asset Configuration
  7. Advanced Topics

Alarming & Notifications 

  1. Basics
  2. Hyper Alarm Server
  3. Hyper Alarm Logger
  4. Alarm Visualization
  5. AlarmWorX64 Server
  6. AlarmWorX64 Logger
  7. Converting AlarmWorX64 to Hyper Alarm Server

Helper Modules 

  1. Recipe Management
  2. Scheduling
  3. Triggers
  4. Localization
  5. Unified Data Manager
  6. Workflows
  7. Expressions

Security 

  1. Basics
  2. Security Server
  3. Audit Logging
  4. Securing Data in Transit
  5. Securing Data at Rest

Cloud & IoT 

  1. Basics
  2. Broker Configuration
  3. Data Connectivity
  4. IoTWorX

Reporting 

  1. General
  2. Report Data Formats
  3. Advanced Topics

Automated Transactions 

  1. Basics
  2. Process Files
  3. Processing Data Sources
  4. Notifications
  5. Advanced Topics

Business Intelligence 

  1. Basics
  2. Data Flows
  3. Data Models
  4. Data Views
  5. Visualization

Project Management 

  1. Project Backups

Fault Detection & Diagnostics 

  1. Basics
  2. Fault Rules
  3. Diagnostic Models
  4. Cost Analysis
  5. Visualization

SPC/SQC Analysis 

  1. Basics
  2. Visualization

Energy Analysis 

  1. Basics
  2. Energy Calculation
  3. Visualization
← Return to Business Intelligence
SECTION 2

Data Flows

Total: ~27 min

Data Flows may be used to import, transform, and prepare datasets for later use in BI functions.

Key Uses for Data Flows

Data flows organize data into relevant datasets. The data sources used for the data flows are any of the sources availble in the ICONICS software platform, such as OPC UA, Web services and databases.

2:05 min

Connecting to Real-time and Historical Data

We will discuss how to define realtime data as the source for the Data Flows as well as time series data to use a collection of historical data records.

3:37 min

Using Parameters in Data Flows

Parameters filter only relevant data to be used in the data flows. We will explain the use of parameters to create a historical time span for the data model.

2:38 min

Connecting to Datasets

We will discuss how to query datasets froma database, use these in Data Flows and to add or remove columns with additional content.

4:12 min

Connecting to Metadata

Descriptions of point names, ranges and other data can be used as meta data. The information becomes useful when users would like to filter and relate specific data to view at runtime.

3:14 min

Filtering and Requesting data

Data flows should only contain the relevant data. We discuss the best approach to filter a subset of data, request the relatime data and to transform a dataset to create a desired content.

5:01 min

Adding New Columns Using Expressions and Transposing Datasets

Columns can be added to the dataflow to create additional content based on expressions. If needed, the dataset can be transposed to present the data in a different format to better fit a specific purpose.

6:38 min