Adroit SCADA Intelligence

Adroit SCADA Intelligence is an out-of-the-box data warehousing and business intelligence solution that
collects, processes and organises historical data from disparate data sources into a structured industry
standard data model (ISA-95 Expanded Equipment Hierarchy). The resulting information is then made
available on a common platform to enable informed decision making.

Adroit SCADA Intelligence Overview

The Technology

Adroit SCADA Intelligence is developed on Microsoft SQL 2008 R2 Enterprise. Microsoft Business Intelligence solutions scale to the growing needs of your organization and provide the agility to respond quickly to changes.
The Adroit SCADA Intelligence Application
• The Adroit SCADA Intelligence Manager is used to configure data connectors, define how and when data is to be processed, database archiving, system backups, monitor system performance, processing durations and system error logs.
• The Adroit SCADA Intelligence Analyser allows users to do ad hoc analysis on both the Data Warehouse and the Operational Data Store using drag and drop functionality.

Application of Adroit SCADA Intelligence

  • • Production Reporting
  • Equipment Performance
  • Overall Equipment Efficiency
  • Network Performance
  • Operator Performance
  • Enviromental Management
  • Carbon Footprint Reporting
  • Water Balance Reporting
  • Distribution Management
  • Quality Management
  • Telemetry Network Management

Some Industries using Adroit SCADA Intelligence

  • Water
  • Mining, Metals and Minerals
  • Telecommunication
  • Power
  • Facilities Management
  • Food and Beverage
  • Oil and Gas
  • Cement

Adroit Alarm Intelligence Product Architecture

ASI Architecture

Retrieval of time based historical data from multiple data sources

Captured data is transformed into information (The Extract Transformation Load)

Summarised information is stored in a multidimensional Data Warehouse

Information presented through software such as Excel or Adroit SCADA Intelligence Analyser

Reduced configuration time

The Adroit SCADA Intelligence software is quick and easy to install. The items and context model can be easily configured through the Adroit SCADA Intelligence Manager or the Microsoft Excel import I export functionality. This reduces implementation time, effort and therefore cost of  your Adroit SCADA Intelligence solution.

Reporting templates

Adroit SCADA Intelligence comes standard with report templates, sample reports and report parts that can be used to create custom reports. This allows for rapid development and customisation of your Adroit SCADA Intelligence solution.

Seamless Excel analysis

Standard OLAP functionality in Excel enables users to connect to the Adroit SCADA Intelligence data cube directly. This familiar and intuitive environment allows users to easily do ad hoc analysis and reporting off their data with little or no training.

SharePoint capabilities

Adroit SCADA Intelligence is built on the Microsoft Bl platform that allows for the seamless integration into SharePoint technologies.

The Adroit SCADA Intelligence Analyser user interface

Without any other software it is possible to use the standard Adroit SCADA Intelligence Analyser to extract information in trends and other standard views. User defined reports can be created, stored and shared with other interested parties.

Multiple data sources

Data can be collected from Microsoft SOL databases, manual data input and 3rd party applications such as SCADA Historians (Citect Historian and Wonderware’s lnSOL).

Transform raw data into information

Time based historical data is one dimensional, however the real world is not. Adroit SCADA Intelligence allows users to add context which transforms the data into information adding enormous value in the process.

ISA-95 structured equipment hierarchy

Adroit SCADA Intelligence allows data to be contextualised into the S95 extended physical model. This model is an industry accepted standard used to organise enterprise data.

Microsoft SQL Reporting Services

Adroit SCADA Intelligence is built on the Microsoft Bl platform and as such allows users to take full advantage of the applications that leverage the technology. Features include:

  • Web based reporting: Reports can be made available on the web via SQL Server Reporting Services (SSRS).
  • Reports available in different formats: (email, Excel, PDF and HTML).
  • Scheduling reports: Reports can be scheduled or created on demand.
  • Drill down functionality from reports: Users can drill down from reports in data for further detailed analysis.