Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Learn more at https://powerbi.microsoft.com.
- 2.
I prefer to go to Photoshop to find the color I want, grab that color in hexadecimal format (such as 073f05 for Very Satisfied), and then paste that into Power BI.
- 3.
Power BI interprets the data type as String. You need to change it to Date/Time in order for the slicer to display as slider as shown in Figure 56.
- 4.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Jeffrey M. Rhodes
About this chapter
Cite this chapter
Rhodes, J.M. (2019). Creating a Survey Response Dashboard with Microsoft Power BI. In: Creating Business Applications with Office 365. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5331-1_10
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5331-1_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5330-4
Online ISBN: 978-1-4842-5331-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)