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