Sales Analysis ka matlab hai company ke sales data ko Excel mein calculate, compare aur analyze karke business ki performance ko samajhna.
Isme hum dekhte hain ki kaunsa product zyada sell hua, kis month mein sales zyada rahi, kis salesperson ne better performance di, aur kis location se kitni sales hui.
Simple Definition:
Sales data ko analyze karke sales performance, trends aur important business results identify karna Sales Analysis kehlata hai.
Sales Analysis ka main purpose hota hai:
Sales report mein generally ye information hoti hai:
| Field | Example |
|---|---|
| Date | 10-09-2026 |
| Salesperson | Rahul |
| Product | Laptop |
| Category | Electronics |
| City | Delhi |
| Quantity | 5 |
| Unit Price | ₹50,000 |
| Sales Amount | ₹2,50,000 |
Agar Sales Amount column G mein hai:
=SUM(G2:G20)Isse selected records ki Total Sales calculate ho jayegi.
Example:
| Product | Sales |
|---|---|
| Laptop | ₹1,20,000 |
| Mobile | ₹90,000 |
| Tablet | ₹60,000 |
Total Sales:
₹2,70,000
Product ke according sales compare ki ja sakti hai.
| Product | Sales |
|---|---|
| Laptop | ₹1,20,000 |
| Mobile | ₹90,000 |
| Tablet | ₹60,000 |
| Printer | ₹40,000 |
Isse identify kiya ja sakta hai:
Column Chart is comparison ke liye useful hai.
Monthly sales ko compare karke sales trend identify kiya ja sakta hai.
| Month | Sales |
|---|---|
| January | ₹80,000 |
| February | ₹95,000 |
| March | ₹1,10,000 |
| April | ₹1,25,000 |
Is data se pata chal sakta hai ki sales increase ho rahi hai ya decrease.
Line Chart month-wise trend dikhane ke liye useful hai.
Company ye analyze kar sakti hai ki different salespersons ne kitni sales generate ki.
| Salesperson | Sales |
|---|---|
| Rahul | ₹1,50,000 |
| Aman | ₹1,20,000 |
| Priya | ₹1,80,000 |
| Neha | ₹95,000 |
Isse salesperson performance compare ki ja sakti hai.
Sales ko location ke according bhi analyze kiya ja sakta hai.
| City | Sales |
|---|---|
| Delhi | ₹2,00,000 |
| Rohini | ₹1,20,000 |
| Pitampura | ₹90,000 |
| Nangloi | ₹70,000 |
Isse business ko different locations ki sales performance samajhne mein help milti hai.
Excel mein MAX() aur MIN() functions ka use kiya ja sakta hai.
=MAX(G2:G20)=MIN(G2:G20)=AVERAGE(G2:G20)=SUM(G2:G20)Sales Analysis mein Actual Sales ko Target Sales ke saath compare kiya ja sakta hai.
| Month | Target | Actual | Difference |
|---|---|---|---|
| Jan | ₹1,00,000 | ₹90,000 | -₹10,000 |
| Feb | ₹1,00,000 | ₹1,10,000 | +₹10,000 |
| Mar | ₹1,20,000 | ₹1,30,000 | +₹10,000 |
Difference:
=Actual-TargetIsse pata chalta hai ki target achieve hua ya nahi.
Do periods ki sales compare karke growth percentage calculate ki ja sakti hai.
=(New Sales-Old Sales)/Old Sales*100Example:
Old Sales = ₹1,00,000
New Sales = ₹1,20,000
Result:
20% Sales Growth
Large sales data ke liye Pivot Table bahut useful hai.
Example:
Rows → Product
Columns → Month
Values → Sum of Sales
Isse product aur month dono ke according sales analyze ki ja sakti hai.
Aage Slicer add karke:
ke according interactive filtering bhi ki ja sakti hai.
| Chart | Use |
|---|---|
| Column Chart | Product-wise sales comparison |
| Bar Chart | Salesperson ranking |
| Line Chart | Monthly sales trend |
| Pie Chart | Product/category sales share |
| Combination Chart | Sales + Profit/Target |
Ek professional Sales Analysis report mein ye sections ho sakte hain:
SALES ANALYSIS REPORT
Total Sales ₹5,00,000
Total Orders 250
Average Sales ₹2,000
Highest Sale ₹75,000
----------------------------------
Monthly Sales Chart
Product-wise Sales
Salesperson Performance
City-wise Sales
Pivot Table + SlicersIs type ki report management ko sales performance quickly samajhne mein help karti hai.
Sales Analysis ka use:
Leave a Reply