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

Capacitive Coupling Effects
Alarm and Trip Systems
Learn about PLC, DCS, RTU, SCADA, and PAC
Control Systems Interview Questions & Answers
Control System Architecture
Compare Modbus, Fieldbus, and Profibus
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

Cascade Control Principle
Motor Control Signal Interface
Electrical and Instrumentation – Automation Pre-engineering Documents
Types of Cathodic Protection for Pipeline Protection
4-wire Transmitters Current Loops
Overview of PID Control terms
Understanding a Process Control Loop
Centralized vs Decentralized Automation Systems

Keep Learning

DCS Program to Maintain Draft in Furnace

DCS Program to Maintain Draft in Furnace

Design & Construction of Process Plant

Process Control Systems Philosophy Concept

Two wire loop powered transmitters

4-20 mA Transmitter Wiring Types : 2-Wire, 3-Wire, 4-Wire

SinkingOutput

Difference Between the Sinking and Sourcing?

Most Asked Questions on SCADA

Most Asked Questions on SCADA with Answers

Control Sytem Open Loop and Closed Loop

Introduction to Control System

Hook-up Diagram for Pressure Gauge

What is Instrument Hook Up Diagram ?

Find the Fault in the Temperature Loop

Fault in the Temperature Loop

Learn More

Pressure instruments example circuit

Motion-Balance and Force-Balance Instruments

Power Supply Voltage Regulator Problem

Troubleshooting a Power Supply Circuit

Masking in PLC

What is Masking in PLC?

Analyzers Questions and Answers

Magnetic Wind Instruments Questions & Answers

Flange Types and Definitions

Flange Types and Definitions

Snubber Circuits

Thyristor Protection Circuits (SCR) – Types, Principle, Explanation

High Integrity Pressure Protection System HIPPS

Overview of HIPPS System

Electric Circuits Objective Questions

Electric Circuits Objective Questions – Set 14

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?