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 !
Distributed Control System Interview Questions
Project Planning and Implementation of PLC or DCS Control System
Basics of Wellhead Control Panel (WHCP)
What is Maintenance Override Switch (MOS) ?
What is Instrument Hook Up Diagram ?
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

  • Kamli on Top Free PLC Software
  • 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

Related Articles

Why 24 Volts DC Power Supply

Why 24 Volts DC Power Supply is used? – Industrial Automation Systems

Instrumentation and Control (I&C) Design

Instrumentation and Control (I&C) Design

Sink or source PNP or NPN Normally Open or Normally Closed Input v. output. output

Sink or Source? Normally Open or Normally Closed?

Control Valve Split Range Example - 2

Control Valve Split Range Example

Standard Colors in PLC Automation Systems

Standard Colors in PLC Automation Systems

Create a Project in LabVIEW

How to Create a Project in LabVIEW?

Signal Isolator

What is a Signal Isolator? Principle, Advantages, Disadvantages

Why Grounding

Basics of Grounding

More Articles

5-Port-2-Position-Valve-Animation

5 Port 2 Position Valve Working Principle

Electrical Machines Questions and Answers

Quiz on DC Motor Starting

Top 100 Microcontrollers Project Ideas

Top 100 Microcontrollers Project Ideas

Conductive Level Measurement Working Principle

Conductive Level Measurement Working Principle

Analog Electronics Projects

Analog Electronic Projects for Final Year Engineering Students

Digital Electronics MCQ

Binary Coded Decimal (BCD) Objective Questions

Track PLC Operating Modes

#2 PLC Best Practices – Track Operating Modes

Electrical Machines Objective Questions

Electrical Machines MCQ Series 1

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?