Holistic Survey Approach Using Business Intelligence Tools
- February 28, 2018
- Posted by: RSIS
- Categories: Computer Science and Engineering, Engineering
International Journal of Research and Scientific Innovation (IJRSI) | Volume V, Issue II, February 2018 | ISSN 2321–2705
“Holistic Survey Approach Using Business Intelligence Tools”
Divya.P1, Pavithra.T2, Poornamrutha.S3
1, 2, 3 Computer Science and Engineering, Sri Shakthi Institute of Engineering and Technology, Coimbatore, Tamil Nadu, India
Abstract: The survey web application which takes survey or feedback in various aspects such as academics, transportation, hostel facilities etc.Admin has the privilege to create and publish any kind of surveys anytime to any user groups.Admin could also view the responses and reports generated from different surveys. Reports generated will help us to solve those issues and give fruitful results. User groups can comprise of faculties or students who are hostellers, day scholars and also those who avail transport facilities.Admin has the right to create dynamic feedback or surveys.User could also view the end date of the survey he/she has to finish.Whenever the admin uploads the survey, user gets notified and he could submit the survey within the due date.Survey may be applicable for some user groups or for the whole institution. Any time it is possible to get all the responses or the survey taken up by the particular student. Finally, the reports will be generated using business intelligence tools.
Keywords: SSIS, SSRS, survey, business intelligence, reports
I. INTRODUCTION
Business Intelligence technology is used to improve the business goals and process by gathering the available data and processing it to get the desired result as proposed by the user. In this survey applicationwe propose the user to give their suggestions, opinions or feedbacks in various regards.All those responses will be taken into account and various analysis will be proposed to get the desired output.Output will be in the form of either table or charts which are done by different analytical algorithms. Various tools used in business intelligence are SQL server management, SQL server integration services,SQL server reporting services, SQL server analysis services. According to user perspective charts can be drafted by using different parameters that are done using SSRS.
II. BUSINESS INTELLIGENCE
Business Intelligence is a tool which is mainly used for online analytical processing, data mining, data analytics, reporting and several other applications. Business Intelligence typical components are gathering, integrating, sharing and analysing the data.It provides believable information to help making effective and high quality business decisions. Operations in business intelligence are extract, load and transform. Business Intelligence systems are based on Data Warehouse technology.