There are several times each year when managers are interested in trending charts coming from their aviation safety management systems (SMS). These times include during:
Trending is perhaps among the most difficult tasks for safety managers when they don't have automated tools and databases to capture hazard reports and classify these reported issues.
Let's assume you have data. Which questions should you be asking to generate your trending charts?
Trending charts are commonly used by managers to understand how an organization is performing in relation to a goal or objective. Trending charts are created using data points over an established time period, such as:
Since aviation SMS data must be collected and measured, a database remains the best alternative to store and retrieve data driving the creation of trending charts. Aggregating data manually into MS Excel spreadsheets can be performed by most safety managers, but there is a high degree of risk if your organization is relying upon manual processes.
Manual processes for data collecting and measurements:
I met a safety manager several years ago who spent three weeks each year aggregating data and generating reports because he relied on paper reports and spreadsheets. After acquiring an aviation SMS database, all managers in his company were able to accurately generate useful trending charts with little effort.
Even though an aviation safety database allows managers to generate reports to analyze safety and quality processes, one should not be led to believe that a safety database takes away all work. A spreadsheet is not demanding or sending out notifications that you have work to do. Your SMS database enhances visibility into your risk management processes, while also enforcing accountability. It is hard to hide from regular notifications of overdue tasks.
In the long run, safety and quality managers may be actually spending more time managing SMS data using a safety database than without the database; however, they are doing a little at a time over a prolonged period of time. The results are more accurate and timely when performed properly.
In short, there are two possible processes to collect safety and quality data to generate trending data:
For SMS implementations, the first approach is preferable for companies:
When you create trending charts, you are basically grouping data according to selected classification parameters over time. Questions drive the generation of trending charts.
When considering these questions, it may be best to focus on your organization's key performance indicators (KPIs). KPIs have been selected for a particular reason, whether they are important to:
If you have not selected KPIs relating to your aviation SMS implementation, we urge you to do this before you build your classification systems which will drive your trending charts.
When we create trending charts, there are a few variables of interest. They include:
When we consider "types of issues" to review, we consider:
A good trending chart tool will allow you to start with all types of issues and then drill into each specific type on demand. Of course, we are talking about easily and quickly generating real-time reports. The best aviation SMS tools are user-friendly and easy to use by all authorized managers.
Another useful consideration is having the ability to weed out all types of issues except your KPIs. If you are using an aviation SMS database today, you know there are many ways of classifying reported issues or events; however, not all types are important to monitor the process that "answers your questions." Therefore, we need a way to easily filter KPIs from the sea of data.
If you cannot easily and quickly create a trending chart from your data, there is a big risk to your aviation SMS implementation. You cannot effectively monitor safety performance in your SMS implementation without the ability to classify reported issues and easily pull out valuable trending charts.
Trending charts allow management to set goals and objectives and to regularly monitor progress.
Trending charts also increase the effectiveness of safety teams in detecting problem areas that require additional risk management focus. Trending charts look back at historical data. This may cause some safety professionals to question the value of trending charts, but as we have repeatedly heard, "history tends to repeat itself."
From experience, I believe the best example of trending charts' value comes from identifying repeating trends. For example, I recently saw one trending chart that indicated the operator suffered from multiple runway-related issues in 2016. What was interesting to me was that the runway trend declined in 2017, but started to reappear again in late 2018. The trend reappearance was caught early and urged management to review related hazards and risks, and implemented control measures.
This proved to be a great example of where a recurring trend was caught early. Management was able to reduce further losses and adjust operations based on the trend analysis.
You can manually create your trending charts, but if you are like my friend who spent three weeks a year collating data for trending charts, you are probably ready to either:
But the question you must ask management is:
How can our company demonstrate continuous improvement of our SMS to regulatory authorities and SMS auditors without being able to easily create trending charts?
If you need help with trending charts to monitor the progress of your SMS implementation, you should consider SMS Pro. SMS Pro is considered among the best aviation SMS software programs designed specifically for the aviation industry.
If you want to see SMS Pro in action, here are some short demo videos that were recently made.
Last updated in August 2024.