Creating a Survey Response Dashboard with Microsoft Power BI
Power BI is a powerful tool for visualizing data. Of particular relevance for this book is its ability to use SharePoint lists as a data source. In this chapter, we will demonstrate how to use Power BI to display SharePoint survey data. This is particularly useful for a long-running survey such as for a help desk. As shown in Figure 50, SharePoint’s built-in graphical summary displays all results. If the survey has been in place for the past 5 years, seeing recent trends is impossible. In addition, there is no way to click the Very Dissatisfied responses, for example, and drill down into their comments or other information.