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.
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)