Explanation
A KPI (Key Performance Indicator) card displays an important number prominently.
Common KPIs
Total Sales
=SUM(SalesData[Sales])
Total Orders
=COUNTA(SalesData[Order ID])
Total Quantity
=SUM(SalesData[Qty])
Average Sale
=AVERAGE(SalesData[Sales])
KPI Card Design
Example:
┌─────────────────┐
│ TOTAL SALES │
│ ₹5,42,800 │
└─────────────────┘
Practice
Create four KPI cards:
- Total Sales
- Total Orders
- Total Quantity
- Average Sale