Visualization of KPI data - Your ideas please

G

Greg B

#11
Crombes said:
please find some pics of the infocorner

these cover following items :
PPM level for the 4 biggest customers + # complaints
PPM level for the Key suppliers +# complaints
worst supplier rating
cost non quality
overview scrap costs + sort & rework costs

...
Crombes,
My humble advice is to ask the operators what they would klike to see! Charts are great at seeing raw data but to an operator working shiftwork and having only a few minutes of their valuable time to peruse a notice board or such like, they are all "gobbledegook"...J"oe Blogs", on the floor, wants to know what he/she can do to prevent NCs (for example) from occuring. They want to see what the NCs were for last month. What can THEY DO to prevent them? Honestly, the shop floor does not care that it took 3.6 weeks for Document 'A' to be updated or that the QA department has 100% coverage of audits. This is good for the QA dept but for the average worker it is a lot of coloured lines on graph paper. Find out the lowest common denominator and undertsand what they would like to see. What do they understand about the system and the need to have KPIs? The best graphs in the world could just be an abstract bit of art to the uninitiated!
 
Elsmar Forum Sponsor

Sambasi

Involved - Posts
#12
Here is an example for displaying of kpi's (monthly kpi status)in a manufacturing area.The red zone is "out of target" and green zone is "within target". Reasons for not acheiving the target for a kpi can be explained in the "Remarks" column.
In my experience, this kind of display catches the attention of all.
 

Attachments

D

donaghadee - 2008

#13
We use quandrant analysis graphs in our call centre eg. for plotting sales against compliance of advisors.

Green = High Sales/ High Compliance
Yellow = Low Sales/High Compliance
Amber = Low Sales/Low Compliance
Red = High Sales/Low Compliance

Advisors can immediately see where they are and where they shoul be aiming to be
 
Last edited by a moderator:

Statistical Steven

Statistician
Staff member
Super Moderator
#14
Sambasi said:
Here is an example for displaying of kpi's (monthly kpi status)in a manufacturing area.The red zone is "out of target" and green zone is "within target". Reasons for not acheiving the target for a kpi can be explained in the "Remarks" column.
In my experience, this kind of display catches the attention of all.
Those surely are pretty plots. How does management take action? Do they look for a monthwhen the data gets into the red zone?
 

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#15
Caster said:
How to Lie with Statistics dates back to the 50s but is one of my very favorite books. I have lent and lost many copies over the years. Steve, I suspect you have read it? If not you'd love it. The lessons can be used for good or evil as the need arises.
Yes, both books you mentioned are very good, I don't own copies of them but have seen them. You'll find other postings here on the Cove by me about the advantages of using SPC. Although given enough pressure to make an arbitrary number, a person can come up with some way to distort or falsify the numbers, it is a bit harder to get away with it in a culture using SPC. And the need to falsify or distort becomes less in a culture using SPC.
 

Sambasi

Involved - Posts
#16
Statistical Steven said:
Those surely are pretty plots. How does management take action? Do they look for a monthwhen the data gets into the red zone?
These are kpis pertaining to production such as Production acheived, sub-standard, waste,i/o ratio etc. The kpis are reviewed in a weekly meetings and corrective actions are initiated. However monthly data plotted to visualise the trends.
 

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#17
Sambasi said:
These are kpis pertaining to production such as Production acheived, sub-standard, waste,i/o ratio etc. The kpis are reviewed in a weekly meetings and corrective actions are initiated. However monthly data plotted to visualise the trends.
As a follow on - the Fluor Hanford dashboard charts (which are SPC) are updated on a monthly basis for our major business units. On a weekly basis, 8 of our leading indicators are reviewed at the Monday morning senior staff meeting overviewing company total results.
 

Attachments

S

Sleepless

#18
I agree with Greg B. and others. Find out what the missing NEED is.

Also, if you're only using bar charts, there are various other SPC packages that you can purchase, or just try out, which will allow you to analyze your data and present it better. These same packages allow you to use various sampling techniques when presenting the data such as selecting all data points in a particular range (actuals), only aggregates (like averages or maximums), or just a best fit (which reduces the overall number of points used in the calculation). These same tools provide upper and lower limit lines that can be either manually or automatically set.
 

Statistical Steven

Statistician
Staff member
Super Moderator
#19
Mr

Steve Prevette said:
As a follow on - the Fluor Hanford dashboard charts (which are SPC) are updated on a monthly basis for our major business units. On a weekly basis, 8 of our leading indicators are reviewed at the Monday morning senior staff meeting overviewing company total results.
Steve, you and I rarely disagree, though I must disagree with you. Using SPC to chart monthly data does not serve the purpose of SPC. Unless it is setup to allow for real time feedback, finding out that a point went out of control 3 weeks ago is of little use. The opporunity to take correct action or root cause analysis is gone.
 

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#20
Steve, I think you are overlooking the issue of what is a good periodicity for data updates. If we are dealing with a production line making thousands of widgets a day, then there may be multiple updates during a single day. On these safety indicators, there is not a need for updates more often than a month. Yes, managers find out about their injuries real time. But, for purposes of saying - what is the trend - are injuries up or down - a monthly update works out fine here. Sometimes I think the weekly updates I do lead to more tampering than actual actions. I even have some business unit level indicators that are only updated on a quarterly basis as that is how long it takes to generate meaningful data for trending and analysis purposes. And it is in a low enough risk area that a quarterly update is sufficient. There actually is a monthly update that rolls several of the quarterly data together, but to get the detail needed for management it takes a quarter.

