Implementation Of Sql Server Database And Business...

IMPLEMENTATION OF SQL SERVER DATABASE AND BUSINESS INTELLEGINCE IN XXXXX By Pranay Papishetty Bachelor of Technology (IT), Jawaharlal Nehru Technological University, India 2011 A Capstone Project Submitted to the Graduate Faculty Of St. Cloud State University In Partial Fulfillment of the Requirements For the Degree Master of Engineering Management St. Cloud/St. Paul, Minnesota [November, 2014] ACKNOWLEDGEMENTS Foremost, I would like to convey my honest gratitude to my mentors Dr. Hiral Shah and Dr. Ben Baliga for their continuous and tremendous support of my Master’s study at St. Cloud State University. I’m really thankful for all the knowledge they shared and guiding me towards the right path of success. Special thanks to Prof. Gary for spending his valuable time in reviewing this report and for all his insightful suggestions and recommendations. Finally I would like to thank my parents and friends for their support and encouragement. ABSTRACT The main objective of this project was to meet the needs of data management, capturing data from various data sources and integrating the data into a database for reporting purposes. This was achieved previously using a legacy system called as FOCUS and is now replaced by a database using SQL Server Business Intelligence. SQL Service Business Intelligence is not only used to load data into the database but also provides tools for reporting and analysis services. Loading data is done using a tool provided by SQL Server called