Showing posts with label Revenue Analysis. Show all posts
Showing posts with label Revenue Analysis. Show all posts

Saturday, June 20, 2026

Revenue Analysis

 

1. Calculate Total Revenue

SELECT SUM(Amount)
FROM Orders;

2. Revenue by Month

SELECT YEAR(OrderDate),
MONTH(OrderDate),
SUM(Amount)
FROM Orders
GROUP BY YEAR(OrderDate),
MONTH(OrderDate);

3. Revenue by Year

SELECT YEAR(OrderDate),
SUM(Amount)
FROM Orders
GROUP BY YEAR(OrderDate);

4. Revenue by Customer

SELECT CustomerID,
SUM(Amount)
FROM Orders
GROUP BY CustomerID;

5. Revenue by Product

SELECT ProductID,
SUM(Amount)
FROM Sales
GROUP BY ProductID;

6. Top 10 Customers by Revenue

SELECT TOP 10
CustomerID,
SUM(Amount) Revenue
FROM Orders
GROUP BY CustomerID
ORDER BY Revenue DESC;

7. Bottom 10 Customers

SELECT TOP 10
CustomerID,
SUM(Amount)
FROM Orders
GROUP BY CustomerID
ORDER BY SUM(Amount);

8. Top Product by Revenue

SELECT TOP 1
ProductID,
SUM(Amount)
FROM Sales
GROUP BY ProductID
ORDER BY SUM(Amount) DESC;

9. Revenue Contribution %

SELECT CustomerID,
SUM(Amount)*100.0/
SUM(SUM(Amount)) OVER()
RevenuePct
FROM Orders
GROUP BY CustomerID;

10. Pareto Analysis (80/20)

Find customers contributing 80% revenue.

Uses:

SUM() OVER()
Running Total