Inst ToolsInst ToolsInst Tools
  • Ask
  • Courses
  • Videos
  • Q & A
    • Interview
      • Instrumentation
      • Electronics
      • Electrical
      • Practical Questions
    • MCQ
      • Instrumentation MCQ
      • Electrical MCQ
      • Electronics MCQ
      • Control Systems MCQ
      • Analog Electronics MCQ
      • Digital Electronics MCQ
      • Power Electronics MCQ
      • Microprocessor MCQ
      • Multiple Choice Questions
  • EE
    • Electronics
      • Electronics Q & A
      • Electronic Basics
      • Electronic Devices & Circuits
      • Electronics Animation
      • Digital Electronics
    • Electrical
      • Electrical Basics
      • Electrical Q & A
      • Power Electronics
      • Electrical Machines
      • Electrical Animation
      • Power Systems
      • Switchgear & Protection
      • Transmission & Distribution
  • Measure
    • Control Valves
    • Calibration
    • Temperature
    • Pressure
    • Flow
    • Level
    • Analyzers
    • Switches
    • Vibration
    • Solenoid Valve
  • Control
    • PLC Tutorials
    • Control Systems
    • Safety Instrumented System (SIS)
    • Communication
    • Fire & Gas System
  • More
    • Design
    • Tools
    • Animation
    • Basics
    • Formulas
    • Standards
    • TextBooks
    • Common
    • Software
    • Excel Tools
    • Erection & Commissioning
    • Process Fundamentals
    • Videos
    • Books
Search
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Reading: DCS Alarm Summary Dashboard using Microsoft Power BI
Share
Notification Show More
Font ResizerAa
Inst ToolsInst Tools
Font ResizerAa
  • Courses
  • PLC Tutorials
  • Control Systems
Search
  • Ask
  • Courses
  • Videos
  • Q & A
    • Interview
    • MCQ
  • EE
    • Electronics
    • Electrical
  • Measure
    • Control Valves
    • Calibration
    • Temperature
    • Pressure
    • Flow
    • Level
    • Analyzers
    • Switches
    • Vibration
    • Solenoid Valve
  • Control
    • PLC Tutorials
    • Control Systems
    • Safety Instrumented System (SIS)
    • Communication
    • Fire & Gas System
  • More
    • Design
    • Tools
    • Animation
    • Basics
    • Formulas
    • Standards
    • TextBooks
    • Common
    • Software
    • Excel Tools
    • Erection & Commissioning
    • Process Fundamentals
    • Videos
    • Books
Follow US
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Inst Tools > Blog > Control Systems > DCS Alarm Summary Dashboard using Microsoft Power BI

DCS Alarm Summary Dashboard using Microsoft Power BI

I’ve developed this Alarm Summary Dashboard using Microsoft Power BI which visualizes DCS alarms for a healthy control system environment.

Last updated: February 28, 2024 2:57 pm
Editorial Staff
Control Systems
No Comments
Share
5 Min Read
SHARE

ICS – Industrial control system is the backbone of a process or plant. It involves operation components like open loops, closed loops, 3rd party communications, and critical parameters like fire & gas, ESD trips & shutdowns.

Operator interaction with operator station is focused on all above components’ operating & monitoring. Monitoring important parameters is a higher priority to maintain balance in the entire process establishment at the primary level.

Though panel operators are habited for quick response over parameter ups & downs, during process abnormality they can handle it very well, but each parameter variation may cause alarm flooding on the operator station.

Due to the flooding, the panel operator may miss some of the important alarms during process abnormality & it may increase the risk from small-scale to high scale production loss as well as big disaster causing financial as well as human life loss.

To maintain alarm generation, EEMUA 191 standard was published in 1999 and it is globally accepted for good practice of alarm management or can say alarm rationalization.

DCS Alarm Summary Dashboard

I’ve developed this Alarm Summary Dashboard using Microsoft Power BI which visualizes DCS alarms which is helpful to manage/rationalize alarms & make a healthy control system environment. Microsoft Power BI is a single-page visualization to explain a scenario.

The visualizations on a dashboard are generated from the dataset which is imported from in various formats such as Excel, CSV, SQL, or Web URL. DAX functions in Power BI make visualization more powerful, effective & time-saving.

DCS Alarm Summary Dashboard using Microsoft Power BI

