Ravindra BagaleCourses & study guides मराठी Track your progress

22. KPI in All Industries

By Last updated:

Friends, in this module we look at KPIs (Key Performance Indicators: the numbers that actually change a decision) in many industries. In an interview nobody asks only "what is AOV". They ask where the number came from, who uses it, and what to do next. For each industry you get fictional rows, the KPI table, the Excel formulas, and the result you should see.

What you will learn in this module

  • What a KPI is, and how it differs from a vanity metric
  • The KPIs students meet in interviews and on the job, industry by industry
  • The Excel way to calculate them: a Table, SUM ÷ SUM totals, calculated columns and SUMIFS
  • What a manager in Pune or Nashik would do after seeing the number

Live story: Same Excel, new industry

Suppose your next client is a hospital, a bank or a school, not a grocery app. The KPI names change. The Excel method does not: put the rows in a Table, divide total by total, add calculated columns for each row, and use SUMIFS for one city. Every section below follows that pattern on six fictional rows.

All numbers in this story are fictional practice data.

Fictional sample data

Every number in this module is fictional sample data for class. It is not a result of Blinkit, Amazon, any bank, hospital, college, factory or government office. Do not quote these figures as a real company result in an interview. Say "in my practice file".

Concepts in this chapter

  1. 22.1How to Read a KPI
  2. 22.2Retail and Quick Commerce
  3. 22.3E-commerce
  4. 22.4Sales
  5. 22.5Finance and Accounting
  6. 22.6Banking
  7. 22.7Insurance
  8. 22.8Healthcare
  9. 22.9Pharma
  10. 22.10Manufacturing
  11. 22.11Inventory and Supply Chain
  12. 22.12Logistics
  13. 22.13HR
  14. 22.14Marketing and Digital Ads
  15. 22.15Education
  16. 22.16Hospitality
  17. 22.17Real Estate
  18. 22.18Telecom
  19. 22.19IT Services
  20. 22.20Government and NGO

The chapter recap is at the end of the last concept page.

Quick revision cards

Quick revision

Revise this chapter in two minutes. Save the cards on your phone or download them as PNG files. All names and numbers are made up for practice.

Revision card: KPI formulas. Covers Average order value; Conversion rate; Gross margin %; Occupancy %; ROAS; On-time %. With a photo of Ravindra Bagale and a short tip.
Card 1 of 2: KPI formulas · Download PNG
Revision card: Reading a KPI: target, direction and rates. Example data table with Pune against its target: 10.0% above target; Kolhapur against its target: −10.0%; Compare fairly with a rate: Kolhapur 8.0%, the better rate.
Card 2 of 2: Reading a KPI: target, direction and rates · Download PNG

More cards for every chapter: Ravi Sir's Cards.