OLAP - Frequency, Top Performers, and Trends
The OLAP - Frequency, Top Performers, and Trends dashboard provides a detailed view of sales activity frequency, commercial concentration, and transaction efficiency across sales representatives, customers, products, and invoices. It helps executive and operational leaders evaluate revenue productivity, customer engagement, invoice-level performance, and ordering trends.
Benefits of this dashboard
- Analyze sales activity intensity: Monitors how frequently sales transactions occur across representatives, customers, and products.
- Assess revenue productivity: Evaluates how effectively customers and invoices convert into net sales.
- Identify top performers: Highlights the most active sales reps, customers, and products by order frequency to guide incentives and account prioritization.
- Monitor transaction efficiency: Provides visibility into average invoice value and revenue per customer to strengthen pricing, bundling, and sales strategy decisions.
- Manage commercial concentration risk: Identifies dependency on high‑frequency customers, products, or representatives to support diversification and risk‑mitigation strategies.
Key performance indicators
| KPI | Description |
|---|---|
| Net Sales Current Year | Total recognized sales revenue for the selected fiscal period in the current year. Higher values indicate stronger commercial performance, while lower values indicate reduced sales activity. |
| Net Sales Last Year | Total recognized sales revenue for the equivalent fiscal period in the prior year. Provides a baseline for year-over-year comparison. |
| Customers This Year | Number of distinct customers generating sales in the selected fiscal period. Higher values indicate broader market coverage, while lower values indicate greater concentration or contraction. |
| Net Sales Per Customer | Average revenue generated per active customer in the current year. Higher values indicate stronger customer monetization, while lower values indicate lower revenue contribution per customer. |
| Invoices This Year | Number of sales invoices issued in the current fiscal period. Higher values indicate increased transaction volume, while lower values indicate reduced throughput. |
| Net Sales Per Invoice | Average revenue per invoice issued in the current year. Higher values indicate larger average deal sizes, while lower values indicate smaller transactions or more low-value orders. |
Example dashboard
Filters
Use the filtering panel at the top of the dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
- Year
- Period
- Company
- Site
- Branch
- Product Category