Introduction

This is the first blog of a two-blog series, this blog will serve as an introduction to creating a resistance assessment questionnaire.

Managing resistance is one of the many factors to consider when implementing an organizational change.  If ignored, it can potentially threaten the success of the project.  To proactively minimize resistance and improve adoption, it is important to understand “what” is causing the resistance.

To proactively minimize resistance and improve adoption, it is important to understand “what” is causing the resistance.

What is a Resistance Assessment Questionnaire?

One way to achieve this objective is to solicit feedback through a resistance assessment questionnaire.  To ensure the resistance is measured throughout the organization, it is essential to select individuals from several demographics – including organizational role, location, and department.  The responses from the questionnaire will expose areas of improvement and allow the organization to address any of the gaps.

Creating the Questionnaire

In my second blog, I will walk through the process of creating a simple questionnaire using Microsoft Forms.  Next, I will proceed with pushing the submitted responses from Microsoft Forms into an Excel table using Power Automate.  Finally, I will summarize the responses into logical data points in additional Excel tables which will then be pulled together into pie, line/stacked, and line/clustered column charts using Power BI.

Conclusion

In summary, mitigating resistance is key to a successful project.  Understanding what is causing the resistance early on will help improve the support of the change, increase user awareness and adoption, and prevent resistance from happening later in the project.  Collecting feedback through a resistance assessment questionnaire will not only help to identify areas of greatest resistance but will also help to identify early adopters or champions (those with the least resistance) for your organization’s change.