Date of Award
12-2014
Culminating Project Type
Starred Paper
Degree Name
Engineering: M.E.M
Department
Mechanical and Manufacturing Engineering
College
College of Science and Engineering
First Advisor
Hiral Shah
Second Advisor
Ben Baliga
Third Advisor
Balsy Kasi
Keywords and Subject Headings
Management, Data, Business Intelligence, Project
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 as SSIS and reporting or representation of data is done using another tool provided from SQL Server called as SSRS. SSRS is used for generating ad hoc and automated reports. This project provides an alternative solution to meet the business needs previously provided by FOCUS reports and also helps to move away from FOCUS reporting resulting in possible substantial licensing cost savings.
Recommended Citation
Papishetty, Pranay, "Implementation of SQL Server Database and Business Intelligence in an Oil and Gas Industry" (2014). Culminating Projects in Mechanical and Manufacturing Engineering. 71.
https://repository.stcloudstate.edu/mme_etds/71
