Creation of system of analysis and formation of sales forecasts in CRM systems has been described that allows you to forecast sales in customer relationship management systems and is a powerful tool for increasing the company's competitiveness and improving cooperation with customers. The Information processes in CRM systems have been analyzed. The sequence of events in the process of forecasting sales in system of analysis and formation of sales forecasts in CRM systems has been highlighted. The problem of forecasting sales as a regression problem have been defined. The main stages that need to be performed to test the model of the sales analysis and forecast system in customer relationship management systems in Azure Machine Learning are shown.
2. Analysis of the last research and problem statement attract and retain customers, and developing a strategy accordingly. After defining the strategic goals, choose the CRM system that best meets the needs of the company; Functional approach: in this approach, CRM implementation begins with specific functional tasks. For example, a company may determine that it needs to improve contact management or improve the efficiency of deal management. After that, choose the CRM system that best meets specific functional needs; Distribution in stages: this approach involves the implementation of CRM in stages or in different divisions of the company. A company can initially implement CRM in only one department or part of the business, and then gradually expand its implementation to other divisions. This approach can allow a company implement CRM to effectively, gradually adapting it to the needs of different departments and reducing risks.
Each of these approaches has its advantages and disadvantages, and the choice of approach will depend on the specific circumstances and purpose of implementing CRM for the enterprise.
CRM platforms are different, depending on the functions they perform: Lead management. These customer relationship management (CRM) systems collect information about potential customers from various sources, evaluate their potential, and connect new leads with appropriate sales representatives. Sales funnel management. Such CRM systems map the sales funnel within the CRM program to better understand the customer journey to purchase and increase conversion. Work processes automation and marketing. These CRM systems automate routine tasks such as prospecting, lead segmentation and customer interaction to streamline workflows and provide a personalized approach to potential customers. Reporting and forecasting. These customer relationship management (CRM) systems use dashboards, CRM analytics, and reporting tools to identify customer needs and measure sales performance.
CRM programs are widely used in various industries, including SaaS, real estate,
manufacturing, and marketing. The CRM platform is suitable for businesses of all sizes looking to
improve customer satisfaction, increase productivity and increase sales [
Within an organization, sales, marketing, customer support, and also finance and operations departments can use a CRM program to solve the following tasks: Optimization of the sales funnel to close more deals; Generating more promising leads to increase income; Building strong relationships to increase customer loyalty; Optimization of inter-team cooperation to achieve greater goals; Load reduction to increase productivity.
Depending on the needs, the customer relationship management system can be installed on a computer or use a cloud service. Most modern CRM systems also have a mobile application that allows you to work with your customer base from anywhere.
Choosing the right sales platform and CRM is fundamental to the success of any business. Consider the most popular CRM platforms: HubSpot, Salesforce, SalesDrive.
HubSpot [
Salesforce [
SalesDrive [
These systems are suitable for both small and medium-sized companies. Each of them has its advantages and disadvantages. When choosing a system, it is recommended that you evaluate your company's core CRM requirements and determine which features are best implemented in each system and which features can be sacrificed because they are not business critical.
Sales analysis and forecasting are key to developing a sales strategy and optimizing business processes. They allow companies to make decisions taking into account demand, the structure of the customer base and other factors.
To date, the problem of forecasting sales in CRM systems remains relevant due to the need for enterprises to obtain accurate estimates of their costs and revenues, which enables them to forecast their short-term and long-term effectiveness. Currently, sales forecasting is a requirement of the competitive race of modern business, enabling the enterprise to stay afloat. 3. Analysis and sales forecast formation principles in CRM systems Among the main capabilities of the CRM system, can be distinguished the following: 1. Customer information management. The CRM system consolidates the customer base and provides the organization with complete information about its customers, their preferences, on the basis of which an interaction strategy is built. 2. Sales management: the system saves the history of interaction with customers, helping the sales department to analyze customer behavior, form appropriate offers and win their loyalty. 3. Marketing automation: the CRM system allows you to optimize the company's marketing management, organize marketing activities, manage marketing resources and budgets, and coordinate marketing activities. 4. Automation of document flow: the system provides all the necessary tools for managing the company's external and internal document flow, including automatic document generation, preparation of printed forms of documents, maintenance of current versions of documents and quick search of documents in the system. 5. Business process management: dividing work processes into stages and formalizing their structure help reduce the number of errors and speed up the company's work, making results more predictable. 6. The CRM system analytical capabilities: the system provides companies with the opportunity to obtain static information and conduct deep data analysis necessary for strategic business processes.
Information processes in CRM are presented in Fig. 1 [
Since the CRM system is a web application, the following components are necessary for its correct operation: a web server and a database management system (DBMS). No additional software needs to be installed on the user's workstation other than a standard web browser. Implementation in the form of a web application allows you to work with the system on any platform, including mobile devices. This approach does not require significant computing resources, so the power of an ordinary computer or laptop is sufficient for the stable operation of the information system.
3.1. The analysis and formation of the sales forecast system main processes We identified main processes of the analysis and formation of the sales forecast system such as: Strategic planning: - strategic goals determination in the field of sales and profitability; - strategies and tactics development to achieve these goals through sales forecasting. Data collection and integration:
- identification of data sources, such as historical sales data, customer data, demographic data, etc.;
- integration of these data into a single system for further analysis. Data analysis: - analytical methods usage for processing and analysis of historical sales data; - correlations and connections identification between various factors and sales volumes. Forecasts development:
- prognostic models construction based on data analysis and taking into account historical trends and variable factors;
- generation of sales forecasts based on these models for different time periods. Validation and adjustment: - comparison of forecasts with actual sales results to validate accuracy; - corrections making to forecasts based on deviations from actual data. Planning and resources: - determination of resource needs based on sales forecasts; - planning of work processes and resources to meet demand. Monitoring and reporting: - constant monitoring of strategy implementation and forecast results; - creation of reports and analytical data to inform management and decision-making.
The top level of business processes of the subject area: Brief description of the TO BE target process: Data collection and processing: collection, processing and integration of data from various sources, such as historical sales data, customer data and other factors affecting sales; Analysis and modeling: use of analytical methods and models to determine trends, correlations and forecast sales based on collected data; Interaction with customers improving: improving methods of communication and interaction with potential and existing customers based on analytics and sales forecasts; Process automation: introduction of automated tools to optimize routine operations related to sales and customer service; Monitoring and evaluation: constant monitoring of sales results, comparing them with forecasts and improving the system based on acquired knowledge;
Reporting and analysis: creating reports and analytical data for management and the sales team to make strategic decisions.
As a result of this targeted process predictability has been improved and sales efficiency has been achieved, which contributes to increased profitability and customer satisfaction in the CRM system.
3.2. The analysis and sales forecast methods
The goal of the work is the development of a system that provides optimization of customer relationship management (CRM) through sales analysis and forecasting.
To achieve the set goal, the task of the sales analysis and forecast system in customer relationship management (CRM) systems is as follows:
Data collection and storage: ensure the collection and storage of information about customers, their purchases, interaction history, and other important data necessary for sales analysis and forecasting.
Data analysis: develop algorithms and models to analyze historical data, including customer segmentation, determining correlations between factors and sales, analyzing the effectiveness of marketing campaigns and other aspects.
Sales Forecasting: Develop sales forecasting models based on historical data and other factors that may affect demand.
Sales planning and strategy: based on analysis and forecasts, develop sales strategies, including optimization of pricing policy, marketing activities, as well as inventory and production planning.
Monitoring and evaluation of results: constantly monitor the results of the implementation of strategies and adjust them if necessary to achieve better results.
Building models for analyzing and forecasting sales in the CRM system helps the company to effectively manage relationships with customers, maximize profitability and improve the quality of customer service.
A sales forecasting problem is usually a regression problem because it involves predicting numerical values (sales volumes). The task can be divided into several subtasks, such as forecasting sales by product categories, geographic regions, etc.
Thorough analysis and understanding of sales data is an important step. This analysis will help determine which algorithms and methods can be the most effective for this task.
Purpose of regression analysis [
Determination of the degree of determinism of the variation of the criterion (dependent) Predicting the value of the dependent variable using the independent one.
Determination of the contribution of individual independent variables to the variation of the dependent variable.
Regression analysis can’t be used to determine the presence of a relationship between variables, since the presence of such a relationship is a prerequisite for applying the analysis.
The regression analysis algorithm has the following form: let the measurements of Yn be obtained at the points xn of the independent variable x. It is necessary to find the dependence of the average value of the value on the value of x,
Where a is a vector of unknown parameters ai. The function f(x|a) is called the regression function. It is assumed that f(x|a) is a linear function of parameters a, that is, it has the form: ∗( ) = ( | ), ( | ) = ∑ ( ), =0 Where fi(x) are given functions.
In this case, the matrix Am=fi(xn) is called a regression matrix. To determine the parameters, the method of least squares is used, that is, the estimates ai are determined from the minimum conditions of the functional: (1) (2) And from the functional minimum: = ∑ (4) (5) (6) = ∑( − ∑ )( −1) ( −
∑ ), ,
For correlated measurements with the correlated matrix R. Power functions fi(x) = x2 serve as
functions fi(x). Orthogonal and normalized polynomials on the set fn are often used. In this case,
it is easy to find the estimate ̃ :
̃ =
∑ ( ) )
It follows that the calculation ̃ does not depend on calculation of others estimates ̃ .
Usage the regression method for forecasting sales in the CRM system:
processes is the consideration of their time series [
Effective planning and management of many processes in CRM systems is impossible without
operational forecasting. Often, economic processes in enterprise management have a complex
behavior that is similar to "chaotic". There are models of chaotic dynamics that are increasingly
used in the management of economic systems [
The best solution for forecasting the values of time series levels is considered to be performed
on the basis of the generalized logistic mapping model, given by the following recurrent
relationship [
+1 = ( − ),
Where , α and β are model parameters calculated by the method of least squares; N is the maximum value of the levels of the series.
The mapping +1 is one-dimensional nonlinear. The previous level of the series is used to
form the result. According to the conducted studies, even simple nonlinear models, for some
parameter values, have a chaotic behavior that seems random with a sufficient number of levels
of the series. However, in deterministic nonlinear models, such chaotic behavior is generated
precisely by nonlinearity [
Usage the time series method for forecasting sales in the CRM system: Rationale: the time series method is very important for the analysis and forecasting of temporal data such as sales volume in different periods. Taking into account temporal factors, such as seasonality and trends, helps to obtain more accurate forecasts. Application: the time series method can be used to analyze and forecast daily, weekly, monthly, or quarterly sales. This method allows you to take into account seasonal fluctuations and identify trends in sales changes. Efficiency: the time series method is well suited to situations where time is an important factor in changing sales volumes. It allows you to analyze the dependence between today's and past sales, which is critical in CRM systems. 4. CRM-system sales forecast system description
We will describe the sequence of events in the process of forecasting sales in CRM using a UML
sequence diagram (Fig.3) [
This diagram allows you to visualize the sequence of events in the process of forecasting sales in CRM and shows the interaction between objects.
To visualize the architectural structure of the software system, we will use the component diagram. This diagram allows you to represent the system as interconnected components and show how they interact with each other.
Let's look at the main elements that can be found in a UML component diagram [
A component diagram helps model the architecture of a software system and can be used for analysis, documentation, and communication with the development team.
Microsoft Machine Learning Studio as one of the main tools for solving the problem of analysis
and forecasting in CRM systems has been chosen. Microsoft Machine Learning Studio (formerly
known as Azure Machine Learning Studio) is an integrated platform for developing and deploying
machine learning models [
The development of a project to solve the problem of forecasting sales in CRM systems using Azure Machine Learning included the following steps: 1. Data preparation: collection of necessary data for forecasting sales from the CRM system and other sources. Checking and cleaning data from missing values, anomalies and extraneous factors; 1. Creation of an Azure Machine Learning workspace: a workspace in the Azure Machine Learning service, for project development and execution; 2. Creating an experiment: an experiment in Azure Machine Learning, which includes the steps of data preparation, model selection, training and model evaluation; 3. Data preparation and visualization: Azure Machine Learning tools, such as Azure Data Studio, for data preparation and visualization; 4. Model selection and training: machine learning libraries in Azure Machine Learning to select and train sales forecasting models. Various models can be used, such as linear regression, decision trees, random forest, etc. Setting model parameters and evaluating their effectiveness using quality metrics; 5. Model validation and tuning: validation techniques, such as cross-validation, to assess model accuracy and reliability. Adjusting model parameters to improve its results; 6. Model deployment: after training and validating the model, it was deployed in an Azure Machine Learning environment using a prediction web service that can be integrated with a CRM system; 7. Provision of a mechanism for updating the model with new data.
To obtain a forecast based on the developed forecasting model, functions (Azure Functions) have been developed, the result of which can be obtained using an http request.
For the possibility of integration with the CRM system, Vue.js components has been developed, with the help of which you can start the training of the forecasting model and view the sales forecast for a certain period.
As a result of the conducted research, a web component was developed that can be integrated into the CRM system. This program allows you to forecast sales in customer relationship management (CRM systems) and is a powerful tool for increasing the company's competitiveness and improving cooperation with customers.
After training machine learning models, we need to deploy them in production so that others can use them to make predictions. In Azure Machine Learning, we can do this with Endpoints and Deployments. Endpoints and Deployments allow you to separate the workload interface from the implementation that serves it.
To deploy machine learning models in Azure Machine Learning, you can use Web Service deployment to access the model online. Here is a general overview of the process of deploying a web service to Azure ML: Once deployed, the web service will be available at a specific URL. You can use this URL to interact with the resulting machine learning model via HTTP requests.
In this work, a detailed analysis of the systems of interaction between consumers and the company was carried out, the business processes of the CRM system were described using a structural approach, various sales forecast models were developed in customer relationship management systems (CRM) systems, and the best of them was chosen. Creation of system of analysis and formation of sales forecasts in CRM systems allows you to forecast sales in customer relationship management systems and is a powerful tool for increasing the company's competitiveness and improving cooperation with customers.
Building models for analyzing and forecasting sales in the CRM system helps the company to effectively manage relationships with customers, maximize profitability and improve the quality of customer service.
The problem of forecasting sales as a regression problem have been defined. The main stages that need to be performed to test the model of the sales analysis and forecast system in customer relationship management systems in Azure Machine Learning are shown.
The developed system is effective and provides high accuracy, which allows enterprises to rationally use their resources for future growth and monitor cash flows.
The innovativeness of the work consists in an automated approach to forecasting sales of CRM systems, based on the use of large volumes of data and machine learning algorithms.