Blog · AI and self-service analytics
See revenue, margin and budget questions answered from a small business workbook. Each example identifies the required fields, works the figures and shows the checks and decisions they support.
Self service analytics examples include a sales manager finding offsetting revenue variances, a finance partner checking gross margin and a procurement lead measuring a cost change. Each question can start with an ordinary business workbook. The useful result includes the inputs, the arithmetic and the check that proves the total.
The category itself is explained in self-service analytics and AI analytics, with the broader approach covered under AI analytics. Here, the focus is a set of business questions answered from the same records, followed by a variation that changes one input.
Consider a fictional US distributor reviewing a closed month. Finance supplies actual and budget net revenue and cost of goods sold by product line. All amounts are USD, and both actuals and budget use the same product mapping and cost policy.
| Product line | Actual revenue (USD) | Actual COGS (USD) | Budget revenue (USD) | Budget COGS (USD) |
|---|---|---|---|---|
| Core | 120,000 | 78,000 | 110,000 | 73,700 |
| Specialty | 80,000 | 44,000 | 90,000 | 49,500 |
| Total | 200,000 | 122,000 | 200,000 | 123,200 |
The actual columns tie to the closed ledger. The budget columns tie to the approved budget version. That agreement matters before anyone asks for an explanation: a revised forecast is not the original budget, and a sales-order export is not necessarily recognized revenue.
The SEC's financial statements guide explains that subtracting cost of sales from net revenue gives gross profit. That is the financial relationship used below; the company's own policy defines which cost accounts belong in COGS.
The sales manager asks: “We met the total revenue budget. Which product lines were ahead or behind?” The required fields are product line, actual net revenue and budget net revenue for the same month.
Revenue variance = Actual revenue - Budget revenue
Revenue variance percentage = Revenue variance / Budget revenue
| Product line | Actual revenue (USD) | Budget revenue (USD) | Variance (USD) | Variance |
|---|---|---|---|---|
| Core | 120,000 | 110,000 | 10,000 | 9.1% |
| Specialty | 80,000 | 90,000 | -10,000 | -11.1% |
| Total | 200,000 | 200,000 | 0 | 0.0% |
Core is 120,000 - 110,000 = $10,000 ahead. Specialty is 80,000 - 90,000 = $10,000 behind. The variances cancel: 10,000 - 10,000 = $0, matching total actual revenue less total budget revenue.
Percentages throughout the examples are rounded to one decimal place after calculation. Core's variance percentage is 10,000 / 110,000 = 9.1%; Specialty's is -10,000 / 90,000 = -11.1%. The company percentage comes from the company totals, rather than an average of the line percentages.
This output directs a review of Specialty's customer orders and Core's capacity commitments. It does not establish why either line moved. The sales manager owns those follow-up questions; finance owns the budget baseline.
The finance partner asks a different question of the same workbook: “What happened to gross profit and margin?” This requires matched COGS as well as revenue.
Gross profit = Net revenue - COGS
Gross margin = Gross profit / Net revenue
| Product line | Actual gross profit (USD) | Actual margin | Budget gross profit (USD) | Budget margin |
|---|---|---|---|---|
| Core | 42,000 | 35.0% | 36,300 | 33.0% |
| Specialty | 36,000 | 45.0% | 40,500 | 45.0% |
| Total | 78,000 | 39.0% | 76,800 | 38.4% |
Core's actual gross profit is 120,000 - 78,000 = $42,000. Specialty's is 80,000 - 44,000 = $36,000. Together they give $78,000, which also equals 200,000 - 122,000.
The budget check is 36,300 + 40,500 = $76,800, equal to 200,000 - 123,200. Actual gross profit exceeds budget by 78,000 - 76,800 = $1,200. Actual margin is 78,000 / 200,000 = 39.0%, against 76,800 / 200,000 = 38.4%: a difference of 0.6 percentage points.
The result supports a more precise discussion than “sales met plan.” Core earned a higher margin than budget, while Specialty kept its budget margin on less revenue. The existing gross profit margin guide covers cost definitions and weighted totals in more depth.
The procurement lead now asks: “What if Specialty's COGS were $48,000 instead of $44,000, with everything else unchanged?” This is an explicit sensitivity calculation, not a prediction.
| Measure | Original case | Higher Specialty cost case |
|---|---|---|
| Specialty revenue (USD) | 80,000 | 80,000 |
| Specialty COGS (USD) | 44,000 | 48,000 |
| Specialty gross profit (USD) | 36,000 | 32,000 |
| Specialty margin | 45.0% | 40.0% |
| Company COGS (USD) | 122,000 | 126,000 |
| Company gross profit (USD) | 78,000 | 74,000 |
| Company margin | 39.0% | 37.0% |
The new Specialty profit is 80,000 - 48,000 = $32,000, and its margin is 32,000 / 80,000 = 40.0%. Company COGS becomes 78,000 + 48,000 = $126,000. Company profit is 200,000 - 126,000 = $74,000, or 37.0% of revenue.
The proof is the unchanged revenue and the isolated cost movement: 48,000 - 44,000 = $4,000 of additional cost reduces profit by the same $4,000. Company margin falls by 2.0 percentage points. Procurement can use that exposure in a supplier discussion without assuming the increase has already occurred.
Place the original workbook's columns in A through E, with Core on row 2 and Specialty on row 3. Calculate Core's revenue variance:
=B2-D2
Calculate Core's revenue variance percentage:
=IF(D2=0,NA(),(B2-D2)/D2)
Calculate Core's actual gross profit:
=B2-C2
Calculate Core's actual gross margin:
=IF(B2=0,NA(),(B2-C2)/B2)
Calculate company gross margin from the totals:
=(SUM(B2:B3)-SUM(C2:C3))/SUM(B2:B3)
If the source contains transaction detail, group eligible amounts before applying these calculations. In Excel, SUMIFS adds values meeting multiple criteria, such as the selected month and product line. Preserve the detail so another reviewer can reproduce each group total.
Covirage is not affiliated with Microsoft, the provider of Excel.
These tables could inform a recurring BI dashboard, but they are already useful as checked answers. Natural language analytics explains how a plain-English question can reach this kind of calculation and evidence.
Bring the actual and budget workbook with product labels, net revenue and matched cost columns. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own export.
See self-service analytics for the supporting workflow.
A sales manager can compare actual revenue with budget by product line using an approved workbook. The analysis should show dollar variances, percentage variances and a total that reconciles. That reveals offsetting line movements even when the company meets its overall target.
Use net revenue and cost of goods sold for the same records and period, with consistent cost definitions. Product or customer identifiers provide useful groupings. A revenue export without matched costs can answer sales questions but cannot establish gross margin.
No. A checked table can answer a specific business question. A recurring dashboard can present the same measures repeatedly, but it still needs agreed definitions and reconciled inputs. Choose the presentation after deciding what action the result should support.
The measure owner approves definitions and control totals. The business user checks that the file, period and grouping match the question. Finance usually validates financial measures, while the relevant operational owner confirms that the interpretation fits the underlying business activity.