Opportunity

Definition

Opportunity is the ability of a data model to deliver information at the moment when it can still influence a decision.

An opportunistic model is not only correct or consistent:
it is temporally relevant.

In Power BI, opportunity manifests when a metric arrives:

• before the event is consolidated,
• before the decision loses its effect,
• and before the analysis becomes merely explanatory.

👉 Late data = dead data, even if it is perfect.

Nature

Temporal, decisional, and operational.

Opportunity does not depend only on:

• data quality,
• nor on calculation precision,

but on the synchronization between the model and the business decision cycle.

A model can be:

• consistent,
• coherent,
• congruent,

and still not be opportunistic.

Function

To ensure that analysis:

• arrives on time,
• is positioned before the point of no return,
• and enables action, not just interpretation.

In Power BI, opportunity:

• connects analytics with operations,
• transforms dashboards into decision tools,
• avoids unnecessary post-mortem analysis.

Consequence

When opportunity exists:

• decisions are preventive, not reactive,
• analysis has real impact,
• users trust the model to act.

When it does not exist:

• the dashboard becomes historical,
• users “look” but do not decide,
• analytics loses strategic value.

Signals of Opportunity (✔️)

• KPIs are reviewed before the period closes.
• Alerts appear when intervention is still possible.
• Users act the same day they consult the dashboard.
• The model follows the operational rhythm of the business.

Signals of Lack of Opportunity (❌)

• Correct KPIs that arrive too late.
• Decisions based on “what already happened”.
• Dashboards used only for reporting.
• Phrases like: “If we had known earlier…”.

🔧 Samples — Opportunity in Power BI

🔹 Sample 1 — Operational Sales (❌ vs ✅)

Without opportunity (❌):
Daily sales calculated and published at month-end.

👉 Result:
they only explain the past.

With opportunity (✅):
Same-day sales updated hourly.
Compared against the daily target.

👉 Result:
managers can correct course the same day.

🔹 Sample 2 — Stock and Breakage

Without opportunity (❌):
Weekly stock-out report.

With opportunity (✅):
Power BI alert when projected stock drops below threshold.

👉 The model anticipates, it does not report.

🔹 Sample 3 — Correct metric, wrong moment

A KPI can be:

• well defined,
• well calculated,
• well visualized,

but if it is published after the key decision,
it loses all its value.

👉 Opportunity is independent of accuracy.

🔹 Sample 4 — Opportunity and frequency

Common mistake (❌):
Increasing refresh frequency without criteria.

Correct pattern (✅):
Aligning frequency with the decision cycle, not the technical cycle.

Example:

• Operations → high frequency.
• Strategy → low frequency.

🔹 Sample 5 — Anti-pattern vs Pattern

❌ Anti-pattern — Late analytics

• Correct data.
• Closed decisions.
• Explanatory use.

✅ Pattern — Timely analytics

• Sufficient data (not perfect).
• Open decisions.
• Operational use.

📌 Golden rule:
95% correct on time is better
than 100% correct too late.

Interactions with Other Properties

• Frequency → enables opportunity but does not guarantee it.
• Persistence → ensures continuity, not impact.
• Congruence → aligns intent, not timing.
• Opportunity → turns analysis into action.

Synthesis

Opportunity is not designed in DAX.
It is designed by understanding when the business decides.

An opportunistic model:

• does not arrive first,
• arrives just in time.