This is an issue of economics - balancing the costs of frequent updates (both the direct and indirect costs) with the risk of what can go wrong between updates.
 
Thread starter Similar threads Forum Replies Date
John Predmore Interactive visualization through graphical simulation of statistical concepts Statistical Analysis Tools, Techniques and SPC 3
K FAA Repair Station KPI's AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
V Internal Auditor Competency KPI IATF 16949 - Automotive Quality Systems Standard 14
G Need to change KPI we called NC parts (maximum 3%.) to FTQ (first time quality) IATF 16949 - Automotive Quality Systems Standard 4
V Informational SMMT IATF Oversight - OEM KPI Process IATF 16949 - Automotive Quality Systems Standard 4
GreatNate Where to get a KPI dashboard for QMS processes Quality Tools, Improvement and Analysis 5
qualprod Monitoring of lead time - Good KPI identification? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 14
qualprod On Time Delivery KPI for sales? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
J Level 3 KPI Excel Template Manufacturing and Related Processes 1
K A way to monitor our Internal Audits as a KPI AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 7
O Identifying KPI for AS9100 8.1.4 - Prevention of Counterfeit Parts - PCB assembly contract manufacturer AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 16
qualprod Criteria to raise a Nonconformance based on KPI values ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 39
Ashok sunder What are the criteria for setting a target KPI value against a quality objective? Benchmarking 7
M QMS Efficiency KPI as a Manager. IATF 16949 - Automotive Quality Systems Standard 7
J KPI Software - Our weakness is in KPI's Manufacturing and Related Processes 7
D KPI's Data for Customer Service AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
S AS9100 Customer KPI Log AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
R ISO 9001:2015 - KPI (Key Performance Indicators) vs. Objectives ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
J KPI's for AS9100 Cl. 8.2/8.5 - Bids/Contract Review/Order Entry AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 10
K Further Analysis of Departmental KPI (Key Performance Indicator) Statistical Analysis Tools, Techniques and SPC 2
A KPI for Quality Assurance Team in a Service Oriented Industry Service Industry Specific Topics 8
Q Additional KPI to Top Management beside Quality Objectives ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
1 KPI Dashboard Template in Excel Format wanted Excel .xls Spreadsheet Templates and Tools 9
Q Is KPI in Process Valid if not supported by Procedures? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
V AS9100 8.2.1 (C) or 9.1.2 (D) Customer Satisfaction - KPI's AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
A What KPI's do you use at Shop Floor Level and Team Boards? Quality Tools, Improvement and Analysis 4
W NCR Performance KPI Monitoring in an Industry like Construction Nonconformance and Corrective Action 1
A Does KPI for Processes need to be correlated with the specific Risks for Processes? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
R Excel Dashboard for Health Safety and Environmental KPI's for Multiple Sites Occupational Health & Safety Management Standards 4
Q Who can Change goals and kpi of top management? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
Q KPI (Key Performance Indicators) for the Audit Process ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
L KPI Project help - Business and Management Degree Benchmarking 4
Q KPI's (key performance indicators) for a Print shop ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
A KPI's for Individuals (Employees) Manufacturing and Related Processes 10
V KPI (Key Performance Indicators) in First Article Inspection Lean in Manufacturing and Service Industries 4
P Internal Audit Scope - Company's KPI (Key Performance Indicators) Internal Auditing 7
S KPI for Q&EHS Management System example wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
J KPI for time to close NCs (Nonconformances) Quality Manager and Management Related Issues 17
S Understanding Quality Objectives, Metrics and KPI ISO 13485:2016 - Medical Device Quality Management Systems 15
B Should CAR be issued when the KPI is not achieved ? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
Q Determining Processes, Objectives and KPI's ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
R KPI Review Meetings never discusses previous meeting action plan status Quality Manager and Management Related Issues 5
G Differences between Quality Objectives and Business KPI's ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
K Safety Lead and Lag KPI's Quality Manager and Management Related Issues 5
B Shall issue CAR when KPI fail? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
M KPI (Key Performance Indicators) for a Service Company Benchmarking 1
T KPI, Dashboards and Pre-Assessment Questionnaires question ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
A Quality Objectives 5.4.1 - KPI SOP - ISO 13485 Audit Observations EU Medical Device Regulations 6
Q Must Support Processes have defined KPI's (Key Performance Indicators)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
K Sales Department KPI's (Key Performance Indicators) template and suggestions Misc. Quality Assurance and Business Systems Related Topics 1

Similar threads

Top Bottom