The business wants a KPI, but the data needed to calculate it is not available. What is your approach?

< 1 min read

First, I clarify the exact definition of the KPI and understand why the business needs it.
Then I identify what specific data elements are required to calculate the KPI.
I check existing systems or databases to confirm whether the data truly does not exist or is stored differently.
If the data is unavailable, I discuss alternative proxy metrics that can approximate the KPI.
In one project, customer satisfaction score was unavailable, so we used complaint rate as a temporary indicator.
I also discuss with technical teams about capturing the required data in future system updates.
Meanwhile, I clearly communicate the limitation and impact to stakeholders.
This ensures transparency while planning a long-term solution for accurate KPI tracking.

Power BI Essentials