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

27. 20 Industry Projects

By Last updated:

← All Excel dashboards

Friends, this module is where everything comes together. Twenty industries, one pattern: a Table, a calculated column, KPI formulas, a PivotTable by City, a chart and a one-page dashboard. Every project shows the expected numbers so you can check your work.

What you will learn in this module

  • Turn a short business brief into a Table with calculated columns
  • Write KPI formulas with SUM, SUMIFS, COUNTIF, AVERAGEIFS and ratios of sums
  • Summarise by City with a PivotTable and check it against the expected table
  • Add a PivotChart and a slicer and arrange a one-page dashboard
  • Use the practice template and guide for each industry

Live story: Twenty jobs, one method

Suppose Salman is preparing for analyst interviews. Each interviewer asks about a different industry: banking, hotels, telecom. Because he has built the same Table → KPI → PivotTable → dashboard pattern twenty times, he answers each case calmly and shows a working file.

All numbers in this story are fictional practice data.

Fictional practice data

Every name, number and company detail in this module is made up for class. It is not the data of Blinkit, Amazon or any real firm.

Templates and guides. Each project links a practice template (/excel/templates/<Name>_Template.xlsx) and a step-by-step template guide (/guides/excel-template-<name>.html). These files are published separately; if one is not available yet, build the project from the table on this page. Ten projects also link a related ready-made industry dashboard.

Concepts in this chapter

  1. 27.1Retail and Quick Commerce: City Sales and On-Time Delivery
  2. 27.2E-commerce: Gross Sales, Returns and Net Sales
  3. 27.3Sales: Target vs Actual by Sales Rep
  4. 27.4Finance and Accounting: Budget vs Actual Variance
  5. 27.5Banking: Loan Book and NPA Tracker
  6. 27.6Insurance: Premium, Claims and Loss Ratio
  7. 27.7Healthcare: Hospital Revenue and Length of Stay
  8. 27.8Pharma: Stock Value and Near-Expiry Batches
  9. 27.9Manufacturing: Production Attainment and Rejects
  10. 27.10Inventory and Supply Chain: Days of Cover and Reorder List
  11. 27.11Logistics: On-Time Delivery by Route
  12. 27.12HR: Headcount, Attrition and Salary
  13. 27.13Marketing and Digital Ads: Campaign ROAS and Cost per Order
  14. 27.14Education: Pass Rate, Scores and Attendance
  15. 27.15Hospitality: Occupancy, ADR and RevPAR
  16. 27.16Restaurants: Spend per Cover and Food Cost
  17. 27.17Real Estate: Units Sold and Price per Square Foot
  18. 27.18Telecom: Churn, ARPU and Data Usage
  19. 27.19IT Services: Utilisation and Billing
  20. 27.20Government and NGO: Fund Utilisation and Cost per Beneficiary

Review and practice

  1. ★Practice and Answer Key: Cloud Kitchen Weekly Report

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