Sales data analysis simplified with SAP Lumira

I built a sample dataset for an agro chemical company which had Sales data. Using Lumira I could bring out in pictures the highlights of the Net Sales and the Sales Quantity across various aspects. Below I have provided few of the reports I built using Lumira within few minutes.

Case Study – 1

Business Users were interested to know the following facts out of Sales Data

·         Net Sales By Region

·         Gross Sales By Buying Group

·         Gross Sales By Product

                                    Case Study 1.png

Case Study – 2

     The story board I created as below represents various parameters of the gross Sales by Sales Representative. Also shows the top sales performers.

Business was interested to check on the Salesman receiving the commissions to recognize the best.

This is the Tag Cloud Visual which shows the commission paid to the Salesman. The report can be drilled down to answer following questions:

·         How are salespeople ranked by quarterly/yearly performance?

·         Which 5 salespeople should receive an award for annual sales?

Sales by the Representatives

Case Study 2.1.png

Case Study 2.2.png

Case Study – 3

     The story board created as below represents Budget quantity and Actual quantity sold by the Sales team. This shows the improvement of the sales. Also shows the top trades in 2011.

Business was interested to check on the Actual sales and forecasted sales for the year 2011.

SAP Lumira tool helps in sales forecasts to monitor and act on individual opportunities, more accurately forecast current and future period revenues and understand the drivers that distinguish won vs. lost deals. Users can use graphical dashboards to quickly access actual sales performance vs. Targets and sales management forecasts. Marketing users can analyze and lead progression through each stage of the sales cycle to quantify the effectiveness and revenue impact of marketing efforts.

                                   Case Study 3.png

In different perspectives, analysis of sales using various visualizations for the business are as below:

Report 1

To understand the Gross Sales and Net Sales, the Sales data analyzed on the different fiscal year/period. Looking at the below radar chart, I could conclude that the last 2 quarters of every year had better sales when compared to the quarter 1 and 2.

Gross Sales and Net Sales by Fiscal Period

Report 1.png

Report 2

Below 3D Chart represents the gross and net sales by year. Very intuitive placeholders are available for users to place the metrics and parameters. Here again the similar analysis but in a vertical bar charts.

Gross and Net Sales by Year

   Report 2.png
 

Report 3

This Map represents the Sales quantity By US regions. It is very clear from the below map, that the green areas are best performing regions in-terms of the sales quantity.

Regional Sales Quantity

Report 3.png

Report 4

A story board was created in order to bring out the Sales analysis at higher level from where the users can drill into the reports for the specifics.

This story board shows me various aspects as below:

·         Gross and Net sales for US regions

·         Gross sales and Invoice Price by US regions

·         Gross sales and  Net Sales by year

Complete Picture of the Gross and Net Sales for the Sales Analysis

Report 4.png

Report 5

This report gives the picture of net sales on Region level. Based on the interest, we can do a drill down analysis of the Georgia State using the drop down lists available on top of the screen.

Net Sales Analysis at State Regional Level

Report 6.png

Report 6

This report gives the picture of net sales on Region level. Based on the interest of region, we have done analysis of the Georgia State using the drop down lists available on the top of the screen.

Net Sales Analysis at City Level

Report 7.png

Report 7

This below combination chart shows, that the family of products called Plant Growth Regulators had high margin of sale. We can see that the vertical bars and the line at chart is having lot of deviation, with which i could identify the fact pictorially.

Report 8.png    

Report 8

This is the waterfall report which gives the picture of rebate for buying groups. The buying group with highest rebate is Astra, which makes my focus turn to the Astra buying Group.

                                    Report 9.png

To conclude with, an exhaustive analysis as done above, gives the users a self-driven analysis tool to visualize in their way and take decisions quickly. One can easily analyze the data and present the finding in various forms based on the audience.

I think a tool like this will give a lot of scope to the executive business users to do analysis without interference of an IT department.

Hope the above post helps to know what a self-service BI tool like Lumira can do.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Irshaad Bijan Adatia

    Sukumar,

    There’s a great amount of data being processed here, in a very simple to understand format!

    Exactly what we like to see from Lumira.

    Creating the visualizations in Lumira as you said only took “a few minutes”.
    How long did it take to setup the data to be consumed?

    Bijan

    (0) 

Leave a Reply