June 14, 2015
June 14, 2015
June 17, 2015
Computing & Information Technology
26.312.1 - 26.312.19
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