Develop an Excel dashboard to display the results of a short survey comprising 13 questions (5-point response scale, agree to disagree) arranged in 3 groups and 8 demographic categories (3 - 12 options each). The dashboard needs to display results for the 3 main question groups as well as the 13 questions (stacked bar graph), a summary of the favourable scores for the 13 questions displayed in a circular graph (see attached image) and a breakdown of the number of respondents in each of the demographic categories.
The dashboard needs to be interactive, allowing the end-user to select the set of results to be displayed based upon one or more of the 8 demographic categories. The results need to display the user-selected data set along with a comparison to the overall mean scores. Ideally there should also be some automatic analysis/interpretation of the data e.g. highlighting significantly high or low scores / biggest difference from overall mean. There should be a button to quickly output the current display to print or Acrobat pdf file.
The system needs to prevent the display of results with fewer than 6 responses and the survey data needs to be hidden from the end-user (as a minimum requirement) and password protected to prevent access (ideally).
We would prefer if the dashboard functionality could be achieved without the need to use VBA or macros as it needs to be used on PC and mac platforms.
Following requests from some bidders I have attached a file outlining the survey structure and an example dataset.
The pdf file shows how we would like the main results displayed - as a horizontal bar graph showing Favourable, Neutral and Unfavourable scores. Response options 1 & 2 are favourable, 3 is Neutral and 4 & 5 Unfavourable. The graph in the magnifying glass shows the favourable scores only (rounded to the nearest 10).
21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi, I'm a professional with Masters in business and IT having hands on experience with MS Excel. I will be able to finish your job within five days with high quality. Thanks!
I am an IITK graduate with more than 5 years of experience in Business Intelligence and reporting, I have developed similar dashboards even without using VBA, which work only on excel formulas.