Data Preparation for Self-Service BI of Human Resources Analysis in Banking Industry

Navaphat Bhichesthapong, Mananya Jongkolpatlr, Tanapond Praikasate, Natsuda Kaothanthong
{"title":"Data Preparation for Self-Service BI of Human Resources Analysis in Banking Industry","authors":"Navaphat Bhichesthapong, Mananya Jongkolpatlr, Tanapond Praikasate, Natsuda Kaothanthong","doi":"10.1109/ICESIT-ICICTES.2018.8442065","DOIUrl":null,"url":null,"abstract":"The scope of Business Intelligence (BI) has been extended from strategic questions to operational tasks. In this way, the requests for updating the data in reports are generated. Consequently, BI specialists, who are responsible for preparing the data, become insufficient. A Self-Service BI has been introduced to allow non-specialists to derive the information from the large amounts of data without involving BI specialists. In this work, the data preparation for self-service BI for producing human resources reports of a bank is presented. A number of views is created based on the mapped attributes in the data warehouse and the requirements. Then, a data cube is constructed from the SQL command of the views. The configuration of dimensions and measures in BI software allows non-specialists to perform reporting and analytics from a variety of viewpoints. The outcome of the data preparation for BI software allows the non-specialists to produce time-critical reports without involving the BI specialists.","PeriodicalId":57136,"journal":{"name":"单片机与嵌入式系统应用","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2018-05-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"单片机与嵌入式系统应用","FirstCategoryId":"1093","ListUrlMain":"https://doi.org/10.1109/ICESIT-ICICTES.2018.8442065","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0

Abstract

The scope of Business Intelligence (BI) has been extended from strategic questions to operational tasks. In this way, the requests for updating the data in reports are generated. Consequently, BI specialists, who are responsible for preparing the data, become insufficient. A Self-Service BI has been introduced to allow non-specialists to derive the information from the large amounts of data without involving BI specialists. In this work, the data preparation for self-service BI for producing human resources reports of a bank is presented. A number of views is created based on the mapped attributes in the data warehouse and the requirements. Then, a data cube is constructed from the SQL command of the views. The configuration of dimensions and measures in BI software allows non-specialists to perform reporting and analytics from a variety of viewpoints. The outcome of the data preparation for BI software allows the non-specialists to produce time-critical reports without involving the BI specialists.
银行业人力资源分析自助BI数据准备
商业智能(BI)的范围已经从战略问题扩展到操作任务。通过这种方式,生成更新报告中的数据的请求。因此,负责准备数据的BI专家就变得不够用了。自助式BI已经被引入,允许非专业人员从大量数据中获取信息,而不需要BI专家的参与。在本工作中,介绍了银行人力资源报告的自助式BI的数据准备。根据数据仓库中的映射属性和需求创建了许多视图。然后,从视图的SQL命令构造一个数据多维数据集。BI软件中维度和度量的配置允许非专业人员从各种角度执行报告和分析。BI软件的数据准备结果允许非专业人员在不涉及BI专家的情况下生成时间关键型报告。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 求助全文
来源期刊
自引率
0.00%
发文量
7395
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信