The search for business intelligence

Anyone who tracks the evolution of information technology in our society might come to the conclusion that there is no limit to our need for information. This is an easy conclusion to make since the number and sophistication of our information systems appear to be growing at precipitous rate. We keep implementing new functionality to address specific business needs and requirements.


Anyone who tracks the evolution of information technology in our society might come to the conclusion that there is no limit to our need for information. This is an easy conclusion to make since the number and sophistication of our information systems appear to be growing at precipitous rate. We keep implementing new functionality to address specific business needs and requirements. But the results of our efforts are inevitably more and more data.

While our ability to control specific transactions and work flows through information technology continues to increase, how effective are we at making tactical decisions based on the mounds of data we collect? Information may be an asset, but in copious quantities it can literally choke the decision-making process. We might be impressed by the number of reports and inquires within our enterprise applications, but can we effectively use these tools? Despite all their underlying data, do our applications present the information we really need in a manner that we can effectively use in our decision-making processes?

Business intelligence (BI) is a collection of tools, applications, and technologies designed to address the issues raised by the above questions. Its basic value proposition is that it can help a company tap into key decision-making information that traditional reporting tools cannot provide or present in a manner that allows for immediate action. BI is a common topic in sales, marketing, and supply chain applications. Without knowing much about BI, it should be easy to image why it would be a hot topic in identifying customer buying trends or supplier performance. But is BI relevant in the CMMS/EAM world?

To answer this question, one first must have a basic understanding of BI from a conceptual level. This doesn't require an in-depth understanding of its technical architecture — only a rudimentary grasp of the basic components used to build BI solutions. From a very simplistic viewpoint, BI solutions can be broken down into three primary building blocks:

Analytical — These are tools and applications used to explore and analyze data from multiple perspectives. They are used to discover and publish trends inherent in data but not self-evident. They are typically referred to as online analytical processing (OLAP) software. Under the OLAP umbrella falls a whole host of tools and techniques used to statistically forecast, model, and analyze data.

OLAP doesn't necessarily mean BI. Some OLAP solutions are complex, requiring a sophisticated skill set to effectively use. But BI is a very user-centric concept. BI OLAP products provide graphical front-ends that allows users to visually slice-and-dice information innumerable ways. Their learning curve is significantly shorter than traditional OLAP tools.

Report writers and ad-hoc query tools — These are the most familiar part of the BI equation. They offer end users the ability to create and publish custom reports and inquiries. The ability to produce visually oriented results makes a report writer or query package BI-friendly. They also provide end users the ability to drill-down through these results. With a click of a mouse, a user can move from a high to lower-level display to successfully investigate underlying trends and structures.

Data storage — These solutions provide an infrastructure for the other two components. BI can consume a lot of data processing power. It can also cut across multiple applications tying together disparate data sources. Running BI analytical and reporting tools directly against production databases can significantly degrade performance and present significant integration challenges.

BI vendors provide a variety of tools to extract, transform, and load data into formats more suitable for BI analysis and reporting. Data marts are the usual end target for this process. Data marts are specialized databases designed to store information from multiple sources and optimized for the type of analytical processing inherent in BI solutions.

From a high level perspective these components may just seem a repackaging of existing IT tools. But most traditional reporting and analytical tools are static in nature providing information snapshots produced by a series of structured events. BI is a dynamic concept. Its delivery mechanisms are designed to deliver continuous information in near real time. BI solutions typically allow end-users to dynamically change the parameters used to drive its reports and inquiries. They also permit end-users to dynamically investigate the underlying trends inherent within any information display. Users can quickly move from a high to low levels of information in the quest to quickly answer key decision-making questions.

BI solutions don't necessarily incorporate all of these components and attributes. But they do share the common objective of providing the information needed to quickly make decisions. These aren't the typical operational questions that applications usually help address. They are decisions that organizations make to enhance their competitive position.

Given this viewpoint, BI does have relevance for maintenance management. Since its inception, CMMS/EAM software has provided mission-critical information to help maintenance departments increase the competitiveness of their companies. But CMMS/EAM packages have grown considerably in functions and features. Originally, maintenance organizations used them primarily to control operations. While the number of their reports and inquiries keep expanding, our ability to effectively sift through this mound of information is being overtaxed increasingly.

