Create 2 interactive excel dashboards

We would like to create two interactive Excel dashboards for our NHS customers that will be updated monthly.

In order to produce a visually appealing output of our survey data we currently format our survey data into Excel for upload into the third-party business intelligence software iDashboards. As iDashboards is a US company and the NHS require us to host their data on UK servers, we currently host a now outdated version (v8) of idashboards on our own servers. This version uses Adobe Flash Player to operate and as this will be unsupported at the end of 2020, we need to look for an alternative. We have explored the upgrade of idashboards and considered other BI software but have found that this is very expensive for the small number of users that we have and that most go beyond the functionality that we need. Therefore, we have decided to explore whether an Excel based dashboard might be able to provide what we need.

Please read the attached detailed spec carefully and let us know how you could meet the main requirements listed at the end of the document.