What are the pros and cons of using excel for data analysis

вЂњFastвЂќ Root Cause Analysis: Brainstorming, 5-Whys and Fishbone Diagrams For example, these three articles outline many of the drawbacks of Cause and Effect analysisвЂ¦ Cause and Effect has several drawbacks that we have documented in previous articles. Now, letвЂ™s look at the cons (drawbacks) of using Fishbone Diagrams for root cause analysis.ДЇirst, the technique is based on the root cause analysis technique of cause and effect. It certainly was one of the original techniques developed to help problem solvers understand the causes of a problem.ДЇinally, many claim that it is an effective root cause analysis tool. the Fishbone Diagram provides a relatively easy to understand diagram of the cause and effect relationship that the investigator wants to communicate.ДЄlso, Fishbone Diagrams have a long history of over 50 years of use. It is easy to see what the investigator sees as the main problem (the head of the fish), the major factors influencing performance (the main bones attached to the spine), and the potential causes (the minor bones). Like 5-Whys and Brainstorming (which can be used to develop the вЂњbonesвЂќ) the technique is simple to learn and apply. LetвЂ™s start with the fact that a Fishbone Diagram is fairly easy to use. Fishbone Diagram вЂњProsвЂќДЇirst, letвЂ™s review the pros of using Fishbone Diagrams for root cause analysis. Now that you understand what a Fishbone Diagram looks like and how you might draw one, letвЂ™s review the pros and cons of the technique when it is used for root cause analysis. The diagram above comes from this article ( LINK) that also includes the video below that outlines using a Fishbone Diagram.ДЄnother articleВ used the example below to describe a Fishbone DiagramвЂ¦ The team then reviews their potential causes and identifies the вЂњmost likelyвЂќ root cause (or,В in some cases, root causes). Then they brainstorm potential root causes of the problem for each major performance factor. The team brainstorms the major factors that influence performance (the main bones attached to the backbone). You can use many techniques to develop a cause and effect relationship,В but people often describe using a 5-Why type questioning process to create the cause and effect bone structure.ДЄnother method that people use to develop the bone-like structure is brainstorming. In the example below the major factors are:Д®ach of the major factors then has additional bones attached to that category that outline the cause and effect relationship that may be causing the problem. He published a description of the technique in the 1990 in the book, Introduction to Quality Control.ДЄ Fishbone Diagram (a sample of which is shown below) shows the problem at the head of the fish-like looking diagram and a backbone with major factors that can bring success or failure to the process as the major bones attached to the backbone. The root cause analysis technique called a Fishbone Diagram (or an Ishikawa Diagram) was created by university professor Kaoru Ishikawa in the 1960s as a quality control tool. How Fishbone Diagram Root Cause Analysis Works

Therefore, I thought I would outline the pros and cons of Fishbone Diagram root cause analysis. They explain how they use the technique but they usually leave out the disadvantages of using a Fishbone Diagram. Recently, IвЂ™ve seen several articles explaining Fishbone Diagram root cause analysis. Pros & Cons of Fishbone Diagram Root Cause Analysis

What are the pros and cons of using excel for data analysis