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 – 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 – 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.
In different perspectives, analysis of sales using various visualizations for the business are as below:
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
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
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
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
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
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
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.
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.
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.