Design and Implementation of Business Intelligence Systems

Abstract: The goal of this project was to investigate the limitations of current Business Intelligence System (BI System) which was needed to re-design its architecture and embed two new modules. These two modules were named as Survey Form and Statistics Report. The survey form has a very dynamic behavior, for example the administrator can generate different types of surveys instantly by drag drop quick functionality of the interface and he can also send that surveys to the users. The user will give the answers of survey questions and send them back to the management of the company where survey form modules helped them to analyze the answers in the form of graphs. This survey form is also providing five different types of scheduling system where administrator can schedule their surveys in five different ways like Once, weekly, Monthly, Quarterly and Yearly. Statistics module has different behaviors. It implemented four different types of reports which are inter-related with each other. These four reports were named as financial report, human resource report, project overview and company overview. The finance report was responsible that it will show the revenue amount and source, from where the company generated this revenue. The second report was belonged to human resource department which was responsible for generating the overall situation of the employees and their projects. For example how many are on holidays, idle, working and going to be free soon. The third report was representing the projects overview of all the projects. This report is responsible for checking the status of all projects and show them in bar char who will show the management that how many projects are completed, going to start or delay and going to finish soon. The fourth and final report was responsible for generating report for the overall company status. This project has been completed successfully. The design, architecture and, implementation of intelligent Survey Form and Statics modules have been implemented and working successfully.