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}
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 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.