High Revenue Does Not Always Mean High Profitability
Traditional reports usually rank customers and products by sales value or gross margin. This view can be overly simplistic because it does not account for the full cost of customer service, logistics, complaints, financing, and sales activities. A customer purchasing $1 million worth of goods may be less profitable than one generating $300,000 in revenue if the larger customer requires frequent deliveries, custom production, and extended payment terms. Similarly, a product with a high list margin may lose its profitability once promotions, waste, returns, and inventory carrying costs are taken into account.
Research describing the so-called Kanthal effect showed that, in the company analyzed, just 40% of customers generated approximately 250% of total profit, while the remaining group consumed a substantial portion of the value created. Profitability analysis should therefore answer a different question. Instead of asking, “How much did we sell?” companies should ask, “How much was left after serving a specific customer and delivering a specific product?”
Cost-to-Serve: The Expenses Hidden by Averages
A reliable profitability model should be built around cost-to-serve, meaning the actual cost of delivering a product and managing the customer relationship. It includes expenses that are often recorded collectively in accounting systems, making them difficult to assign to individual transactions. In e-commerce, fulfillment alone may account for 12–20% of revenue, demonstrating how quickly logistics can turn an apparently attractive sale into an unprofitable one.
Depending on the business model, the analysis should include:
- discounts, bonuses, promotions, and trade fees,
- transportation, order picking, warehousing, and expedited deliveries,
- returns, complaints, waste, and production rework,
- time spent by sales representatives, consultants, and customer service teams,
- the cost of financing accounts receivable and the risk of late payments.
Only after these expenses have been assigned to specific customers, products, channels, and orders can the company calculate contribution margin, profit after service costs, and net profitability
How to Build a Profitability Model in Power BI
Microsoft Power BI can combine data from ERP, CRM, warehouse management, manufacturing, e-commerce, help desk, and financial systems within a single semantic model. The key is to establish consistent identifiers for customers, products, orders, and invoices so that costs can be analyzed in the same context as revenue
The next step is to create DAX measures for net revenue, cost of goods sold, gross margin, cost-to-serve, contribution margin, and profit margin percentage. These measures respond dynamically to filters, allowing managers to move within seconds from company-wide results to a specific region, customer, SKU, or invoice.
Microsoft provides a Customer Profitability sample report in which results can be analyzed by customer, product, manager, and gross margin. In a real-world implementation, the model should also include rules for allocating indirect costs. These costs may be distributed based on the number of deliveries, hours worked, warehouse space used, or the number of customer service tickets.
How Does the Report Detect Hidden Losses?
A well-designed dashboard should offer more than a profitability table. It should identify the source of the problem and allow users to drill down to the level at which a business decision can be made. A customer map based on revenue and margin helps distinguish strategic relationships from high-revenue customers that generate weak financial results.
A customer-product matrix reveals combinations that generate losses despite showing a positive margin based on list prices. A decomposition tree can break down a profit decline by channel, region, category, sales representative, and delivery type, supporting root cause analysis. Anomaly detection can help identify sudden increases in costs, returns, or discounts before they affect the results of an entire quarter. Users can then apply drill-through functionality to move directly from a summary view to the transactions responsible for the variance.
KPIs That Should Be Included in the Report
The set of indicators should be tailored to the industry, but revenue and gross margin percentage alone are not sufficient for effective portfolio management. Companies should monitor gross margin in monetary terms, contribution margin, service cost per customer, order fulfillment cost, the share of discounts, returns, and complaints, as well as average payment terms.
For products, important indicators also include inventory turnover, inventory carrying costs, write-offs, waste, and profitability after promotions. The report should display trends, comparisons with the budget, and changes from the previous reporting period. Pareto analysis is particularly useful because it reveals which customers or SKUs generate profit and which reduce it.
It is also worth adding what-if simulations. These allow executives to evaluate how financial results would change following an adjustment to prices, minimum order quantities, discount levels, or delivery costs.
From Diagnosis to Business Decisions
The goal of profitability analysis is not to automatically eliminate unprofitable customers and products. A temporary loss may result from an investment in a customer relationship, expansion into a new market, or the sale of a product that creates opportunities for more profitable services. Power BI helps distinguish these situations from persistent problems by tracking performance over time and throughout the customer lifecycle.
A company may then decide to increase prices, revise its discount policy, introduce a minimum order value, limit expedited deliveries, or move customer service to a lower-cost channel. Within the product portfolio, possible actions may include reducing the number of variants, renegotiating purchasing costs, changing packaging, or discontinuing an SKU.
EY describes the example of an organization that eliminated 75% of SKUs generating negative returns and reduced operational complexity by 35% as a result. The greatest value of the report is therefore a shared, up-to-date view of profitability that enables sales, finance, logistics, and executive teams to make consistent decisions.
Power BI Turns Profitability Analysis into an Ongoing Management Process
Hidden losses rarely result from one exceptionally poor transaction. They usually accumulate through hundreds of discounts, additional deliveries, returns, small production batches, and hours of work that have never been linked to a specific customer or product.
Power BI organizes this data and transforms profitability analysis from a quarterly exercise into an ongoing management process. This requires an accurate cost model, agreed-upon KPI definitions, and data covering the entire transaction lifecycle.
Once these elements are in place, the company can detect margin erosion earlier, test corrective scenarios more quickly, and deliberately develop the most valuable areas of the business. As a result, sales growth is no longer treated as an end in itself. Instead, it becomes a tool for building sustainable and measurable profit.