How to Make Root Cause Analysis in Excel (Cell-based Fishbone or Ishikawa)

preview_player
Показать описание


This video shows you how to create a cell-based Root Cause Analysis template in Excel so you can brainstorm the cause of issues (or opportunities) with your team. Also called a Fishbone diagram or an Ishikawa diagram, after Kaoru Ishikawa at the University of Tokyo.

Typically causes are put into four buckets as "PIPS" - People, Information, Process, or System causes. You can also use "MMMM" which is similar - Man (or Woman), Materials, Method, or Machine.

Timestamps:
00:00 Intro to Root cause Analysis
01:10 Blank Canvas - Heading Area
02:17 Rood cause buckets
04:48 The head of the fish
06:32 Counting the Causes
08:08 Adding Fish Bones
08:50 Automatic Numbering
10:55 Finish and Congratulations

#ProjectManagement #PMBOK #Ishikawa #Fishbone #RootCause
  1. David McLachlan
Рекомендации по теме
How to Prepare 0:01:38

How to Prepare for a Successful Root Cause Analyses + Action Review

Introduction to root 0:08:02

Introduction to root cause analysis

What is 5 0:02:02

What is 5 Why - A Root Cause Analysis Technique

How to Conduct 0:01:38

How to Conduct a Root Cause Analysis

How to Make 0:11:20

How to Make Root Cause Analysis in Excel (Cell-based Fishbone or Ishikawa)

5 Root Cause 0:03:02

5 Root Cause Analysis Tools | RCA Tools

5 Steps to 0:03:13

5 Steps to Successfully Conduct Root Cause Analysis #rootcauseanalysis

Root Cause Analysis 0:38:08

Root Cause Analysis

Root Cause Analyses 0:03:23

Root Cause Analyses and Actions

What is Root 0:08:32

What is Root Cause Analysis (RCA)?

Fishbone Diagram Tool 0:03:59

Fishbone Diagram Tool for Root Cause Analysis | Ishikawa Diagram | Cause-and-effect Diagrams

BEFORE You Do 0:04:55

BEFORE You Do A 5 WHYs Root Cause Analysis Watch This…

The ROOT CAUSE 1:19:01

The ROOT CAUSE Of Trauma & Why You FEEL LOST In Life | Dr. Gabor Maté & Jay Shetty

Root Cause Analysis 0:14:03

Root Cause Analysis WITH (ACTUAL Example)

How to Make 0:12:56

How to Make a Fishbone Diagram (Ishikawa Diagram) - Root Cause Analysis

Treat High Blood 0:07:03

Treat High Blood Pressure's Root Cause by having a Complete Cardiac Examination

How to do 0:21:39

How to do Root Cause Analysis

Root Cause and 0:21:19

Root Cause and CAPA Process Explained!!!

The ROOT CAUSE 0:14:10

The ROOT CAUSE Of High Blood Pressure & How To TREAT IT NATURALLY | Dr. Mark Hyman

Root Cause Of 0:58:57

Root Cause Of Erectile Dysfunction & Best Ways To Help Reverse It Naturally | Dr. Mark Hyman

Pareto Chart for 0:05:54

Pareto Chart for Root Cause Analysis

The ROOT CAUSE 0:10:44

The ROOT CAUSE of Acid Reflux & How To STOP IT! | Dr. Mark Hyman

Make Your Root 0:11:18

Make Your Root Cause Analysis Thorough & Credible

The Critical Thinking 0:54:50

The Critical Thinking Process and Tools that Support Root Cause Analysis

Комментарии
Автор

A certified project management professional now, Thank you David for your remarkable study material.

hussnainshah
Автор

Very good, really enjoyed it. I would love to see this with the opposite filled out. However, thank you, very helpful and timely.

peterfalk
Автор

The way this guy manipulates Excel. Never seen anything like it.

NJawte
Автор

Mr david
Can you help me with this question plz

which of the following is a broad collection of integrated policies, standards, and procedures used to guide the planning and execution of a project?
A. Project portfolio.
B. Project development
C. Project governance.
D. Project management methodologies

onefitness
Автор

it's very useful and easy to understand

hassanelfakey