Analytics header

Friday, May 18, 2012

How hard is it to define MI requirements?

Well let's say its not straightforward! For quite some time I have been trying to explain the difficulties in providing clear specification for Manufacturing Intelligence (MI) system. In addition the life science industry is still bound by traditional methods of analysis, requirements specs and functional specs that simply put will not work for MI. MI's whole purpose is to provide information to somebody to support his creative behavior as he explore root-causes and solutions in the dynamic world of manufacturing operations. (This is an extract from a forthcoming article in Pharmaceutical Engineering).

The right approach is based on the critical element of understanding how people use information to solve problems and gauge performance. There is a clear need to provide effective and relevant information necessary to support the information consumed by the different roles in the manufacturing operations. Identifying what needs to be measured is a fundamental principle but it is not sufficient, the information also has to be arranged in a usable manner. Therefore it is important to study and understand information consumption patterns by roles. Take for example the information consumption pattern for a supervisor in a biotech plant that is creatively analyzing a production event.


The production supervisor glances at his dashboard and observes that the Cell Density is not within acceptable limits. He immediately navigates to view the “Cell Density by Time” trend over the last 2 weeks and observes a negative trend beginning around “Mon.” that indicates something is seriously not in order. 
To begin the analysis, he examines the “Media Batch Feed Schedule” to see if there is any correlation between the trend and the Media that is being fed to the bio-reactor. This action is obviously based on intuition possibly because he has seen that before. Seeing that there is a correlation between the change to a new Media batch feed when the trend start he decides to take a look at the “Exception By Batch” information and notices that this specific batch had an unusual number of exceptions. He then dives deeper into the data by analyzing an exception Pareto for the suspect batch. He finds a high number of operator errors, which clearly highlights the root cause of the trend. Finally since he is accountable for operational profits he decides to take a look at the cost impact of this event in order to understand what the impact is to the plants financial performance (see graphic below). Unfortunately the cost impact is substantial and thus he as to take action to mitigate this increased cost. 


The scenario shows the power of “Actionable Intelligence”. The supervisor has all the information he needs in order to quickly and effectively analyze the situation to determine root-cause and he can take action based on the results. The path that the supervisor decides to take in the example above is one of several that could have been used to detect and diagnose the Cell Density performance issue. It is this type of self-guided or self-serve analysis that really shows how information is consumed to meet a specific goal and should be the common pattern for the information required by a specific person or role. These requirements have direct bearing on the information context and data structures that must be provided, and the dimensions by which the metric is analyzed or “sliced and diced”. Although this seems trivial at first the requirements that this analysis patterns has on the underlying information and data structures is significant and is a critical component of the system design. It is not enough just to collect the data; it has to be arranged in a manner that enables this unique type of analytic information consumption.

Thursday, December 29, 2011

Why Do We Still Use Spreadsheets?

Sometimes I find some unfinished article while cleaning up – something I should obviously do more regularly! So here is one of these excerpts that I found particularly relevant as I am discussing the topic of “Manufacturing Intelligence” with a number of companies.

Manufacturing systems software vendors continuously tell us that you cannot have visibility into your operations without a software application, which I have to agree is generally true. This forces us to sift through the onslaught of offerings full of buzz words such as “metrics”, “digital dashboards”, and “business intelligence platforms”. Yet, it is remarkable that one of the most commonly used tools to capture and manage information from the shop floor is The Spreadsheet - typically Microsoft’s Excel. In some cases, even with a major ERP system investment, the Spreadsheet is still the primary source of timely data collection about the manufacturing operations. In other cases, expensive solutions are put in place to capture and collect data from automation equipment but fail to provide the information in a useable context and once again users resort to the spreadsheet.


Why is it then that manufacturing organizations resort to solutions that are based on a spreadsheet? It is typically not because of lack of understanding about information systems or the skills required to use them. It is because a spreadsheet provides the flexibility and ability to manage and present shop floor information in the most useable and advantageous manner. (By the way the common term for “manage and use” is “information consumption”.) Remember that a manufacturing manager’s main focus is productivity and quality. They use this information to obtain metrics about the value stream that they are trying to manage because they need to know how they are performing in real time. This need is similar to that of a sport’s team, where you know where you stand at every second of the game. You don’t have to wait until tomorrow morning’s newspaper to know who won the game. Running a manufacturing operation without real time metrics is like bowling without being able to see the pins. You can see some of the action, you know that something happened, but you don’t know what the result was.

Of course in recent years, manufacturers have gained some visibility with the increased application of technology, but they are still far from what is possible. I also believe that most of the vendors are clearly aware of the needs and I hope that they we will soon start to see Manufacturing Intelligence applications with the flexibility and convenience that we really need.

Wednesday, November 2, 2011

A Foundation For Quality (and performance...)


Next week is ISPE’s annual meeting in Texas and once again I am participating in an interesting session titled “Operational Excellence - A Foundation for Quality”. We held a similar session last year and it was a great success with more than 90 people participating. The topic that I am covering this year is about the current capabilities of automation technology andinformation systems that provide a vital ingredient in enabling operational excellence. I will be joined by speakers from Pfizer, Celgene, Amway and of course NNE Pharmaplan.

My co-presenters will share experiences about OperationalExcellence, Quality by Design (QbD), and Process Understanding. All-in-all an interesting combination of topics that may initially seem loosely related but they are in fact deeply related. They stem from the some old notion that manufacturing performance is a holistic concept. I have mentioned in a previous post that we are “re-inventing the CIM wheel” but at the same time we are also looking at it in a new perspective with much more modern and usable technologies.  I strongly believe that before we venture with new ideas we have to look and learn from the past, it is very likely that somebody has had a similar problem and may even have a solution. So CIM, PAT, QbD, DFM it really is all related, related to trying to excel at we do and work more synergistically to accomplish our manufacturing goals. 

Thursday, October 13, 2011

Metrics & Performance Management - Again

Not that again! Well it still is a very interesting topic an one that I encounter every time I talk to companies in the life science industries. It seems that there is an increased understanding across all walks of life in the manufacturing organizations that one of the main advantages of system is the ability to gain a better understanding of both process and operations. I hear people asking for metrics, and in the context of gauging their performance. I spend a lot of time trying to understand this trend, and I have no conclusion yet. It may be the economic climate, maturaity of the technology, or maybe the momuntum that operational excellence intiatives have gained?

The membership of the ogranziations that I work with such as MESA and ISPE have also shown great interest in this topic and I am participating in a few events that highlight them. On October 27th we have a MESA webcast about "Harnessing the Power of Metrics" and on November 7th we are organizing a special session at the ISPE annual meeting about "Operational Excellence - A Foundation for Quality". The session will be hosted by NNE Pharmaplan and will include speakers from Amway, Celgene and Pfizer. I hope to have some great discussions, feel free to track me down if you are in attendance.