Decision Support System Utilizing Data Warehouse Technique for the Tourism Sector in Egypt

Abstract

Tourism plays an important role in supporting national economy and creating new jobs. It contributes positively at raising the national income and improving the balance of payments. Egypt depends on the tourism sector to support its national economy. It also represents one of the main sources of hard currency and contributes significantly at solving the problem of unemployment. Notwithstanding, decision makers in Egypt tourism sector have no chance to access a unified data source that can supply information to meet their inquires and expectations. Also the difficulty in conducting analysis and in processing the current data to extract the required information is another challenge because it consumes a lot of time and effort. In this paper, we propose a data warehouse prototype based decision support system for the tourism sector in Egypt. This prototype integrates all the available data sources into a unified data warehouse where data can be viewed, retrieved, and analyzed quickly and efficiently. This system enables the decision makers to access the required information quickly and accurately to support them in making critical decisions at the suitable time.