Building a data warehouse for cash management and forecasting in public finance
Paper details:
REVISION HERE:
The data warehouse star schema is not accurate. Important information is missing and the proposed data warehouse cannot
be used for cash management and forecasting purposes. The challenge of this research is specifically to create and design a
data warehouse where all relevant data regarding revenues (forecasted, planned and actual), expenditures (planned and
fact), daily limits, accounts status (held at 8oA) are stored and organized in a such a way that can be used for the purpose using
BI techniques. The proposed schema is not accurate and need to be substantially revised. Please take into account that BoA
will offer information on the status of the TSA account and foreign currency accounts. Data about collected revenues will be
extracted from the AGFIS system (the table contains the main data that are needed), revenue forecast will be provided by
taxation and customs institutions and debt department, whereas planned revenues (planned and forecasted are two different
things) will also be provided by taxation and customs, but they are not the same with planned. The data warehouse should
store information on expenditures. Executed expenditures will be extracted from AGFIS, whereas planned expenditures have
two different sources: ‘I. from AGFIS system, regarding the monthly planned expenditures, prepared by the budget department
at the beginning of the year (broken down at the level of articles), 2. from budget institutions in their daily cash flow plan
(containing expected payments amounts and expected date and other relevant information as described in the table) and
monthly cash flow plans (containing total of expected payments for each month and other relevant information described in
the table). Another important information that is missing in both versions submitted till now is the data about the daily cash limit
(which is explained in detail in the description document). The article on cash management and forecasting provided also
explains the data and the processes to help you understand and prepare the research. Please let me know if additional
information or explanations are needed. The database schema can be a star schema, hybrid or other, the important is that it
can contain all the information and is structured and organized in such a way that all the data can be used for further analysis,
such as time series, neural network, what if analysis and so on. If the data warehouse is built wrongly than all the research is
useless. I hope you understand the importance.
I also commented that the references should be highlighted in the text in order to identify which part of the text refers to a
book, or website etc., in the reference list.
Again, the diagram of the data warehouse schema has overlapping objects and the relations do not point to the specified
attributes.
the excel document is only for illustrative purpose, if it helps understand the data collection and the analysis. I have t
the major part of the information and deleted several pages that are not needed, in order not to create confusion. Thimthe excel document is only for illustrative
purpose, if it helps understand the data collection and the analysis. I have translated
the major part of the information and deleted several pages that are not needed, in order not to create confusion. This excel
document has been used by the MoF staff for cash management and forecasting
CF March 2011 Englishxls [MATERIAL]
The main details of the paper are specified in the word document: “research description”
