A Framework Development for Application of Data Warehouse in the Ethiopian Banking Industry the Case of Dashen Bank
No Thumbnail Available
Date
2022-01-29
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Addis Ababa University
Abstract
Data warehouse is the fastest growing technology integrated with Business intelligence to make a better decision using analytics on the current as well as historical data of the organization. The purpose of this research is to develop a framework for the application of Data warehousing technology in the Ethiopian banking industry, the case of Dashen bank. The research followed the Kimball dimensional data modeling technique to show the conceptual and logical data model. For this particular Applied research, a qualitative research methods are believed to be more suitable in describing the process of developing the data warehouse and Data collection is mainly based on Focus Group discussion between the staff members of the IT department, Observation and document assessment to evaluate the current status of data integration and readiness of the bank for the application data warehouse. With this the readiness of the bank is evaluated, the data concentration area in the bank’s current system is also identified, source databases and the type of data with these systems is also identified and these findings analyzed and represented using the UML class diagram on the conceptual level.
Based on the conceptual level, conformed dimensional tables and Fact tables with their attributes and measures are identified. The logical design section of the study shows the relationship of facts and dimensions using star schema of Kimball dimensional modeling. The finding of this research tried to shows the benefits of the application of data warehousing technology in the Ethiopian banking industry using the conceptual and logical design of the data warehouse in the case study organization.
Description
Keywords
Framework Development, Application, Data Warehouse, Ethiopian, Banking Industry, Case of Dashen Bank