Replicating Drivers Analysis in Excel

Hi,

We would like to show the drivers analysis of Qualtrics in POWER BI.

Since there is no feature of embedding the Qualtrics widget in POWER BI, we were trying to see if we can build similar logic in excel.

We tried using PEARSON’s formula of excel to do so.

However, we are stuck in one point.

We would like to know how does it calculate the average for the Performance axis.

If someone has already done it, kindly help.

Also, if you know any other solution to get it into POWER BI, please suggest.

Thanks.

Regards,

Neha Tank

Page 1 / 1

@Dukester , Given your expertise, have you worked on the above requirement anytime ? Any lead would be helpful.

Hi @Neha Tank

It depends on how you set up your key drivers widget.

@vgayraud , thanks for the response.

I had gone through this link.

I shall check what is set in our Qualtrics environment and then get back to you if I have any queries.

Thanks.

Sign up