SAP Lumira is a software for visualization and data management. It allows to analyze data by creating and sharing graphical visualization of data from multiple sources without writing code. The main advantage over other analytic tools are: simple and intuitively understandable interface, the ability to retrieve information from multiple heterogeneous data sources (excel worksheets, the relational database tables), data sharing, and others. Skybuffer experts at Business Intelligence used SAP Lumira to build sales analysis with SAP Lumira for Robust Trucks, Inc. and evaluated all the advantages of this tool.
BUSINESS CASE REQUIREMENTS
Trucks producer is Trucks, Inc.
Robust Trucks, Inc. is the official dealer of Trucks, Inc.
The producer Trucks, Inc. defines the truck quota for countries annually. Customers can buy the trucks directly from Robust Trucks, Inc. or can have them into the international leasing without the participation of Robust Trucks, Inc. This transaction also affects Robust Trucks, Inc. annual quota.
It is necessary to make an analysis of sales activities, including:
- Sales allocation by customers;
- Sales allocation by trucks models;
- The level of quota compliance;
- The maximal revenue of sales deals possible & completed in the context of sales managers. Purpose: to identify managers with weak spots (low profitability of transactions),
- The level of deals closing assessment for each sales Manager. Purpose: to assess the level and equality of managers workload.
- Evaluation of weighted deals income. Purpose: to track objects of deals with different levels of profitability in the context of sales managers.
- Evaluation of the orders capacity in the context of customers and ordered trucks models. Purpose: to find out the reasons of a certain level of sales and to assess the sales for each customer in details.
- Evaluation of the customers profitability. Purpose: to identify leaders and outsiders among customers in order to perform appropriate promotion activities.
MASTER AND TRANSACTION DATA
The basis for the analysis of the current situation of trucks sales for the specific time interval is represented by the data, collected in the CSV file. The first spreadsheet reflects the list of sold trucks, characteristics, and the quota for each type of truck.
The second CSV spreadsheet provides information about the potential and held deals with responsible Manager for each transaction.
Data is loaded to SAP Lumira in the form it has been extracted from the data source system.
For analysis purposes the data can be post-processed directly in SAP Lumira. These transformations have no effect for the source data file. Moreover, the original file can be modified and these changes will be reflected in data visualizations reports created using SAP Lumira.
ROBUST TRUCKS, INC. SALES ANALYSIS
Following charts can help to analyse the year to date sales activities at the dealer company.
- The distribution of orders by customers;
- Trucks sales by models;
- The level of quota compliance.
For the easy selection of values there is a possibility of filtering . With help of this tool there can be shown only values of the user’s interest.
In this example, the most relevant filter criteria for the graphics are on the slide: series of the sold trucks, engine & order type. When selecting a specific criterion, information corresponding to the selected characteristic is displayed at all graphs.
Let’s take a look at the “Sales orders by customers”. It’s convenient to use the function Full screen.
Using this chart we can conclude which customers are the most active in making deals. Moving the mouse to the sectors of the pie chart you can see the exact number of deals with the client. In this case Optimal Waybills, Inc. is the leading customer.
Filtering functionality can also help to monitor customers who prefer trucks with a certain type of engine, for instance, in order to negotiate with the clients more effectively, to be aware of their preferences and to make appropriate proposals on further cooperation.
“Sales by truck models” chart helps to define which item is the most popular among the customers.
Moving the mouse to the sectors of the chart you can evaluate not only the quantitative but also the percentage of goods sold.
The quota compliance is an indicator that requires perpetual control. The third chart “The level of quota compliance” represents the current situation of the quota compliance for each type of truck.
For the current example, it can be concluded that the truck model DAF_CF is being sold quite actively and perhaps a deficit of the annual quota may occur by the end of the year. Thus the increase in the quota should be provided for the next year.
Evaluation of the maximal revenue
The assessment of the potential sales is an important part of the sales analysis.
The chart represented on the second slide allows you to compare the work of sales managers on the base of criteria set. The location of the bubble on the chart reflects the weighted income that made by each manager to the date considering the number of processed orders. The width of the bubble indicates the maximal income of the manager’s deals. The height represents the probability of obtaining maximal income based on the average percent of bringing the transaction to the point of sale by the Manager.
Observing the chart for this example, it is already possible to make some conclusions. It is evident that in spite of a greater number of transactions for Manager Tommson’s that are in process, the average income from his activities is less than that of Manager Peterson. The height of the bubble also confirms the fact that Manager Peterson works more effectively, bringing the transaction to the point of sale. At the same time Manager Timberman is in the outsiders group, despite the fact that he has more processed transactions than Manager Johnson does. It’s easy to notice that the small height of the bubble indicates a low probability of receiving income from transactions processed by Manager Timberman.
Trends that are just determined about should be analysed from the different view. To do this, let us go to the evaluation of deals potential.
Evaluation of the deals potential
With help of the next chart you can assess the potential deals of each sales manager more accurately.
It should be mentioned that manager Peterson brought the most of the income. Thus, his activities are more productive. At the same time Manager Tommson and Manager Stevens are processing deals with a quite large potential income, but due to certain circumstances the probability of bringing deals to the sales point is less than that of the managers Peterson & Johnson.
For making a correct decisions about redistribution orders between managers the parameters of deals closing for each Manager should be assessed. To do this let’s go to the evaluation of the deals closure.
Evaluation of the deals completing
The next slide allows to monitor the closing of the deals by each Manager. The slide shows a chart with a quantitative comparative assessment of completed deals and orders in process for each Manager. The allocation of completed and processed deals among customers is represented in the table.
Thus, it is possible to evaluate the workload of each Manager. Also a chart allows to conduct a comparative analysis of each Manager’s work.
It’s confirmed again that the workload of managers Tommson and Stevens is the highest at the moment and requires redistribution of potential orders between less busy managers. The most rational decision is to pass part of Tommson’s deals to Peterson, and redistribute some Stevens’ deals among Johnson and Timberman.
The table, represented at the slide allows to explain quantitative indicator in details. With its help it is possible to track which companies are being processed by every Manager, what is the probability of bringing the deal to the sales stage and what is the weighted income of the deal at the moment.
The filter panel at the slide allows you to monitor the information about deals with a defined probability of completing.
The status of a potential client, his motivation in buying and other factors are often affect the probability of the deal completing. In order to highlight the transactions with the greatest risk of fail let’s choose deals with a small probability of closing using the filtering tool.
This deals need the greatest attention. Making redistribution, it is advised to involve more experienced sales managers to the work on such deals.
Capacity evaluation of the customers orders
Following chart shows the distribution of orders among customers. The graph allows to evaluate the quantity of each customer’s orders in the context of truck models.
Particular emphasis should be put on the companies with the greatest risk of deals failure highlighted on the previous slide in order to evaluate the capacity of their orders in the past and present, to make a conclusion about the causes of the low probability of completing deals on this basis and to take appropriate actions. To do this we should mark the companies with a small probability of completing the deals in appropriate filtering box.
It also makes sense to highlight the sales status: Completed, in order to determine which of the selected customers have already made orders that, accordingly, increases the probability of sale, despite of a small chance at the moment.
According to the chart it is clear that more attention should be given to organizations Opportunity Services, Inc, Easy Way Logistics LLC and InTime, Inc. because these organizations are making an order for the first time.
Assessment of the customers profitability
The visualization of the customers profitability is of a high importance. It is necessary, for instance, to divide customers into groups for events of various types.
This decision is easy to make based on the chart below.
More intensive color and a larger area indicates customers with the highest revenue. They should be included in the VIP-clients group.
Customers noted by the color of less intense require actions focused on a product promotion.
SAP Lumira is an awesome easy-to-understand and easy-to-use data visualization and data maintenance tool. Even with a small dataset using SAP Lumira you can get comprehensive visualizations of data and make right management decisions.