## Scan your portfolio for discount outliers

You set price lists and discount levels – larger accounts get larger discounts. But do they? We provide you with SQL queries to analyze sales and find outliers.

How to extract pricing insights from your transactional data? Here we explain, give examples and codes of well-known pricing analyses so that you can run it on your own environment as well.

You set price lists and discount levels – larger accounts get larger discounts. But do they? We provide you with SQL queries to analyze sales and find outliers.

How does profitability change even if the revenue and cost stay stable? Product (or customer) mix might be the answer. In this post we will explain what product mix is and how to calculate its… Read More »How to calculate product mix impact on profitability?

I rewrote this blog post using ChatGPT for the text and Magic Media (Canvas) for the featured image. The new post is accessible here. I downloaded the last 365 days of sales tickets from my… Read More »Inflation for you – is it time to change your supermarket?

We explain what a revenue bridge is, how it can be used, and how to prepare one on large invoice datasets using MSSQL.

Large accounts offer large revenue, but they leverage this position in negotiation and get large discounts as well. Where is the limit? How much discount does a key account merit? When you are running a… Read More »How much discount for a new key account?

Running a profitability analysis based on average price is quick and easy – but does it give the full picture? I explain why and how to compare average price with median price, and take insightful… Read More »Average vs Median Price – how to avoid the trap?

Calculating price realization at customer-SKU granularity becomes challenging as the invoice data grows larger. In this post we will explain how to run price realization analysis using SQL queries, so that you can calculate very… Read More »How to calculate price realization on large datasets?

I give practical examples of data analysis and share the code that performs these analyses. The analysis I share in these posts require a predefined data set. In this page, I share the sample data… Read More »Sample datasets for pricing analysis