The Concept of Business Intelligence in the Microsoft SQL Server Environment

• Autorzy: Magdalena Szmajduch
• Języki publikacji: EN

Abstrakty

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. (original abstract)

Słowa kluczowe

EN

e-business; Data Mining; Data warehouse; Business Intelligence systems

PL

Biznes elektroniczny; Data Mining; Hurtownie danych; Systemy Business Intelligence

• Czasopismo: Information Systems in Management
• Rocznik: 2016
• Tom: 5
• Numer: nr 3
• Strony: 413--423

Twórcy

autor

Magdalena Szmajduch

• Cracow University of Technology, Poland

Bibliografia

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