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

[@camilahu1617]

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

That was fantastic! Thank you!

[@pedrohenriquecarneiro904]

Amazing tips!

[@mirxnda]

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

[@phantrongkhoa7529]

Thanks David

[@VitorCybis]

Pretty nice! Thank you very much!

[@omer_mukhamedov_consulting]

You are supermen for me

[@emmanuelbasam1381]

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

[@johanvanderzee7513]

Great!

[@guidscunha]

This helped me a lot, thank you!

[@dianasusan_happylifehappyme]

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

[@dolosofamili8838]

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

[@kallanaBr]

Great question! Waiting for his response!!!

[@ulama7828]

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

[@davidmclachlanproject]

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]

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

[@alienspace3960]

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

[@davidmclachlanproject]

I have a really awesome template for a Gantt chart, and will be filming it soon 🙂 Edit, here it is! kzbin.info/www/bejne/qqa0oXqwgcRkask

[@mohaiminulnabin2344]

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

[@davidmclachlanproject]

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]

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

[@egiriv1828]

goat

[@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]

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).

[@darshanapatel1260]

I cannot find the template on the website

[@egiriv1828]

🙏🙏