TY - BOOK AU - Donia Ali Elbastawissy AU - Ehab Hassanein , AU - Neveen Elgamal , TI - Optimized data warehouse for banking systems / PY - 2020/// CY - Cairo : PB - Donia Ali Elbastawissy , KW - Banking systems KW - Data warehouse KW - Quality Assurance (QA) N1 - Thesis (M.Sc.) - Cairo University - Faculty of Computers and Artificial Intelligence - Department of Information Systems; Issued also as CD N2 - Data Quality, Database Testing, and ETL Testing are all different ways and techniques for testing Data Warehouse Environment. Testing the data became very important as we should guarantee that the data is accurate for further manipulation and decision making. A lot of tools came up supporting the automation of testing data warehouse, some of them support only the automation of running the scripts, some support the automation of creating the scripts, and others are just organizing and managing the cycle of testing. However, banking environment still faces a lot of challenges that are not yet solved by the different approaches and tools.This thesis presents an elaborative testing strategy that includes specifications for test cases especially for banking environment challenges and how to automate these test cases scripts. The proposed strategy outperformed the traditional technique used by the case study bank for nearly more than 10 years and reduced the cost of working hours of the quality Assurance (QA) team up to 89 percent ER -