Making reports and follow-up on KPI's - Seeking help on how to track and report

P

pigeon

#1
In our company we are re-thinking our way of making reports and follow-up on KPI's. The challenge is to provinde structure (overview) in the existing KPI's and flexibility when new KPI's or analysis are required.

We developed our own reporting tool in Excel with charts for every KPI (about 30 or so). Every department (7) has an excel file in which basic data is entered. This data is transferred to a master data excell- file, from which we make our KPI's and graphs. Every KPI has a chart and an action-list (action -cause - responsible - due date - check effectiveness) (see example in attachment).

Besides the monthly reporting of the KPI's, there is sometimes the need (ad hoc) to make some additional analysis and reports (personal interest or requested by corporate management, ...). These reports are made by members of management but are saved in personal files or someone else who needs the same analysis, has to do the same work again (in the best case with the same basic data). Sometimes also basic data has to be added for this purpose.

I'm trying to find a well-organized database which enables to give an overview of the exisiting and to easily make 'ad hoc' reports from a set of basic data.

As a first step, I was thinking about making a database in access with an overview of and links to the basic data and KPI-graphs we have (all excell files or data in a excell file), but I have not much experience in this. Making an overview of the ad hoc reports would be the next step.

Can someone provide an example of a database or ideas how to do this?

In attachment an example of how we track KPI's.
 

Attachments

Elsmar Forum Sponsor
J

Joe Cruse

#2
I don't have an example, but if you have anybody in your IT section that has database knowledge, they should be able to write you something to handle this. MS Access could probably handle this fairly easily.
 

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#3
At Fluor, we've gone to a Statistical Process Control format for reporting out KPI's. This has had a great deal of success here, and is spreading throughout Fluor and to other US Department of Energy locations. I have attached a paper called "Leading with Leading Indicators" which outlines the principles. This was also covered in an ASQ Quality Progress article called "Stoplight Charts with SPC Inside" which is available to ASQ members. I have attached a file with a little more detail on how the charts look in the package.
 

Attachments

Thread starter Similar threads Forum Replies Date
M Label Making & Printing Standards ISO / ASTM ISO 13485:2016 - Medical Device Quality Management Systems 5
Steve Prevette Informational I am presenting a webinar Thursday - "Data Driven Decision Making" - 19 November 2020 Statistical Analysis Tools, Techniques and SPC 5
J Masters Degree - Advice about a decision I"m going to be making Career and Occupation Discussions 9
U What is the process for making updates to our Processes? Design and Development of Products and Processes 11
M Informational US FDA Final Guidance – Consideration of Uncertainty in Making Benefit-Risk Determinations in Medical Device Premarket Approvals, De Novo Classificati Medical Device and FDA Regulations and Standards News 0
K Verifying gas tight glass syringe used for making standards General Measurement Device and Calibration Topics 4
M Informational US FDA – Patient-Reported Outcomes (PROs) in Medical Device Decision Making Medical Device and FDA Regulations and Standards News 0
M Informational US FDA – Patient Preference Information (PPI) in Medical Device Decision-Making Medical Device and FDA Regulations and Standards News 0
U Electronic templates for making paper control charts Reliability Analysis - Predictions, Testing and Standards 2
K Turtle diagram or process interaction chart - Making it easier for an auditor Process Maps, Process Mapping and Turtle Diagrams 23
E CSR SHIPPING - Need suggestions for making SOP/WI for our shipping dept (automotive)... Customer and Company Specific Requirements 11
O Reinstating a disqualified supplier—questions to ask before making a decision Supplier Quality Assurance and other Supplier Issues 2
D Controlled Documents & Note Making ISO 13485:2016 - Medical Device Quality Management Systems 4
I Making a process PFMEA, no DFMEA (non-automotive toll manufacturer) FMEA and Control Plans 1
M IATF 16949 Cl. 8.7.1.4 - Risk analysis for decision making about rework IATF 16949 - Automotive Quality Systems Standard 2
D Help needed for Compliance Road-Map - Startup making their first device (IVD) IEC 62304 - Medical Device Software Life Cycle Processes 1
C IATF 16949 Cl. 8.4.1.2 d) Multidisciplinary Decision Making IATF 16949 - Automotive Quality Systems Standard 2
G Is it compulsory to make DFMEA for proto parts making organisation APQP and PPAP 1
L Making a Medical Devices Registration Database - Help and Suggestions Wanted Other Medical Device and Orthopedic Related Topics 2
B Making a Safety Culture Chart Occupational Health & Safety Management Standards 3
Marc ISO 9001:2015 vs. 2008 - Internal Audits - What changes are you making? Internal Auditing 44
4 Customer Making Changes to a 510k Device They Purchased 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
M Making a change to an approved Medical Device Other US Medical Device Regulations 9
M Making Amendments to a Quality Manual Quality Management System (QMS) Manuals 2
V Making a choice of Simple vs Comprehensiveness of Procedure/System of any Process Document Control Systems, Procedures, Forms and Templates 4
K Making a Quality Requirements Handbook for Employees Training - Internal, External, Online and Distance Learning 10
D ROHS 2 - Medical Device: Placing vs Making Available on the market EU Medical Device Regulations 3
J Keyboard issue in Word - Making me nuts Coffee Break and Water Cooler Discussions 5
W Chinese Distributor Making Counterfeit Products - Class I sterile products China Medical Device Regulations 2
P Making Quality and Compliance Invisible Imported Legacy Blogs 0
AnaMariaVR2 Structured Approach to Benefit-Risk Assessment in Drug Regulatory Decision-Making Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 0
Proud Liberal Making a simple Sampling Plan by Variables Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
N Decision Making... (joke) Funny Stuff - Jokes and Humour 1
G The right approach for making the transition from ISO9001 to AS9100 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 9
M AS 9100 4.2.4 Process for making changes to records is not fully effective Quality Manager and Management Related Issues 4
V Making Solar cells, Module, String - Which Cleanroom Level? Various Other Specifications, Standards, and related Requirements 2
P Outsourced Manufacturing - Making Subcontractors comply with TL9000 TL 9000 Telecommunications Standard and QuEST 2
G Free ASTM Standards? Recent Court Ruling making their standards free? Various Other Specifications, Standards, and related Requirements 10
U ISO 13485 mandatory for a factory making Medical Devices for EU? EU Medical Device Regulations 6
B Categorization of Customer Complaint: Making Customers feel they are Top Priority Customer Complaints 4
E Starting Nadcap Accreditation and making an Implementation Timeline AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
C Making a Box Plot in Excel Excel .xls Spreadsheet Templates and Tools 3
V Ideas, Measures/Metrics for making Quality Proactive? US Food and Drug Administration (FDA) 2
D 3D Printers - Making Replicas Coffee Break and Water Cooler Discussions 11
E Third party auditor's statement about SPC - Steel Making - EAF Statistical Analysis Tools, Techniques and SPC 11
K Seeking help in making a decision - Project behind schedule Quality Manager and Management Related Issues 11
Q Making a Dashboard for the KPI of our department Misc. Quality Assurance and Business Systems Related Topics 2
F Making a REACH statement - Plastic Injection Moulding RoHS, REACH, ELV, IMDS and Restricted Substances 9
W What are the Rules for making Organograms? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
AnaMariaVR2 Office Prank - Making an Office Disappear Funny Stuff - Jokes and Humour 0

Similar threads

Top Bottom