商业智能和数据分析应用于UPEC大学的课程监控过程

IF 4.1 4区医学 Q1 Medicine

Minerva endocrinologica Pub Date : 2022-12-13 DOI:10.47460/minerva.v1ispecial.75

Jhony Vicente Enriquez Herrera, Juan Pablo Lopez Goyez, Wilson Andres Zabala Villarreal

{"title":"商业智能和数据分析应用于UPEC大学的课程监控过程","authors":"Jhony Vicente Enriquez Herrera, Juan Pablo Lopez Goyez, Wilson Andres Zabala Villarreal","doi":"10.47460/minerva.v1ispecial.75","DOIUrl":null,"url":null,"abstract":"The research highlights the importance of applying new trends, such as Business Intelligence & Data Analytics, within organizations and institutions to solve strategic and managerial decision-making problems. Based on this concept, a solution was developed for the curricular follow-up process in the Academic Direction of the Polytechnic State University of Carchi; in this sense, quantitative methodologies and Ralph Kimball's method were created for storage and analysis; and the ETL process was designed for the processing of the data obtained from the databases of the integrated computer system. Finally, control panels were developed through the Power BI tool to create dashboards. BI strategies were applied to deliver accurate information in real-time, easy to interpret, and oriented to satisfy the institutional requirements for the academic area.","PeriodicalId":18592,"journal":{"name":"Minerva endocrinologica","volume":"7 1","pages":""},"PeriodicalIF":4.1000,"publicationDate":"2022-12-13","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Business Intelligence & Data Analytics applied to the curricular monitoring process at the UPEC university\",\"authors\":\"Jhony Vicente Enriquez Herrera, Juan Pablo Lopez Goyez, Wilson Andres Zabala Villarreal\",\"doi\":\"10.47460/minerva.v1ispecial.75\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The research highlights the importance of applying new trends, such as Business Intelligence & Data Analytics, within organizations and institutions to solve strategic and managerial decision-making problems. Based on this concept, a solution was developed for the curricular follow-up process in the Academic Direction of the Polytechnic State University of Carchi; in this sense, quantitative methodologies and Ralph Kimball's method were created for storage and analysis; and the ETL process was designed for the processing of the data obtained from the databases of the integrated computer system. Finally, control panels were developed through the Power BI tool to create dashboards. BI strategies were applied to deliver accurate information in real-time, easy to interpret, and oriented to satisfy the institutional requirements for the academic area.\",\"PeriodicalId\":18592,\"journal\":{\"name\":\"Minerva endocrinologica\",\"volume\":\"7 1\",\"pages\":\"\"},\"PeriodicalIF\":4.1000,\"publicationDate\":\"2022-12-13\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Minerva endocrinologica\",\"FirstCategoryId\":\"3\",\"ListUrlMain\":\"https://doi.org/10.47460/minerva.v1ispecial.75\",\"RegionNum\":4,\"RegionCategory\":\"医学\",\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q1\",\"JCRName\":\"Medicine\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Minerva endocrinologica","FirstCategoryId":"3","ListUrlMain":"https://doi.org/10.47460/minerva.v1ispecial.75","RegionNum":4,"RegionCategory":"医学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q1","JCRName":"Medicine","Score":null,"Total":0}

引用次数: 0

摘要

该研究强调了在组织和机构中应用商业智能和数据分析等新趋势来解决战略和管理决策问题的重要性。基于这一概念，为卡尔奇国立理工大学学术方向的课程后续过程开发了解决方案;从这个意义上说，定量方法和拉尔夫·金博尔的方法被创造出来用于存储和分析;并设计了ETL流程，用于处理从集成计算机系统的数据库中获得的数据。最后，通过Power BI工具开发控制面板以创建仪表板。应用BI策略，实时提供准确的信息，易于解释，并以满足学术领域的机构需求为导向。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Business Intelligence & Data Analytics applied to the curricular monitoring process at the UPEC university

The research highlights the importance of applying new trends, such as Business Intelligence & Data Analytics, within organizations and institutions to solve strategic and managerial decision-making problems. Based on this concept, a solution was developed for the curricular follow-up process in the Academic Direction of the Polytechnic State University of Carchi; in this sense, quantitative methodologies and Ralph Kimball's method were created for storage and analysis; and the ETL process was designed for the processing of the data obtained from the databases of the integrated computer system. Finally, control panels were developed through the Power BI tool to create dashboards. BI strategies were applied to deliver accurate information in real-time, easy to interpret, and oriented to satisfy the institutional requirements for the academic area.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

Minerva endocrinologica ENDOCRINOLOGY & METABOLISM-

CiteScore

4.20

自引率

12.20%

发文量

审稿时长

>12 weeks

期刊介绍： Minerva Endocrinologica publishes scientific papers on endocrine system diseases. Manuscripts may be submitted in the form of editorials, original articles, review articles, special articles, letters to the Editor and guidelines. The journal aims to provide its readers with papers of the highest quality and impact through a process of careful peer review and editorial work.