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

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.