Conceptual Design of a Data Warehouse for Cash Management and Forecasting in Public Finance – Albanian Case
The application of information technology has grown significantly in every business area, from simple to more advanced and complex applications, supporting every business operation. Many scientific researchers have focused on using information technology to support decision-making processes. Our research paper is focused on a specific area of public finance: cash management and forecasting. In our research, we will present a conceptual design of a data warehouse that will be used as the core of a sophisticated system for improving cash management and forecast in the Government of Albania. The data warehouse will be designed in such a way to allow application of Business Intelligence tools, such as Online Analytical Processing and data mining for performing query and reporting, complex financial analysis, predictive analysis and support decision making, that are crucial for the management and forecast of the cash flow. During our research we will analyze the sources of data, the architecture of the data warehouse and propose a multidimensional model as the best solution to accomplish our task. Another advantage of the designed data warehouse is the further extension for additional financial processes and analysis.
Index Terms - Cash management and forecasting, data warehouse, information system, multidimensional model.