Inst ToolsInst ToolsInst Tools
  • Courses
  • Automation
    • PLC
    • Control System
    • Safety System
    • Communication
    • Fire & Gas System
  • Instrumentation
    • Design
    • Pressure
    • Temperature
    • Flow
    • Level
    • Vibration
    • Analyzer
    • Control Valve
    • Switch
    • Calibration
    • Erection & Commissioning
  • Interview
    • Instrumentation
    • Electrical
    • Electronics
    • Practical
  • Q&A
    • Instrumentation
    • Control System
    • Electrical
    • Electronics
    • Analog Electronics
    • Digital Electronics
    • Power Electronics
    • Microprocessor
  • Request
Search
  • Books
  • Software
  • Projects
  • Process
  • Tools
  • Basics
  • Formula
  • Power Plant
  • Root Cause Analysis
  • Electrical Basics
  • Animation
  • Standards
  • 4-20 mA Course
  • Siemens PLC Course
Reading: DCS Alarm Summary Dashboard using Microsoft Power BI
Share
Font ResizerAa
Inst ToolsInst Tools
Font ResizerAa
  • Courses
  • Design
  • PLC
  • Interview
  • Control System
Search
  • Courses
  • Automation
    • PLC
    • Control System
    • Safety System
    • Communication
    • Fire & Gas System
  • Instrumentation
    • Design
    • Pressure
    • Temperature
    • Flow
    • Level
    • Vibration
    • Analyzer
    • Control Valve
    • Switch
    • Calibration
    • Erection & Commissioning
  • Interview
    • Instrumentation
    • Electrical
    • Electronics
    • Practical
  • Q&A
    • Instrumentation
    • Control System
    • Electrical
    • Electronics
    • Analog Electronics
    • Digital Electronics
    • Power Electronics
    • Microprocessor
  • Request
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 !

Continue Reading

What is PID Controller?
What is a Active Barrier ?
Process Control Systems Philosophy Concept
Identify Faults in PID Control Loop
De-energize to Safe Loop philosophy
What is Safety Control System ?
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
210kSubscribersSubscribe
38kFollowersFollow

Categories

Explore More

Most Asked Questions on SCADA with Answers
Understanding Emergency Shutdown Button Installation (ESD)
Difference between Cold Standby and Hot Standby
Proportioning Feedforward action
Free PID Controller Gains Tuning Tool
PID Controller Theory
How Important is VPN for Control Engineers?
Fundamental Motion Control Commands

Keep Learning

What is FAT and SAT?

What is FAT and SAT? Difference between them

Zener Barrier Protection

Zener Diode Barrier Principle

compressor emergency shutdown system

Compressor Emergency Shutdown Root Cause Analysis

Difference between Router, Switch, and Hub

Difference between Router, Switch, and Hub

Schneider Electric Modicon M340 PAC

PLC vs PAC – Understanding the Key Differences and Similarities

annunciator-alarm-simulator

Alarm Simulator for Annunciator Logic

Types of Cables used in Industrial Automation

Types of Cables used in Industrial Automation

Loop Power Indicator Principle

Basics of Loop Powered Devices

Learn More

Pneumatic Moment-balance Differential Pressure Transmitter

Pneumatic Moment-balance Differential Pressure Transmitter

Power Systems Questions & Answers

Power Systems MCQ Series 22

What is Rapid Spanning Tree Protocol

What is Rapid Spanning Tree Protocol? – RSTP Network

Two Wattmeters to Measure 3 Phase Power

Three Phase Wattmeter

Displacer Level Transmitter Calibration Procedure

Displacer Level Transmitter Calibration using Water & Process Liquid

Electrical Cables Interview Questions & Answers

Electrical Cables Interview Questions & Answers

Power Electronics Objective Questions

Half Wave Diode Rectifier Quiz

Top 100 PLC Projects List

Top 100 PLC Projects List

Menu

  • About
  • Privacy Policy
  • Copyright

Quick Links

  • Learn PLC
  • Helping Hand
  • Part Time Job

YouTube Subscribe

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?