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

  Рет қаралды 7,629

David McLachlan

David McLachlan

Күн бұрын

⭐️⭐️⭐️ Get 35 Contact Hours / PDUs and 500 PMP Practice Questions in my Udemy course: www.udemy.com/course/ultimate...
✅✅✅ Or Get 52 ready-made Excel and PowerPoint project templates here: www.etsy.com/listing/11998005...
⭐⭐⭐ Or Get 21 PDUs in my complete Agile course: www.udemy.com/course/the-grea...
✅✅✅ Or Get my pre-made Project Management PLAN Templates: www.etsy.com/listing/16580064...
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

Пікірлер: 7
@hussnainshah999
@hussnainshah999 3 ай бұрын
A certified project management professional now, Thank you David for your remarkable study material.
@peterfalk7084
@peterfalk7084 4 ай бұрын
Very good, really enjoyed it. I would love to see this with the opposite filled out. However, thank you, very helpful and timely.
@hassanelfakey4708
@hassanelfakey4708 3 ай бұрын
it's very useful and easy to understand
@alloutabderrahmane5459
@alloutabderrahmane5459 4 ай бұрын
you are the best David
@NJawte
@NJawte 3 ай бұрын
The way this guy manipulates Excel. Never seen anything like it.
@one4fitness780
@one4fitness780 4 ай бұрын
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
@davidmclachlanproject
@davidmclachlanproject 4 ай бұрын
Hmmm. Project methodology: "A system of processes, governance, methods and templates that provide guidance on how to run the project." Project Governance: "The framework, functions and processes that guide project management activities in order to create a unique product, service or result." It's both!
How to Make a Risk Assessment Matrix in Excel
16:10
David McLachlan
Рет қаралды 482 М.
5 Why Tips and Tricks from practical experience
16:34
Tom Mentink
Рет қаралды 29 М.
ТАМАЕВ УНИЧТОЖИЛ CLS ВЕНГАЛБИ! Конфликт с Ахмедом?!
25:37
Red❤️+Green💚=
00:38
ISSEI / いっせい
Рет қаралды 74 МЛН
Looks realistic #tiktok
00:22
Анастасия Тарасова
Рет қаралды 103 МЛН
마시멜로우로 체감되는 요즘 물가
00:20
진영민yeongmin
Рет қаралды 30 МЛН
AGILE versus WATERFALL Project Plans
27:55
David McLachlan
Рет қаралды 18 М.
The 7 Quality Control (QC) Tools Explained with an Example!
16:04
CQE Academy
Рет қаралды 612 М.
Identifying Root Causes
10:04
Stanford Medicine Improvement Team
Рет қаралды 16 М.
The ONLY thing you need to pass the PMP?
9:41
David McLachlan
Рет қаралды 32 М.
BEFORE You Do A 5 WHYs Root Cause Analysis Watch This…
4:55
The Agile Business Analyst
Рет қаралды 36 М.
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
Kenji Explains
Рет қаралды 792 М.
How to Create an Excel Action Plan for Your Project [EASY + EFFECTIVE]
15:52
Make This Awesome Gantt Chart in Excel (for Project Management)
17:13
Kenji Explains
Рет қаралды 215 М.
How to Make a Business Case in Word
9:55
David McLachlan
Рет қаралды 21 М.
ТАМАЕВ УНИЧТОЖИЛ CLS ВЕНГАЛБИ! Конфликт с Ахмедом?!
25:37