Lesson Summary

This explanation outlines how to effectively present and interpret a KPI dashboard for business metrics, focusing on the month of February 2021.

Key points for dashboard presentation:

• Use of color legend: Colors like green and pink are used to quickly indicate performance status:
  • Green means the KPI is on target (good).
  • Pink means the KPI is off target (bad).
• Example of February 2021 revenue:
  • Revenue tile is pink indicating performance is below target.
  • Actual revenue: $2.2 million, budgeted revenue: $2.4 million.
  • Revenue shows some growth compared to prior months ($2 million).
  • Two main references for evaluation: budget target and prior month performance.
• Other KPIs follow the same color concept:
  • Gross margin exceeded budget (51% vs 50%) but decreased slightly from prior months (55%), so tile is green.

Providing KPI Definitions and Details:

• Important to define KPIs clearly for reader understanding, e.g., customer churn defined as lost revenue divided by total revenue.
• For more complex KPIs, like DSO (Days Sales Outstanding), use hyperlinks in the Excel dashboard to link to detailed explanations including:
  • Definition: number of days to convert sales to cash.
  • Formula to calculate.
  • Interpretation and industry standards (e.g., 30–45 days normal range).
• Example: DSO target is 35 days, actual is 37 days, so tile is pink indicating off target.

Summary:

• Present KPIs with clear visual cues (color coding).
• Provide definitions and context to make dashboards easy to read.
• Use links for complex metrics to offer detailed explanations without cluttering the main dashboard.
• This approach helps readers quickly understand performance, target gaps, and metric meanings.