A CMMS/EAM can produce trend information needed by maintenance decision makers. It can summarize emergency outages, identify failure trends, gauge labor performance, measure vendor performance, and report on many other service indicators. But does it provide maintenance managers with ability to quickly view key performance indicators and measurements? Does it allow maintenance to look beneath the reported numbers to discover root causes and truly analyze trends? Is it proactive in its delivery mechanisms alerting maintenance about issues and problems as they happen?

Traditional CMMS/EAM reporting tools can't effectively answer these questions. Realizing this, most top-tier CMMS/EAM vendors now provide a BI solution set or path for their product line. Approaches vary, but they can be categorized as follows:

Alliances — Many top CMMS/EAM vendors partner with an established BI solution provider like Cogos (, Brio Technology ( and Crystal Decisions ( These alliances are typically more about marketing than technology sharing and integration. But a few joint references/case studies can provide a good indication about the real strength of the alliance.

Incorporate BI functionality — BI techniques can be directly incorporated into a CMMS/EAM package. Datastream's ( MP5i has more than 20 pre-defined key performance indicators (KPIs) that provide end-users with BI views of asset, work order, inventory, purchasing, and project management data. MP5i also provides the ability to modify existing or create new KPIs. Mincom ( is another EAM solution provider that supplements their products with integrated BI functionality. Look for more and more CMMS/EAM vendors to incorporate KPIs, digital dashboards, balanced scorecards, and other BI techniques into their packages.

Data marts — The structure of application databases is not well suited for BI solutions. BI is a data-crunching proposition that can cross multiple applications. EAM provider Indus International ( addresses this issue through their Knowledge Warehouse, which provides the data extraction, transformation and storage tools needed to drive and distribute BI solutions. Cayenta ( is another EAM vendor that provides custom data warehousing and BI development services capable of supporting enterprise-centric BI solutions.

BI hasn't yet established a large footprint in the CMMS/EAM world. It is still an emerging concept. However, it certainly has relevance for any company seeking to maximize the value of information locked away in its CMMS/EAM database. Organizations still struggling to gain control of their basic maintenance operations will gain more return by devoting their energies elsewhere. But for certain companies integrating BI into their CMMS/EAM equation will pay considerable dividends.

No comments
The Top Plant program honors outstanding manufacturing facilities in North America. View the 2015 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
Safety for 18 years, warehouse maintenance tips, Ethernet and the IIoT, GAMS 2016 recap
2016 Engineering Leaders Under 40; Future vision: Where is manufacturing headed?; Electrical distribution, redefined
Strategic outsourcing delivers efficiency; Sleeve bearing clearance; Causes of water hammer; Improve air quality; Maintenance safety; GAMS preview
SCADA at the junction, Managing risk through maintenance, Moving at the speed of data
Safety at every angle, Big Data's impact on operations, bridging the skills gap
The digital oilfield: Utilizing Big Data can yield big savings; Virtualization a real solution; Tracking SIS performance
Applying network redundancy; Overcoming loop tuning challenges; PID control and networks
Driving motor efficiency; Preventing arc flash in mission critical facilities; Integrating alternative power and existing electrical systems
Package boilers; Natural gas infrared heating; Thermal treasure; Standby generation; Natural gas supports green efforts

Annual Salary Survey

Before the calendar turned, 2016 already had the makings of a pivotal year for manufacturing, and for the world.

There were the big events for the year, including the United States as Partner Country at Hannover Messe in April and the 2016 International Manufacturing Technology Show in Chicago in September. There's also the matter of the U.S. presidential elections in November, which promise to shape policy in manufacturing for years to come.

But the year started with global economic turmoil, as a slowdown in Chinese manufacturing triggered a worldwide stock hiccup that sent values plummeting. The continued plunge in world oil prices has resulted in a slowdown in exploration and, by extension, the manufacture of exploration equipment.

Read more: 2015 Salary Survey

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.
This article collection contains several articles on the vital role of plant safety and offers advice on best practices.
This article collection contains several articles on the Industrial Internet of Things (IIoT) and how it is transforming manufacturing.
This article collection contains several articles on strategic maintenance and understanding all the parts of your plant.
click me