
Let's start with a short introduction
A little bit about me and my experience
Here I will show you briefly how the course is organized
Here I will show you what to do if a blurry image appears.
Here I will show you how to find additional resources attached to the course like Excel files, presentations, links, etc.
Let’s start with the essential things around Six Sigma. We will discuss what Six Sigma is and we will briefly discuss the most often-used framework – DMAIC.
Let’s start with a short definition
Six Sigma is a data-driven method used to improve the process.
Using this method you reduce the so-called defects, and you increase the consistency of results. This in turn will lead to improvement in quality.
Six Sigma helps identify what is slowing down the process, how to eliminate possible delays, how to improve the process, and remove additional problems that occur
As we have mentioned, the main goal of Six Sigma is to eliminate defects and improve the quality of the process. Let's start with the definition of a defect:
Any unacceptable deviation from the norm that the company sets for a specific process, or outcome
A defect can be a process output, a product, or a service that does not meet the customer’s requirements and expectations for quality
Let’s start with a short definition of DMAIC
One of the most used Six Sigma methodologies
DMAIC concentrates on making improvements to a business process in order to reduce or eliminate defects
It is used to improve the efficiency and effectiveness of a product or process that already exists but is no longer meeting customer needs/specifications
In this section, we will discuss what you will have to do during the Define stage. We will discuss tools and frameworks used during this stage. You will learn things like SIPOC, the voice of the customer, CTQ, Fishbone Diagram, Issue tree, and 5 Why.
Let’s start with a short definition of a Problem
A problem is a statement about a condition to be improved or a difficulty to be eliminated
Any kind of deviation from the expected result
Something that is not according to the norm
An obstacle that may stop you from achieving the goal
Let’s start with a short definition
By Voice of customers, we mean all sorts of comments, and feedback we get from our customers
VOC tells you what really matters to your customer and what you should concentrate on
The Voice of Customer shows you the expectations, and preferences, of your customers, comments about the product or service
The main benefit of using Voice of Customers is knowing, in measurable terms, what customers want
The purpose of Voice of Customer is to identify the critical requirements that are the measure of the success of the product or service delivered to the customer
Let's see the difference between needs and recquirements
§Critical to Quality (CTQ) Approach is a tool that can be used to translate customer’s needs into specific measurable performance requirements
§CTQ are metrics that must be met in order to satisfy the customer’s needs
§We can also say that they are key measurable characteristics of a product or service that link a company’s actions to the things that are most important to the customers
Let’s start with a short definition of a SIPOC
SIPOC is a tool, that is used to identify all relevant elements of a process that we want to improve before work begins
It summarizes the inputs and outputs of one or more processes in table form
We will see how to gues the root cause.
Fishbone Diagram, also known as Ishikawa Diagram or Cause-and-Effect Diagram
The graphical method used to identify the root cause of defects that are causing problems in the process
The name of this tool comes from its similarity to the bones of a fish.
The bones, an area of potential causes, are connected to a spine leading into the fish’s head, which symbolizes a defect or a problem
Let's apply this method to restaurants
Depending on your needs, you can adapt the categories in the Fishbone Diagram according to your needs. Let’s see what it would look like for a problem in a restaurant.
In production, you will know far less than your customer’s team so you have to use smart ways to get to the bottom of things. The 5-Why method is one such method. In this lecture, I will show you how to use it in practice
Issue tree is a simple yet powerful concept used in consulting for structuring discussion and picking the right topics to concentrate on. In this lecture, I will show you the principles of using it as well as a practical example
In the next lectures, we will have a look at examples of issue trees
Here I will show an example of an issue tree in Logistics
Here I will show an example of an issue tree in Retail.
Here I will show an example of an issue tree in FMCG.
In this section, we will discuss what you will have to do during the Measure stage. We will discuss tools and frameworks used during this stage.
Now let’s think about what we would like to measure when it comes to the customer experience in a restaurant.
Let's have a look at different types of data that you will use.
Let’s think for a minute where we can get data from when it comes to the restaurant.
In some cases, you will have to define a formal data collection plan. In this plan, you must describe in more detail what data you need.
Let’s create a data collection plan for the restaurant in which we want to shorten the service time.
The analysis phase turns raw data into conclusions. It is important to choose the right analytical techniques. Based on analyses we will be able to improve processes. In this section, we will see how this can be done in practice. You will learn things like correlation, regression analysis, comparison of averages, random variables, and normal distribution.
Let's see what we want to measure in the Measure stage
Let's look at the definition of correlation
It is a measure that helps check how 2 variables are related and whether they behave in the same way.
Correlation also tests the strength of the movement. The higher the absolute value of the correlation, the stronger the similarity in behavior
We can check whether things behave in the same way, but we cannot check whether they influence each other and what the direction of the influence is
We use the so-called Pearson correlation coefficient to measure the correlation
Now, let’s try to analyze the results from the correlation analysis for the service time for the restaurant chain.
In this lecture, we will solve the case study that we have introduced.
In this lecture, we will solve the case study that we have introduced.
In many cases, the outcome of certain phenomena is unknown. In such situations, we need Random Variables.
Random variables at the end will produce a specific outcome but we don’t know exactly what it will be.
Random Variable is what you will find behind closed doors. Once you open the door you will know for sure but before that, there are only some potential results, nothing certain.
In order to be able to recreate the game in Excel, we will have to reframe it. I will show you how to do it and how later on to use it for modeling in Excel.
In order to be able to recreate the game in Excel, we will have to reframe it. I will show you how to do it and how later on to use it for modeling in Excel.
The normal distribution is a special type of density curve that is bell-shaped. Sometimes it is also called the bell curve or normal curve. Let's see what is the logic behind
Standard deviation definition:
It is a measure of how spread out the numbers are
Standard deviation tells us how close to the mean are the values in our data set
The bigger the standard deviation the further away the values are from the mean
A regression model is a powerful tool you can use to analyze data, predict things, and find relations between different phenomena. I will show you how to use it in Excel.
A regression model is a powerful tool you can use to analyze data, predict things, and find relations between different phenomena. I will show you how to use it in Excel.
Let's do a regression analysis for a restaurant. Here I will discuss the data
In this lecture, we will solve the previously introduced case study
One of the methods of data analysis is to compare the average results obtained from the measurements. Let’s have a look at how we can check if there is a link between service time and selected variables by looking at average results by certain groups.
Let's look at a case study. We will look at the data that you will need to calculate and compare averages
In this lecture, we will solve the previously introduced case study
In certain situations, the links between the variables can be noticed by looking at the chart. This may be used as a method of finding the source of problems.
Testing can be also used as a way of analyzing what actually influences the KPI we try to improve. Let’s see how testing can be used to test the link between 2 variables.
Imagine that we would like to test if the Level of experience of employees has an impact on Service Time. Let’s have a look at how we can do it in the example of the restaurant.
One of the most interesting stages is the improvement stage. You know what the problem is, so now you have to come up with potential solutions and test them. In this section, we will discuss what you can do to improve the situation based on previous analysis.
Let’s start with a short definition. Funnel analysis is:
It is a tool that can be used to map and analyze a series of events that lead to a particular goal
The goal may be Sales, Gross Margin, number of customers acquired, number of projects done
Funnel analysis can help you manage the process of achieving the goal and find ways to improve the situation
Funnel Analyses in Testing:
A tool that can be used to map, manage and analyze various ideas aimed at improving or completely changing a given area of the business
Funnel Testing helps you find fast potential improvements as well as minimize the risk of causing problems
To use the full potential of the Funnel Analysis in Testing we should divide more complicated concepts/ideas into a series of smaller tests
In Funnel Testing you will impose limits on most stages to manage the process smoothly
The Funnels in Testing usually consist of 5 main stages
Define your goal
Generate potential ideas for improvements
Create a ranking of the ideas
Test and analyze the results
Implement the changes
Every funnel is a hungry beast. Let’s have a look at how you can generate ideas for your testing funnel.
Imagine that you are working for a Fashion Retailer. You have gathered a list of potential ideas to be tested. Before you move to test, rank them.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
After testing the ideas you will get results that you have to try to interpret. Let’s analyze one of the ideas that we have selected for testing.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
Once you have improved certain KPIs. It’s a good idea to make sure that the progress you have made is not wasted. Therefore, you need to implement some control mechanisms. In this section, we will see how this can be achieved.
Zero defect rules are not about making zero mistakes. It is about finding mistakes as soon as possible and eliminating them. In this lecture, I will show what it is and how to use it in practice.
There are many examples of Poka Yoke in an office environment. Let’s look at some of them.
In the last section, we will try to apply the techniques we have discussed to improve the situation in a clinic.
Let's look at the data that you will need to solve the case study
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
What is the aim of this course?
Consulting firms are hired very often to help optimize processes and improve the quality of the products delivered. One of the frameworks used is the so-called Six Sigma, which tries to find the root cause of problems using simple statistical analysis. In this course, I will show you the essential things that you should know about Six Sigma that may come in handy during consulting projects.
In the course, you will learn the following things:
What is Six Sigma
How to define the problem you want to solve
How to identify the things causing the problem
How to conduct in Excel analysis of data related to Six Sigma projects
How to find and manage potential improvements
This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from the Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who are now Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that, my courses on Udemy were already taken by more than 350 000 students, including people working in EY, McKinsey, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.
I teach through case studies, so you will have a lot of lectures showing examples of analyses and tools that we use. To every lecture, you will find attached the Excel files as well as additional presentations and materials shown in the lectures. Therefore, as a part of this course, you will also get a library of ready-made analyses that can, with certain modifications, be applied by you or your team in your work.
Why have I decided to create this course?
Tools and approaches used in Six Sigma can be extremely useful during certain consulting projects. Most books and courses will flood you with tons of methods that you can use. This may lead to huge frustration during consulting projects as you will have problems with choosing the right method or tool. Therefore, I have decided to create this course that will help students understand or refresh the essential concepts and tools that they need during consulting projects, devoted to using Six Sigma to improve processes. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects. You will master how to analyze data and draw conclusions from the analyses.
To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst, you have to have a good understanding of the essential Six Sigma tools. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those who did not finish Math or Physics. The course will help you become an expert in process improvement at the level of McKinsey, BCG, Bain, and other top consulting firms.
In what way will you benefit from this course?
The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you understand and analyze businesses. There is little theory – mainly examples, a lot of tips from my own experience, as well as other notable examples worth mentioning. Our intention is that, thanks to the course, you will learn:
What is Six Sigma
How to define the problem you want to solve
How to identify the things causing the problem
How to conduct in Excel analysis of data related to Six Sigma projects
How to find and manage potential improvements
You can also ask me any questions either through the discussion field or by messaging me directly.
How is the course organized?
The course is currently divided into the following sections:
Introduction. We begin with a little introduction to the course, as well as some general info on how the course is organized
Essential Concepts in Six Sigma. Let’s start with the essential things around Six Sigma. We will discuss what Six Sigma is, and we will briefly discuss the most often-used framework – DMAIC.
Define Stage. In this section, we will discuss what you will have to do during the Define stage. We will discuss tools and frameworks used during this stage. You will learn things like SIPOC, the voice of the customer, CTQ, Fishbone Diagram, Issue Tree, and 5 Whys.
Measure Stage. In this section, we will discuss what you will have to do during the Measure stage. We will discuss tools and frameworks used during this stage.
Analyze Stage. The analysis phase turns raw data into conclusions. It is important to choose the right analytical techniques. Based on the analyses, we will be able to improve processes. In this section, we will see how this can be done in practice. You will learn things like correlation, regression analysis, comparison of averages, random variables, and normal distribution.
Improve Stage. One of the most interesting stages is the improvement stage. You know what the problem is, so now you have to come up with potential solutions and test them. In this section, we will discuss what you can do to improve the situation based on previous analysis.
Control Stage. Once you have improved certain KPIs. It’s a good idea to make sure that the progress you have made is not wasted. Therefore, you need to implement some control mechanisms. In this section, we will see how this can be achieved.
Case Study in Six Sigma. In the last section, we will try to apply the techniques we have discussed to improve the situation in a clinic.
You will also be able to download many additional resources
1. Useful frameworks and techniques
2. Analyses shown in the course
3. Additional resources
4. Links to additional presentations, articles, and movies
5. Links to books worth reading
At the end of my course, students will be able to…
How to conduct fast and efficiently analyses during Six Sigma projects
What is Six Sigma
How to define the problem you want to solve
What are SIPOC, CTQ, and the voice of customers
How to use a Fishbone Diagram
How to identify the things causing the problem
How to conduct an analysis of data in Excel
Essential Linear Regression in Excel
How to find and manage potential improvements
What is a Random Variable and a Normal Distribution
Who should take this course? Who should not?
Management Consultants and Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders
Project Managers
Managers responsible for Acquisitions and Mergers
What will students need to know or do before starting this course?
Basic or intermediate Excel
Basic knowledge of economics
Basic or intermediate knowledge of finance & accounting