Power BI Data Quality Scorecard

Problem

What needed to change

Governance stakeholders needed an interim way to monitor data quality across critical digital-banking and card platforms before a permanent governance tool was ready.

Context / Constraints

What shaped the work

The work sat inside a governance program where the reporting layer had to bridge a temporary gap before a permanent tool rollout.

• Strict security requirements and enterprise infrastructure constraints shaped how the scorecard could connect to source systems.
• The interim solution still had to remain maintainable until the permanent governance platform was in place.

Approach

How the work was handled

Designed and delivered a Power BI data quality scorecard with Azure Databricks-based monthly refresh support, working with governance stakeholders and IT teams to surface completeness, accuracy, and timeliness in one governed view.

Outcome

What changed in practice

The interim scorecard was delivered on schedule, approved by stakeholders, refreshed automatically each month, and handed over with documentation so the client team could maintain it until the longer-term governance platform was in place.

• Delivered a governed Power BI scorecard for completeness, accuracy, and timeliness.
• Automated the monthly refresh workflow through Azure Databricks.
• Supported documentation and transition to the governance team for ongoing maintenance.

My Role

Where I contributed most

Power BI scorecard design, delivery, and Databricks refresh coordination

Trade-offs / Lessons

Choices, constraints, and what mattered

• Used Power BI plus Databricks processing to bridge the gap before the permanent governance tool.
• Worked within secure enterprise infrastructure constraints rather than a standalone reporting setup.
• Structured the solution for handover so the client team could maintain it after delivery.