Home > About EPAC > Products > Services > Contact > Get Information > Support >

Click on an industry below to view some of our latest customers. Manufacturing   Office Buildings   Hospitals   Schools   Colleges   Stadiums   Hotels   Casinos   Municipalities   Government   Commercial

Connect to Paul Oberg=

We go to great lengths to capture it, store it, organize it and ultimately, we use some of it! Data is all over the place within our organization whether it exists in electronic or hardcopy format and we constantly are looking for more of it. Data has become an essential component in our business toolbox. When faced with a business decision, we look for data to bolster our wisdom and experience. However, lurking within our information environment, the challenge to efficiently and appropriately use data is constantly being challenged by the validity and source of the data. So, how do businesses and organizations within the business, such as maintenance, deal with navigating the data continent?

Most organizations today have many transaction systems to support their business processes. These include financial systems, production systems, maintenance management systems, customer service systems and the like. These transaction systems record events and subsequently store the information within their respective database environments. In some cases, many of these transaction systems share the same database as a result of integration. However, in most organizations, islands of data and information can be found as the transaction systems are truly standalone and never integrate with other systems. This is not necessarily a poor business process as information requirements vary within business functions. Consider for a moment the information required to manage the maintenance organization on a day to day basis. This information includes work orders, spare parts, and labor resources to name a few. Do the folks in the Accounts Receivable department need to have access to this data? Probably not! However, this information is all contained within the maintenance management system to enable the maintenance department to track and record their maintenance activities. Over time, this information continues to grow and grow within the database. At some point, this data may be retrieved in the form of a report, chart or< spreadsheet in order to examine trends or status. One of the primary roles of these transaction systems is to record and store data. Now imagine many transaction systems> recording and storing data in different places. Just think for example, every time you dial the telephone a transaction is recorded: the date and time, the number called and the length of the call are just some of the data elements stored. Considering that there are many transactions being recorded from multiple transaction systems, how do businesses consolidate all this information and why? The most common strategy for bringing all this data together is data warehousing. Simply, a data warehouse is a collection of information within a single information environment usually located on dedicated computer hardware. This strategy provides the user community with a common< location to look for and retrieve information. Sounds easy and simple but as we have learned, there are always challenges which must be overcome.

First and foremost, garbage-in, garbage-out. Data warehousing will not insure the quality or validity of data. To a certain degree, this is one of the jobs of the transaction system, but the ultimate responsibility lies with the source and entry point 3 of the data. As in any analysis and decision process, the supporting documentation and information must be of impeccable quality.

Secondly, be prepared for a significant effort at the beginning to initialize the data warehouse with all the appropriate data from the appropriate source. It is sometimes easy to visualize this effort as filling a wheelbarrow with shovels of data from different piles of information created by multiple transaction systems. At the very least, what you end up with is a wheelbarrow full of stuff which has little or no meaning. It becomes the duty of the responsible data warehouse to not only define the appropriate source but also define the appropriate relationships between the data elements so that retrieval performance can be optimized. This becomes an on-going task as new transaction systems are added, removed or upgraded.

Implementing the appropriate tools to retrieve, analyze and format the information is another important component of utilizing any data< warehouse or data storage configuration. It is essential that the capabilities of end users be considered when providing a reporting tool. End users should not need a degree in computer< programming or computer science to be able to retrieve and present desired information. Data mining is often a term used to define the process of retrieving data. While purists may correctly insist that data mining is more than just retrieving data from a data source, the casual user thinks of data mining as the activity of extracting data from a database whether it be a data warehouse or from the transactional system. Fortunately, there are many tools available today to perform this function from spreadsheet software to sophisticated business intelligence toolsets. Presentation of retrieval results can vary including reports, information dashboards, multidimensional charts and the like. Remember, all this capability requires quality data, trained users on the right tools and enough computing power to process the requests.

Often times the question is asked why not provide the data retrieval tools to access the transaction data environment? Think about the transaction system in use in your job today and the last time someone (or you) attempted to retrieve a large amount of information (maybe accidentally) and the resulting decline in system performance as evidenced by the moans and groans coming from the adjacent cubicle. Where there are many users on the transaction system, the opportunity for this to occur increases. To avoid this from happening, data warehouses are typically installed on their own computer which can be sized appropriately for this activity without competing with transaction processing.

Security of information is another challenge facing the implementation of a data warehouse and data access tools. Where the transaction systems have their own security as to who can see certain data and perform certain tasks, this same capability has to be implemented within the data warehouse for obvious reasons.

The previous paragraphs have identified some of the considerations for a data warehouse environment. The greatest advantage for a data warehouse is a common set of data elements for use by the organization. This eliminates the “my data doesn’t agree with your data” comments as the information is all coming from the same place. Of course, timing is always an issue as data is always retrieved at a point in time and as a result, is constantly changing. In most cases, where there is a great quantity of information from numerous transaction systems with many users, 4 the benefits of data warehousing far outweigh the challenges.

But what about small to medium sized organizations? Does this strategy make sense? The answer to these questions is on a case by case basis. For many small companies, data warehousing is likely unnecessary due to the volume of data and number of users. For medium sized companies, the strategy is dependent upon these two factors; the larger the data volume and number of users retrieving the data, the more appropriate the strategy becomes.

Today, there are many tools available within the transaction software to retrieve and present data. It is important to be mindful that evaluating and analyzing the data is the most important activity. Trends may be more important than snapshots. For example, losing a baseball game in the middle of the major league season is only a single event; however, losing eight consecutive games in the middle of the season is a trend that requires corrective action. Similarly, within the maintenance arena, schedule compliance being low for a week is not likely cause for concern but a trend downward for several weeks does require attention. Information overload and analysis paralysis are terms to constantly keep in mind when determining data and information requirements. Collecting, storing and retrieving data which does not provide value is a waste of valuable resources. To get the most out of information systems, improve the quality of that data which will facilitate value decisions, while using appropriate tools, to improve and enhance the performance of the organization. In the end, effort is noble, but it’s results that count!

5 About The Author C. Paul Oberg is President and Chief Executive Officer of EPAC Software Technologies, Inc., a leading developer and integrator of Computerized Maintenance Management Systems.

A Certified Management Consultant, Mr. Oberg has significant experience in operations improvement, productivity improvement, manufacturing/distribution management, Total Quality Management and the design and implementation of manufacturing systems.

Mr. Oberg holds a Bachelor of Science degree in Industrial Engineering, and a Master of Business Administration degree. His professional affiliations include the Institute of Management Consultants, Institute of Industrial Engineers, and American Production and Inventory Control Society.

Mr. Oberg is a frequent speaker on operations and productivity improvement, maintenance management, inventory management, and manufacturing and distribution information systems.