Power Bi Dashboard - clean and replace data source

We produce Engagement surveys using Power Bi for the final analysis. Our data analyst is currently overloaded and we need someone to fill in for this project.

We have a fully functioning Power BI dashboard of six pages (see screenshots attached) which connects to an Excel workbook stored in the same directory as the Power BI file.

I will provide the Power BI file, the original Excel worksheet and the new Excel worksheet.

I want the new Power BI file and new Worksheet to be connected in the same directory.

We need to replace the current Excel workbook with the new workbook and make sure it works. The structure of the raw survey data is identical. There are only 120 rows in the data. This is not a big data project.

The only difference is very minor in the number of statements and the number of demographic scale items. The number of demographics is identical and the layout of the dashboard should be identical (you are welcome to improve some of the slicing visuals but this is not important).

It is very straightforward with standard dashboard features with two exceptions:
The Cluster analysis - Make sure you are comfortable with this aspect of the analysis
The Text analysis - This is not actually very difficult but it does take time. There are almost 200 text statements split into three categories. I would allow at least three hours to work your way through this manually (we usually allocate 50% of the time for this element)

We would normally allow 5 hours for this but I am allowing up to 10 hours since there will be some learning for you on this project

You must:

1) Convert/clean the new data source to ensure that it works with the dashboard
2) Check that all the logic works as it should including the qualitative (text) analysis. This can be done manually or via an AI device, but must be sense checked by a human being at some point

We can discuss how you might wish to improve the design, once the project is complete (it would become another project)

I am looking for someone who has:
Excellent written and spoken English
At least 3 to 5 years in data analysis and Power BI / Excel expertise
It would be nice if you had experience with B2B surveys such as Engagement/Satisfaction/Diversity/Inclusion etc

Please start your reply with the word "Blackpool" so that I know you have read to the end. I do not waste my time replying to anyone who does not fulfil this.

Please DO NOT use AI to autofill your reply(or use it very judiciously) as I am getting very tired of overlong, hyper detailed replies that just waste my time and give me no idea as to how competent you are.

Many thanks
Chris