Sales Analysis
The Sales Analysis model is a sales-oriented model designed to give insights into a company’s revenue stream. Several KPIs are available such as sales volumes, sales margin and profitability, credits, number of orders, and order lines. The model provides analysis from different perspectives to give you a deeper understanding of factors driving the business.
You can analyze the information in the Sales Analysis model from different perspectives.
Customer perspective:
- Sales and sales growth per customer and per customer group
- Comparison of performance among customer groups
- Discounts, costs, and credits explaining the profitability
- Shipped volumes expressed as gross or net weight, units, and other information
Product perspective:
- Products with exceptional performance and growth
- Products selling below expected levels for profitability
- Best-selling products and product performance from a profitability perspective
- Products that have decreased most in sales and products that should be phased out
- Products with exceptional levels of discounts and credits that erode the margins
Sales organization perspective:
- Top sales performers
- Top sales organization for controlling discount
- Sales people who improved the most, as compared to last year
- Sales people who markedly reduced the profitability by manually reducing prices or generating credit notes
You can perform analyses on several dimensions such as on the customer, product, sales organization, and supply chain (warehouse) dimensions. The facts in this model can be analyzed by these dates:
- Invoice Date
- Entry Date
- Order Date
- Delivery Date
Source information
The Sales Analysis model is driven by invoice sales statistics captured in the OSBSTD table. To populate this table with transactions, you must set the order type sales statistics.
The model provides analysis for these order types:
- Customer Orders (ORIG = 0)
- Service Orders (ORIG = 1)
- Project Orders (ORIG = 2)
- Maintenance Customer Orders (ORIG = 7)
- POS Transactions (ORIG = 8)