Asee peer logo

Business Intelligence Dashboard for Academic Program Management

Download Paper |

Conference

2015 ASEE Annual Conference & Exposition

Location

Seattle, Washington

Publication Date

June 14, 2015

Start Date

June 14, 2015

End Date

June 17, 2015

ISBN

978-0-692-50180-1

ISSN

2153-5965

Conference Session

Topics in Computing and Information Technologies I

Tagged Division

Computing & Information Technology

Page Count

19

Page Numbers

26.312.1 - 26.312.19

DOI

10.18260/p.23651

Permanent URL

https://peer.asee.org/23651

Download Count

429

Request a correction

Paper Authors

biography

Mudasser Fraz Wyne National University

visit author page

I have a Ph.D. in Computer Science, M.Sc. in Engineering, and B.Sc. in Electrical Engineering. Currently I serve as a Chair for Department of Computer Science, Information and Media Systems and Professor of Computer Science at School of Engineering and Computing, National University. I am also the Program Lead for MS in Information Technology Management and have also served recently as the lead for BSc in Information Systems, the co-Lead for MSc Computer Science and Program Lead for MSc in Database Administration programs. My association with ABET (Accreditation Board of Engineering and Technology) US dates back to 2001, as a certified program evaluator for BSc in Computer Science and BSc in Information Systems. At present, I am also serving as the Commissioner for the Computer Accreditation Commission (CAC). Previously, I have taught at 6 different countries for over 25 years. I have been privileged to be part of the DESY Group (Deutches Elecktronen Synchrotron), Hamburg Germany, as a research fellow, and worked with an MIT group, led by a Nobel laureate.

On the research side, I have been fortunate enough to secure a number of grants and have served on numerous international Ph.D. Thesis committees, been a member of the editorial boards for 7 international journals, and served as the Chair and Co-Chair for 12 international conferences. For recognition of my research activities, I have been invited to a number of international conferences as Invited Speaker, chaired panel discussions and numerous international conference sessions. I have served on more than 150 international conference program committees. Furthermore, I have published number of articles in peer-reviewed international journals and conferences. I am also an active member of ACM, ASEE, ASEE/PSW and CSAB.

visit author page

biography

Jodi Reeves National University

visit author page

Dr. Jodi Reeves is an Associate Professor in the Department of Applied Engineering at National University in San Diego, CA. She teaches courses in design engineering, engineering management, and data analytics. Prior to academia, she worked for almost ten years as a quality control manager, engineering project manager, and senior scientist responsible for failure analysis of thin film materials. She invented new quality control tools and supervised interns from local universities and community colleges as part of a $5.0 million technical workforce development initiative funded by New York State. She has published diverse articles on topics ranging from engineering education to high temperature superconductors and has spoken at many national and international conferences. Her doctorate in materials science and engineering are from the University of Wisconsin, Madison, and she holds five patents.

visit author page

author page

Frank Xavier Montes

author page

Tom J Gurbach

Download Paper |

Abstract

Business Intelligence Dashboard for Academic Program ManagementAbstractIn higher education institutions, people managing academic program may require dataand an efficient analysis of the data in order to make well informed decisions regardingprogram and courses offerings, as well as, class staffing, etc.. Traditionally, it would taketoo much time and/or resources on manually gathering necessary data from varioussources for analysis. Implementing a business intelligence data dashboard could improveefficiency in data retrieval and can optimize data analysis for faculty programmanagement and decision making. The purpose of this paper is to present the research,design, and implementation of a business intelligence data dashboard prototype to meetsome of the main requirements for academic program management. The dashboardimplementation utilized database structure designed in Oracle and managed with SQLqueries to populate the data as well as retrieve data for the dashboard built with Tableau.The prototype data dashboard was successfully designed and implemented, usingdifferent types of graphs and tables, even though there were some moderate limitationson overall design due to data complexities. The dashboard shows cohort scheduling andstaffing using BS in Information System program data for over 7 years for over 60program cohorts. Specifically, the dashboard contains nine different tabs, that can befiltered using the drill down options on the Classes By Term, Section Details, InstructorsBy Program, and Instructor details by course. It also combines data that is used for coursescheduling and course evaluations, thus providing more information to the programdirector than any single query or report. By using ETL procedures, university data wasorganized and stored in a data mart using Oracle software that linked directly to Tableaufor dashboard design. With the creation of a data link between the database and theTableau dashboard, we enabled automatic data queries to be programmed for dashboardvisualizations. While most data visualizations used were standard, such as line charts andbar graphs. Users are able to navigate and interact within the Tableau dashboard by usingtheir mouse cursor on specific data metrics. By default, all data measures for requireditems are shown when the dashboard is initially opened. Utilizing different filtered viewsby adjusting date ranges or selecting by criteria allows for better views of the data in thedashboards. Other data visualizations are displayed as Pop-up tool tip windows whenusing the mouse cursor throughout certain parts of the graphs or charts which showadditional data metrics. Future work could focus on streamlining the data preparation andautomating the dashboard visualizations for even better efficiency in academic programmanagement.

Wyne, M. F., & Reeves, J., & Montes, F. X., & Gurbach, T. J. (2015, June), Business Intelligence Dashboard for Academic Program Management Paper presented at 2015 ASEE Annual Conference & Exposition, Seattle, Washington. 10.18260/p.23651

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2015 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015