Generation of MIS Report Using Data Warehouse

Abstract

MIS reports are used as decision support systems for higher Management in hospitality industry. Manual generation of MIS report is a time consuming task which can lead to many human errors and excessive calculations process. The main objective of this research is to develop an automated system for generation of MIS reports, using data mining and data cleansing technique with best suitable OLAP data modelling approach. It can be used for better budget prediction which can help to run the business in good financial shape. It also helps reducing error and optimizing the operational cost in better way. The MIS report will be generated on the low-level accounting data which has day to day transaction linked to each GL accounting code. The report will display the Actual amount for each particulars (report lines), along with budgeted amount.