Here in this dashboard, we can import DCS alarms in excel or CSV format in Power BI and it will represent each visualization as per data imported. In this dashboard you can have:

  • Alarm count summary: Total alarms, Alarms per 10/5/1 minute, ESD alarms & NC Alarms (Not connected/off-display alarms)
  • Alarm counts by source controller
  • Top 10 tags from alarms
  • Alarm category type pie chart
  • Alarm count plot of 24 hours

The most interesting thing is the dashboard is user interactive. It means it reacts as per filter selection on the dashboard. For example, if you select any alarm type from the filter available on the right bottom corner, it will refresh & represents alarm counts, controller, top 10 tags, 24 hours plot & pie chart.

Using this user interactive alarm dashboard, you can analyze alarms generation based on process parameter variation/deviation, loop issues, unnecessary alarms, field equipment error, repetitive alarms, logical errors, the recovery rate of parameter, process interlocks, Realtime-based alarm counts & most/least count of tags which as generating alarms.

This saves a lot of time of analyzing alarms and plan alarm rationalization in the most meaningful way (for both maintenance & production team) to maintain EEMUA 191 standard resulting in better process stability, and so better performance of ICS by decreasing load on the controller as well as ICS network by removing unnecessary alarm flooding.

In addition, I’ve prepared this dashboard in a dark mode which is a famous trend for user interface nowadays.

Thanks to Microsoft for such a powerful tool ‘Power BI’

(Year, Tags & controllers in the image are hidden to respect the data privacy)

I hope this may be helpful for you & your feedback will be appreciated, it will be helpful for my upcoming article contribution.

Author: Sanjay Mistry

If you liked this article, then please subscribe to our YouTube Channel for Instrumentation, Electrical, PLC, and SCADA video tutorials.

You can also follow us on Facebook and Twitter to receive daily updates.

Read Next:

  • PLC Alarm Acknowledge
  • Categorization of Alarms
  • What is Alarm Prioritization?
  • PLC Alarm Acknowledge
Don't Miss Our Updates
Be the first to get exclusive content straight to your email.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
You've successfully subscribed !
What LIC and FIC Controllers will do?
What is Energy Monitoring System ?
The Idea Behind Shielded Cables
On/off Control Theory
Control Valve Split Range Example
Share This Article
Facebook Whatsapp Whatsapp LinkedIn Copy Link
Share
Leave a Comment

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Stay Connected

128.3kFollowersLike
69.1kFollowersFollow
208kSubscribersSubscribe
38kFollowersFollow

Categories

Recent Comments

  • Guifty Shimica on Top Non-PLC Certification Courses for Automation Professionals
  • Guifty Shimica on Top Non-PLC Certification Courses for Automation Professionals
  • MIHARITSOA Aina Sitraka on Top Non-PLC Certification Courses for Automation Professionals
  • Vaishnavi on Free Instrumentation Course for Trainee Engineers

Related Articles

A typical wiring diagram from Field Transmitter to Control Room

How to Wire a Field instrument to Control Room with Example

Manufacturing Execution System in Industrial Automation

Manufacturing Execution System (MES) in Industrial Automation

Closed Loop Control System

Types of Control Systems

Difference between ON-OFF Controller and PID Controller

Difference between ON-OFF Controller and PID Controller

PID Controller Types

PID Controllers : Parallel, Ideal & Series

ICS Control System

ICS Control System Security

Switches, Repeaters, Bridges, Routers, Firewalls

Switches, Repeaters, Bridges, Routers, Firewalls

In this article, you will learn the configuration of PlantPAx library in factory talk studio of Rockwell Automation.

Configuration of PlantPAx Library in Factory Talk Studio

More Articles

Functions of Instrument Transformers

Functions of Instrument Transformers (CTs and PTs)

Electrical Machines Questions and Answers

Speed Control of DC Motors Quiz

Electronics Mini Projects

300+ Best Electronics Mini Projects

Three Phase AC Generators

Three Phase AC Generators

Voltage Control Methods at Distribution System

Voltage Control Methods at Distribution System

Functional Safety Engineering

SIS Safety Requirements

Power Electronics Objective Questions

Thyristor Family Quiz

RTD Connection Diagram

Difference Between 2 wire RTD, 3 wire RTD, and 4 wire RTD’s

Follow US
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?