How to Make a Kano Analysis Chart in Excel (Product satisfaction over its lifetime)

Рет қаралды 29,090

Күн бұрын

⭐️⭐️⭐️ GET THIS TEMPLATE PLUS 52 MORE here: www.etsy.com/listing/11998005...
👍 Ready made and ready to use.
How to make a Kano Analysis chart in Excel, with your products or features and their customer satisfaction levels, against customer expectations over the product lifecycle.
Truly one of the best ways to rate your features and prioritise new products!
Timestamps:
00:00 Intro to Kano Analysis
02:43 Excel heading and colours
02:57 Kano analysis data table
05:02 Making the Lifecycle drop-down
06:07 Making the Kano Chart
08:40 Adding the data labels
09:37 Horizontal and Vertical lines
11:22 Curved Kano lines
13:03 Kano area labels
#ProjectManagement #SixSigma
See all the Project Template Excel and Powerpoint videos: • How to Create Excel an...

Пікірлер: 27

@camilahu1617 23 күн бұрын

Hello, you saved my life thank you !!!!!!❤

3 ай бұрын

That was fantastic! Thank you!

@guidscunha 2 жыл бұрын

This helped me a lot, thank you!

@pedrohenriquecarneiro904 Жыл бұрын

Amazing tips!

@VitorCybis 3 ай бұрын

Pretty nice! Thank you very much!

@phantrongkhoa7529 Жыл бұрын

Thanks David

@dianasusan_happylifehappyme Жыл бұрын

Hi David, could you tell me how to classify the answer of survey to A, O, Q,R ? Thanks

@johanvanderzee7513 2 ай бұрын

Great!

@mirxnda 8 ай бұрын

Hi david! Thanks for sharing kano analysis chart video. But how to determine the midpoint coordinates of a diagram? As in the diagram you made, you determine the number 5 to be the middle point

@emmanuelbasam1381 Жыл бұрын

Awesome @David! Is it possible to make some tutorials on CPI, SPI and other Project Management key Metrics? Thanks

@darshanapatel1260 Жыл бұрын

I cannot find the template on the website

@omer_mukhamedov_consulting Жыл бұрын

You are supermen for me

@ulama7828 2 жыл бұрын

Hey David, thanks for the PMP exam video. I have my exam soon, should I expect any math/calculation?

@davidmclachlanproject 2 жыл бұрын

There will usually be a little math (for value, schedule or cost) but nothing that needs more than a basic calculator (which is allowed or provided in the exam program).

@ulama7828 2 жыл бұрын

@@davidmclachlanproject Would love for you to tackle some examples of those!

@dolosofamili8838 Жыл бұрын

Hi, are there other metrics we can use aside from place in the lifecycle?

@kallanaBr Жыл бұрын

Great question! Waiting for his response!!!

@mohaiminulnabin2344 2 жыл бұрын

can you tell me how can i calculate satisfaction level and place in lifecycle?

@davidmclachlanproject 2 жыл бұрын

Great question! Customer satisfaction can be gathered directly from your customers in a survey or questionnaire - rating what their satisfaction level would be if a feature was there, from 1 to 10. Place in lifecycle depends on how fast features in your industry move from "new" to "old" usually (housing may be different to technology, for example). Find a previous feature and use that as a starting idea.

@mohaiminulnabin2344 2 жыл бұрын

@@davidmclachlanproject Thank you a lot for your information. it will help me greatly.

@alienspace3960 2 жыл бұрын

do you have a video how to make a gantt chart?

@davidmclachlanproject 2 жыл бұрын

I have a really awesome template for a Gantt chart, and will be filming it soon 🙂 Edit, here it is! kzfaq.info/get/bejne/qtuBo6qrscWVZJs.html

@dolosofamili8838 Жыл бұрын

Is it possible to do Kano for a one survey question? It has a comment section where I want to categorise that for the feature column. The question is resolution satisfaction and rated 1-4 for as the highest?

@davidmclachlanproject Жыл бұрын

Great question. The power of Kano is seeing that our features lose their level of customer satisfaction over time. So you could definitely translate what you want there (customer satisfaction), it would just be missing the "reduction over time" part (unless you keep that too) 🙂

@user-xf3vo6zn1f 10 ай бұрын

hello@@davidmclachlanproject, can we still create a kano model just by using 3 questions in the raw data? Resolution (scored Yes/No), Effort (scored 1-5) and Overall Satisfaction (scored 1-5).