Sales Analytics Performance Dashboard
Q1 2024 Revenue Drivers, Gaps and Actions
How can a business access their sales transaction data across different different products, categories and regions?
Executive Summary
This analysis examines $112,600 in sales revenue across 50 records from January–March 2024. The central business question is: where is performance concentrated, and which levers can lift overall results? Michael Brown generated the highest absolute revenue ($39,660), while Emily Davis delivered the highest revenue per unit ($387). East and North regions together account for more than 60% of revenue. Electronics products drive 81.8% of sales value; Laptops alone contribute ~$46,200. Headphones lead unit volume (68 units). Recommended actions:
(1) Formalise knowledge transfer from top performers (Brown on volume, Davis on value mix),
(2) Test targeted support for the South region and lower-performing salespeople, and
(3) Protect and expand the Electronics and Laptop franchise while reviewing the long tail of low-unit products.
All conclusions are based solely on the supplied aggregates; sample size (50 records) limits statistical confidence for day-of-week or monthly trends.
Business Context and Objectives Understanding how revenue is distributed across regions, salespeople, product categories and time periods is essential for resource allocation, coaching priorities and assortment decisions. With only one quarter of data and 50 records, the analysis prioritises descriptive insight and relative ranking over causal claims.
Questions the analysis aims to answer:
• Which regions contribute the most and least revenue?
• Who are the top-performing salespeople by absolute revenue and by revenue per unit?
• Which products and categories drive revenue and unit volume?
• How do average unit prices vary, and how does that relate to revenue contribution?
What patterns appear in monthly and day-of-week sales (subject to data completeness)?
• Where should leadership focus coaching, territory support or assortment review?
Data Overview
The analysis is based on aggregated pivot-table outputs derived from transactional sales data. Key characteristics observed in the source tables:
- Period covered: January–March 2024 (labelled Jan-Mar2024).
- Record count: 50 records (explicitly noted in source).
- Total revenue: $112,600. • Total units sold: 420.
- Dimensions present: Region (East, North, West, South), Salesperson
(5 individuals), Product (10 items), Product Category (Electronics, Furniture), Month, Day of week.
Metrics: Sum of Total Sales (revenue), Sum of Units Sold, Average of Unit Price, Revenue per Unit (derived).
Limitations: Only aggregate results were provided; raw transaction-level data, customer identifiers, order counts, costs and margins are not available. Some secondary totals show minor arithmetic discrepancies
Methodology
The work consists of descriptive analysis of pre-calculated pivot tables. No additional statistical modelling was performed. Cleaning and preparation Source tables were transcribed from provided images. Arithmetic consistency of grand totals was checked. Where salesperson revenue figures and unit counts implied a different total for Michael Brown ($39,660 rather than a lower transcribed value), the figure consistent with both the grand total of $112,600 and the stated revenue-per-unit was adopted. Desk product revenue was reconciled toward $11,000 to align with stated average unit price of $200 and unit volume of 55. Key metric definitions
- Total Revenue (Sum of Total Sales): Aggregate sales value for the period or segment. Primary success metric.
- Units Sold: Count of individual product units sold. • Average Unit Price: Mean selling price per unit for a product (provided directly).
- Revenue per Unit: Total revenue of a salesperson (or segment) divided by units sold by that salesperson. Measures value intensity of the mix sold.
- Category share: Product category revenue as a percentage of total revenue. Comparisons are relative rankings and percentage shares. No external benchmarks or prior-year figures were supplied. Visualizations referenced are the source pivot tables themselves; recommended presentation charts would be simple bar and share-of-total charts.
Dashboard
Key Findings
Regional Performance Takeaway: East and North together generate more than 60% of revenue; South is the clear lagging region.
East leads by a narrow margin over North. South contributes the least revenue. Unit-sold-by-region totals (East 102, North 100, South 93, West 125) suggest West moves the most units yet ranks third in revenue, implying a lower-value mix. Evidence is aggregate only; territory size, salesperson coverage and local demand are unknown.
Salesperson Performance Takeaway:
Michael Brown leads absolute revenue; Emily Davis leads revenue intensity (value per unit)
Michael Brown accounts for approximately 35% of total revenue and the highest unit volume (131). Emily Davis, with roughly half the units of Brown, achieves the highest revenue per unit, indicating a more premium product mix. John Doe generates solid revenue through volume but the lowest revenue per unit. Chris Taylor and Jane Smith trail in absolute contribution. Source note explicitly states: “Emily Davis has the highest revenue per unit, while Michael Brown is identified as the top performance amongst the salesperson.” With only five salespeople and 50 records, individual rankings are directionally useful but sensitive to a few large deals.
Product and Category Performance Takeaway:
Electronics (especially Laptops) dominate revenue; Headphones lead unit volume; Printer is the lowest-volume item. Category split: Electronics 81.83% of revenue; Furniture 18.17%. This concentration is a strength if Electronics demand is stable, and a risk if it softens.
Desk revenue shown as $11,000 to align with stated average unit price10,100 (minor discrepancy). Highest unit volume: Headphones (68). Lowest: Printer (19). Laptop is both high-price and high-revenue, making it the clear top product by value. Low-price accessories (Keyboard, Headphones) move volume but contribute modest revenue. 5.4 Temporal Patterns (Monthly and Daily) Monthly and daily breakdowns appear in the source tables but contain incomplete or inconsistent figures relative to the $112,600 grand total. February appears markedly stronger than January in the partial monthly view. Day-of-week figures likewise do not fully reconcile in the provided images. Consequently, no firm ranking of months or weekdays is stated here. Any month based recommendation should be treated as a proposed test pending complete daily/monthly extracts.
Recommendations
Leverage top-performer practices: Identify what Brown and Davis do differently in product mix, customer targeting and deal management. Turn these practices into sales playbooks and share them across the team.
Get Christian Iyayi’s stories in your inbox
Join Medium for free to get updates from this writer.
Strengthen South region performance: Focus coaching on pipeline quality, territory coverage and product mix, particularly for Taylor and Smith. Set clear 90-day targets to improve revenue and units sold.
Protect the Electronics/Laptop franchise: Electronics contributes 81.8% of total revenue, with Laptops generating about $46,200. Protect this core revenue while exploring opportunities to strengthen Furniture and reduce concentration risk.
Review low-volume products: Assess Printers, Keyboards and other lower-volume products using margin, cost and demand data. Decide whether each should be retained, promoted or gradually phased down.
Complete and reconcile sales data: Ensure monthly and daily figures reconcile fully to the $112,600 total and add order-count data where available. Use the completed dataset to support more reliable time and order-level analysis.
