THE CONCEPT OF BUSINESS INTELLIGENCE IN THE MICROSOFT SQL SERVER ENVIRONMENT

• Authors: Szmajduch Magdalena
• Languages of publication: EN

Abstracts

EN

Application of supporting business-related decision making processes through the use of information systems is becoming one of the fundamental requirements of the market competition. In this paper we present a survey of Business Intelligence (BI) models which can be implemented in Microsoft SQL Server environment. The survey is a response to the rapid development of BI solutions as they enter new areas of company’s activities, adopting new technologies. Business Intelligence systems have become an integral part of every major company. The aim of this analysis is to present the Microsoft SQL Server capabilities, functionalities and services dedicated for the BI purposes. The overview is provided with simple comprehensive analysis of selected environment components indicating their relevance to the particular company requirements. The summary of the significance of using Microsoft SQL Server software is the review of selected services.

Keywords

EN

Business Intelligence; E-business; Data Mining; Data Warehouse; Analytical Processing

• Publisher: Katedra Informatyki Szkoła Główna Gospodarstwa Wiejskiego w Warszawie
• Journal: Information Systems in Management
• Year: 2016
• Volume: 5
• Issue: 3
• Pages: 413-423

Dates

published

2016

Contributors

author

Szmajduch Magdalena

• Department of Computer Science, Cracow University of Technology (CUT), Poland

References

• B. Knight, D. Knight, J.M. Moss, M. Davis, C. Rock: Professional Microsoft SQL Server 2014 Integration Services, John Wiley & Sons, Inc. , 2014
• R.Mistry, Introducing Microsoft SQL Server 2014 Technical Overview, Microsoft Press, 2014
• http://searchdatamanagement.techtarget.com/definition/OLAP
• Luhn H.P. (1959) A Business Intelligence System, IBM Journal, 10/1958, 32-48.
• http://www.gartner.com/technology/home.jsp
• http://olap.com/learn-bi-olap/olap-bi-definitions/business-intelligence/
• http://research.gigaom.com/report/bringing-in-memory-transaction-processing-to-the-masses-an-analysis-of-microsoft-sql-server-2014-in-memory-oltp/
• https://technet.microsoft.com/pl-pl/library/microsoft-sql-server-przeglad-uslug-analysis-services.aspx
• http://www.business2community.com/business-intelligence/gain-competitive-edge-business-intelligence-software-analytics-01280045
• http://www.comarch.pl/files-pl/file_165/Comarch-Odkrywaj-wiedze-z-danych-PL.PDF
• http://www.informationbuilders.com/business-intelligence
• F. Burstein, C. Holsapple: Handbook on Decision Support Systems 1, Springer, 2008
• C. Webb, A. Ferrari, M.Russo: Expert Cube Development with SSAS Multidimensional Models, Packt Publishing, 2014
• http://www.codemag.com/article/1308091
• A.Jorgensen, B.Ball, S.Wort, R. LoForte, B.Knight: Professional Microsoft SQL Server 2014 Administration, John Wiley & Sons, Inc. , 2014

Identifiers

ISSN

2084-5537