Training Sessions >> Build Super Tables from Operational Data
Instructor: Richard G. Lamb, PE, CPA, ICBB; Analytics4Strategy.com
A “data-driven” operation is defined as one that harnesses its operational data to augment the experience and judgement of operatives, managers, analysts and engineers as they plan, organize, conduct and control their processes.
Massive troves of data are captured in thousands of tables in the background of a firm’s operating systems such as a CMMS. To be capable of becoming data-driven; role holders across an operation must know how to extract tables from their systems and join and mold them into single “super” tables. The purpose of the session is to teach its attendees how to build super tables.
The following characteristics make the session maximally relevant and consequential to its attendees and their firms:
The agenda is as follows:
Who Should Attend
The following role holders to the subject process should attend:
Customization for Hands-on Experience
The session can be easily customized upon an organization’s systems and data. When hands-on customization is elected, the slide set will include instructions to download a specified set of tables from their sources. Thence, the attendees will follow along hands-on as the session progresses. The value is that the emergence of an organizations ability for working with its data will spread more broadly and quicker. This is because the attendees will leave the session “having done it for the first time” as compared to “trained to do it for the first time.”
Two options decide session length.
The attendees will receive an electronic link to the session slides for their download and use in the organization. Throughout the slides, there will be references to texts, explanatory documents, blogs and YouTube videos.
Should the organization elect to customize the session on their data, the attendees will receive instructions for replicating extracted tables with which to track the session.
Instructor: Richard Lamb, PE, CPA
In 2003 Richard Lamb was called upon to build a dual-dimensional budget and variance control system for a refinery’s maintenance operation (see papers on webpage “Cost Control and Finance”). While struggling to get at the historical data captured in the CMMS he needed to determine the workload and resources necessary to maintain the refinery, he discovered that he could readily reach into the refinery’s CMMS for its data and join them in super tables. Since then the Richard has made the discovery as a standard to his work for operational excellence. Along the way he has observed how few people know the easy, exciting skills of extracting and joining data into super tables that otherwise do not, cannot and will never exist in their systems.
In 2014, the instructor began to sense that software—one being free to all—was emerging to not just pass data through to facts but also pass data through analytics and gain insight we could not have before. The sense of something new kicked off what became an intense five-year quest to determine and frame what was newly possible so that it could flow as something tangible into the mainstream of operational excellence.
The result was to discover that bar of what is operational excellence had been raised by the readily obtainable ability to be data-driven. This has greatly strengthened his acumen of almost 40 years as an adviser in business strategy, finance and operations, including almost 30 years with maintenance and reliability, and preceded by 6 years as a manager of complex civil engineering projects. This has also pushed Richard to become an activist to help others recognize and move into what can be new age for their career and, as they do, being hugely consequential for their firms and industries.
Richard is a Registered Professional Engineer and Certified Public Accountant. He has published two books presenting new ideas for reliability and maintenance management framed in business strategy: Availability Engineering and Management for Manufacturing Plant Performance, and Maintenance Reinvented for Business Performance. He has a BSCE, BBA and MBA from the University of Houston and a graduate-level Applied Statistics Certificate from the Texas A&M University.