Developing Business Intelligence Framework to Automate Data Mapping, Validation, and Data Loading from User Application

Abstract

In the last decade, Business Intelligence (BI) became a predictable technological advantage of the large enterprises which could afford to buy, implement and maintain BI solutions. Presently, small and medium size enterprises all over the globe have realized competitive and financial benefits of BI. However, limited IT budgets of small companies and BI's high total cost of ownership have created a gap between large and small enterprises where small enterprises do not become fortunate to avail the virtues of BI because of the affordability factor. This research proposes a BI framework which provides automated data mapping, loading from user application to BI framework and also validates it. The implementation of the proposed framework provides convenience of use and effective cost saving as it does not require any technical expertise and any non-technical user can get on with it very well.