Dashboard-based Alumni Tracer Study Report Using Normalized Data Store Architecture

Proceedings of the 2019 8th International Conference on Software and Computer Applications Pub Date : 2019-02-19 DOI:10.1145/3316615.3316635

Asroni, Juanita Yusanti, S. Riyadi

{"title":"Dashboard-based Alumni Tracer Study Report Using Normalized Data Store Architecture","authors":"Asroni, Juanita Yusanti, S. Riyadi","doi":"10.1145/3316615.3316635","DOIUrl":null,"url":null,"abstract":"Universitas Muhammadiyah Yogyakarta is one of the universities in Indonesia. Every college must have graduated or called alumni. Alumni have an essential role in the development of educational institutions. Currently, alumni are used as one of the requirements for the university accreditation process by BAN-PT as evaluation material, therefore the importance of alumni monitoring or information, UMY has a tracer study to monitor alumni information using a questionnaire. However, to obtain data from the survey, it is still having trouble because the data is not yet integrated. Integrated data is collected by building a data warehouse. This research develops a data warehouse using NDS architecture, and There is some noise was found that need to be cleaned, such as null data and duplication of data. data warehouse alumni have been built, and it can meet the requirements of the institution that are displayed in a report to make it easier to analyze reports, the news is made into a dashboard form that is enhanced using Power BI applications.","PeriodicalId":268392,"journal":{"name":"Proceedings of the 2019 8th International Conference on Software and Computer Applications","volume":"40 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2019-02-19","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 2019 8th International Conference on Software and Computer Applications","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3316615.3316635","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 1

Abstract

Universitas Muhammadiyah Yogyakarta is one of the universities in Indonesia. Every college must have graduated or called alumni. Alumni have an essential role in the development of educational institutions. Currently, alumni are used as one of the requirements for the university accreditation process by BAN-PT as evaluation material, therefore the importance of alumni monitoring or information, UMY has a tracer study to monitor alumni information using a questionnaire. However, to obtain data from the survey, it is still having trouble because the data is not yet integrated. Integrated data is collected by building a data warehouse. This research develops a data warehouse using NDS architecture, and There is some noise was found that need to be cleaned, such as null data and duplication of data. data warehouse alumni have been built, and it can meet the requirements of the institution that are displayed in a report to make it easier to analyze reports, the news is made into a dashboard form that is enhanced using Power BI applications.

查看原文本刊更多论文

使用规范化数据存储架构的基于仪表板的校友跟踪研究报告

日惹穆罕默德大学是印度尼西亚的一所大学。每所大学都必须有毕业生或校友。校友对教育机构的发展起着至关重要的作用。目前，校友被BAN-PT作为大学认证过程的要求之一作为评估材料，因此校友监测或信息的重要性，UMY有一个追踪研究，使用问卷调查来监测校友信息。然而，从调查中获取数据，由于数据尚未整合，仍然有困难。通过构建数据仓库收集集成数据。本研究使用NDS架构开发了一个数据仓库，发现了一些需要清理的噪声，如空数据和重复数据。建立了校友数据仓库，可以满足机构的要求，以报表形式显示，便于分析报表，将新闻制作成仪表板形式，并使用Power BI应用程序进行增强。

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

求助全文

约1分钟内获得全文求助全文

来源期刊

Proceedings of the 2019 8th International Conference on Software and Computer Applications

自引率

0.00%

发文量