The relevance of the topic considered in the article is to solve the problems of designing management decision support systems for enterprises based on business analytics technology. The research purpose is to analyze the applied methodologies during the design stage of the enterprise information system, to develop principles for using management decision support systems based on business intelligence. The problem statement is to analyze the technologies available on the market, which deal with business analyst systems, their potential use for decision support systems, and to identify the main stages of business analyst for enterprises. Business intelligence (BI) is information that can be obtained from data contained in the operational systems of a firm, enterprise, corporation, or from external sources. The BI can help the management of a company make the best decision in the chosen sphere of human activity faster, and, consequently, win the competition in the market for goods and services. A decision support system (DSS) which uses business intelligence, is an automated structure designed to assist professionals in making decisions in a complex environment and to objectively analyze a subject area. The decision support system is the result of the integration of management information systems and database management systems (DBMS). The internal development of BI is more cost-effective. The methods used are Structured Analysis and Design Technique and Object-oriented methods. The results of the research: the analysis of the possibilities was conducted and recommendations relating to the use of BI within DSS were given. Competition between BI software in business analysts reduces the cost of products created making them accessible to end-users – producers, traders and corporations.
Key words
data analysis, external data sources, data transformation, data marts, multidimensional OLAP, MS Analysis Services, decision support system, DBMS