Business Intelligence Dashboard for Academic Program Management
Guardado en:
| Publicado en: | Association for Engineering Education - Engineering Library Division Papers (Jun 14, 2015), p. 26.312.1 |
|---|---|
| Autor principal: | |
| Otros Autores: | , , |
| Publicado: |
American Society for Engineering Education-ASEE
|
| Materias: | |
| Acceso en línea: | Citation/Abstract Full text outside of ProQuest |
| Etiquetas: |
Sin Etiquetas, Sea el primero en etiquetar este registro!
|
| Resumen: | 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. |
|---|---|
| DOI: | 10.18260/p.23651 |
| Fuente: | Library Science Database |