Total clarity: Timely reports, data flexibility power up business intelligence

Upper management at CLARCOR Air Filtration Products has good data, but making it easily accessible is no small task when that data must be extracted, sorted, analyzed, and presented to the right people in the right format. That's why CLARCOR chose to implement a business intelligence (BI) and enterprise performance management system from Bitam, which is accessed by nearly 30 users.


Upper management at CLARCOR Air Filtration Products has good data, but making it easily accessible is no small task when that data must be extracted, sorted, analyzed, and presented to the right people in the right format.

That's why CLARCOR chose to implement a business intelligence (BI) and enterprise performance management system from Bitam , which is accessed by nearly 30 users. The system allows CLARCOR to monitor key performance indicators, examine root causes of problems, and measure the progress of strategic initiatives.

“We can drill down to see why certain things occurred, because with 12 plants it's difficult to get that kind of individual information quickly from our headquarters,” says Tony Ferens, plant controller for the Louisville, Ky.-based subsidiary of CLARCOR.

“We can access efficiency data and break it down by product category, by shift, or product line,” adds Ferens. “Plant managers can see, for example, that Shift One was 90-percent efficient, but Shift Two was 98-percent efficient. They can look up why that occurred and see if a machine could have been down.”

Software-as-a-Service (SaaS)-enabled business intelligence (BI) continues to progress as survey respondents indicate they are considering a SaaS approach simply to accelerate the cycle times for deployment of new BI applications. SaaS BI vendors appear to be promising service-level agreements that included delivery time lines as part of the project scoping process.

Prior to deploying Bitam BI, plant managers received hard copy efficiency reports on a weekly basis. Now users can input notes directly on reports and store them electronically with built-in security and password measures.

The system's Advisor feature issues conditions alerts. “If efficiency drops below 95 percent, the system will send an alert message,” explains Ferens. “A text message or email can be sent if certain thresholds are reached.”

Users also can export information to presentation software such as Excel, or use external reporting systems. “We can manage multiple sites that all have their own data tables and part numbers,” says Ferens. “The system links to Microsoft Word, where users can pull up policy information and review it online.”

Typically, BI systems are first applied at the project level, focusing on both internal and external drivers. An internal focus usually narrows in on the shop-floor level to monitor production lines over time, which enables better understanding of operational efficiencies, says David Hatch, research director for Boston-based Aberdeen Group .

“In the chemical industry, for example, some companies want better information regarding raw material waste,” says Hatch. “They want to know if the right material was used and if quality assurance is doing its job.”

New deployment options for BI offer users numerous flexible implementation scenarios. According to a recent Aberdeen study, nearly 47 percent of users access BI systems from within another system, such as ERP.

The best potential for growth can be seen in the Software-as-a-Service (SaaS) model, with 15 percent of respondents indicating they are using BI in a SaaS model ( see graphic ). At first glance, the number does not seem very high; however SaaS is the only category where the “plan to use” group is larger than the current user group.

“When it comes to deployment, no single option is right for everyone,” says Hatch. “It depends on user skill sets and IT services, and whether or not regulatory issues are involved.”

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.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
Doubling down on digital manufacturing; Data driving predictive maintenance; Electric motors and generators; Rewarding operational improvement
2017 Lubrication Guide; Software tools; Microgrids and energy strategies; Use robots effectively
Prescriptive maintenance; Hannover Messe 2017 recap; Reduce welding errors
The cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Mobility as the means to offshore innovation; Preventing another Deepwater Horizon; ROVs as subsea robots; SCADA and the radio spectrum
Research team developing Tesla coil designs; Implementing wireless process sensing
Commissioning electrical systems; Designing emergency and standby generator systems; Paralleling switchgear generator systems
Natural gas engines; New applications for fuel cells; Large engines become more efficient; Extending boiler life

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.
The maintenance journey has been a long, slow trek for most manufacturers and has gone from preventive maintenance to predictive maintenance.
Featured articles highlight technologies that enable the Industrial Internet of Things, IIoT-related products and strategies to get data more easily to the user.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.
Maintenance Manager; California Oils Corp.
Associate, Electrical Engineering; Wood Harbinger
Control Systems Engineer; Robert Bosch Corp.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me