ISEDJ

Abstract: Dashboards allow managers to interact with data, asking “what if” questions and looking for patterns. This topic is typically mentioned in information systems courses; however, many students will not have experience with developing dashboards or using them to answer business questions. The purpose of this assignment is to provide students with hands-on experience creating a dashboard using Excel’s free Power View add-in. The exercise is based upon a real case. Students are provided anonymized registration data for participants at the Super Saturday Series (S3), an outreach event for middle and high school girls. The dashboard is designed for the S3 Directors to answer questions such as: - How much money was collected? - Which day and time of day was the most popular for registrations? (This will help them assess the effectiveness of their marketing campaigns) - How many participants attended each date? - Which school systems had the highest number of attendees? Lowest number of attendees? Step-by-step instructions demonstrate how to add different types of visualizations, including line charts, bar charts, and tables. Students will customize their dashboard by selecting a theme and inserting an image. After completing the dashboard, students will use it to answer business questions. This assignment is suitable for undergraduate students taking a computer literacy, introductory information systems, or data analytics course. Although some basic proficiency in Excel is required, students do not need any prior experience in Power View to complete this assignment.

Keywords: Computer literacy, Data analytics, Introduction to Information Systems

Download this article: ISEDJ - V16 N2 Page 4.pdf

Recommended Citation: Napier, N. (2018). Super Saturday Series (S3) Dashboard in Power View . Information Systems Education Journal, 16(2) pp 4-10. http://isedj.org/2018-16/ ISSN: 1545-679X. (A preliminary version appears in The Proceedings of EDSIGCON 2017)