Synthetic exampleBuild-guide ready

Compliance & Assurance Executive Dashboard

Premium web preview of a Power BI-reproducible assurance dashboard for control maturity, action ownership, risk findings, and data-quality confidence.

Last refreshed

31 Dec 2024

Dataset

Synthetic 2024

PBIX

PBIX pending

Directorate

All directorates

Risk level

All risk levels

Period

Calendar year 2024

Action status

Open + in progress

Control area

All controls

Compliance score

Risk

Composite score from control maturity, scaled to 100.

Open actions

Watch

Actions not closed at synthetic snapshot.

Overdue actions

Risk

55.9% of open actions.

High-risk findings

Risk

High or critical unresolved findings.

Control maturity

Watch

3.2

Average maturity across assessed controls.

Data quality issues

Risk

Open issues affecting reporting confidence.

12-month executive score

Compliance Trend

070809101112

Open vs overdue workload

Assurance Actions by Directorate

Finance & Treasury14

Compliance & Assurance13

Risk Management11

Human Resources6

Corporate Operations5

Technology Services4

Open Overdue

Directorate by control area

Control Maturity Matrix

Directorate	Financial Reporting	Access Control	Data Quality	Change Management	Vendor Management	Regulatory Compliance
Corporate Operations	2.0	3.0	4.0	5.0	1.0	5.0
Finance & Treasury	5.0	3.0	2.0	5.0	5.0	5.0
Technology Services	3.0	1.0	2.0	2.0	5.0	5.0
Human Resources	1.0	5.0	4.0	3.0	4.0	2.0
Compliance & Assurance	2.0	1.0	1.0	5.0	4.0	2.0
Risk Management	2.0	1.0	5.0	5.0	5.0	1.0

Finding severity and source confidence

Risk and Data Quality Breakdown

Audit findings

Medium

Low

High

Critical

Data quality issues

Data Warehouse5

CRM Platform6

ERP System8

External Feed2

Legacy System4

Executive action queue

Priority and Overdue Actions

Action	Directorate	Owner	Due	Age	Status
Change Management - High Priority Action	Compliance & Assurance	Risk Manager A	16 Nov 2024	45d	Open
Financial Reporting - Critical Priority Action	Risk Management	Assurance Lead B	17 Nov 2024	-	Closed
Financial Reporting - High Priority Action	Risk Management	Assurance Lead B	24 Jan 2025	-	Open
Vendor Management - High Priority Action	Compliance & Assurance	Risk Manager A	14 Sept 2024	108d	Open
Regulatory Compliance - High Priority Action	Human Resources	Control Owner D	06 Oct 2024	-	Closed
Change Management - Medium Priority Action	Corporate Operations	Control Owner C	05 Dec 2024	26d	Open
Financial Reporting - High Priority Action	Finance & Treasury	Compliance Officer B	18 Nov 2024	43d	Open
Vendor Management - Low Priority Action	Compliance & Assurance	Risk Manager B	05 Nov 2024	56d	Open

Narrative layer

Executive Insight

Control maturity is broadly stable, but the action queue needs focus. Overdue work is concentrated in operational directorates, and data quality exceptions remain a reporting-confidence risk.

Watch points

55.9% of open actions are overdue at the synthetic snapshot date.
11 high or critical findings require senior attention.
13 open data quality issues may affect reporting confidence.

Next decision

Confirm which overdue actions need executive escalation and whether legacy source-quality controls should move into the next remediation sprint.

Portfolio disclosure

This preview uses synthetic demonstration data only. It is not client work, does not contain protected data, and should be treated as a portfolio example of a Power BI-reproducible reporting framework.

Product page Request similar dashboard

Power BI rebuild notes

Reproducibility blueprint

Build notes are kept below the report surface so screenshots remain presentation-ready while the page still documents how the dashboard maps to Power BI tables, measures, relationships, slicers, and visuals.

Power BI Buildability Blueprint

Required Tables

DimDateOne row per day

Date dimension for time-based analysis and reporting

CSVExcelSQL

DimDirectorateOne row per directorate

Business unit or directorate dimension for organizational hierarchy

CSVExcelSQL

DimOwnerOne row per owner

Owner dimension for accountability tracking

CSVExcelSQL

DimRiskLevelOne row per risk level

Risk level classification for findings and issues

CSVExcelSQL

DimControlAreaOne row per control area

Control area dimension for categorizing controls and findings

CSVExcelSQL

FactAssuranceActionOne row per assurance action

Fact table for assurance actions with status, due date, and ownership

CSVExcelSQL

FactAuditFindingOne row per audit finding

Fact table for audit findings with severity and remediation status

CSVExcelSQL

FactControlAssessmentOne row per control assessment

Fact table for control assessments with maturity scores

CSVExcelSQL

FactDataQualityIssueOne row per data quality issue

Fact table for data quality issues with severity and resolution status

CSVExcelSQL

DAX Measures

Open Actions0

Count of assurance actions currently open

CALCULATE(
  COUNTROWS(FactAssuranceAction),
  FactAssuranceAction[Status] IN {"Open", "In Progress"}
)

Overdue Actions0

Count of assurance actions past their due date

CALCULATE(
  COUNTROWS(FactAssuranceAction),
  FactAssuranceAction[DueDate] < TODAY(),
  FactAssuranceAction[Status] <> "Closed"
)

High Risk Findings0

Count of audit findings with high or critical risk level

CALCULATE(
  COUNTROWS(FactAuditFinding),
  FactAuditFinding[RiskLevelId] = "High",
  FactAuditFinding[Status] <> "Resolved"
)

Compliance Score0

Overall compliance score based on control coverage and maturity

AVERAGEX(
  VALUES(DimDirectorate[DirectorateId]),
  CALCULATE(AVERAGE(FactControlAssessment[ControlMaturityScore])) * 20
)

Average Control Maturity0.0

Average maturity score across all control assessments

AVERAGE(FactControlAssessment[ControlMaturityScore])

Data Quality Issues Open0

Count of data quality issues currently open

CALCULATE(
  COUNTROWS(FactDataQualityIssue),
  FactDataQualityIssue[Status] <> "Resolved"
)

Actions Closed This Month0

Count of assurance actions closed in the current month

CALCULATE(
  COUNTROWS(FactAssuranceAction),
  FactAssuranceAction[Status] = "Closed",
  FactAssuranceAction[ClosedDate] >= DATE(YEAR(TODAY()), MONTH(TODAY()), 1),
  FactAssuranceAction[ClosedDate] < DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1)
)

Overdue Rate0.0%

Percentage of open actions that are overdue

DIVIDE(
  [Overdue Actions],
  [Open Actions],
  0
)

Visual Mappings

Overview

KPI Card - Open Actionslow risk

Power BI: card

Standard card visual displaying the Open Actions measure

KPI Card - Overdue Actionslow risk

Power BI: card

Card visual with conditional formatting for alert threshold

KPI Card - Compliance Scorelow risk

Power BI: new_card

New card visual with indicator and conditional formatting

Compliance Trend Linelow risk

Power BI: line_chart

Standard line chart showing compliance score over time

Actions by Directoratelow risk

Power BI: clustered_bar_chart

Clustered bar chart comparing open vs overdue actions by directorate

Findings by Severitylow risk

Power BI: stacked_bar_chart

Stacked bar chart showing findings by severity and directorate

Control Maturity

Control Maturity Matrixlow risk

Power BI: matrix

Matrix visual with conditional formatting for maturity levels

Control Coverage by Arealow risk

Power BI: donut_chart

Donut chart showing control coverage distribution

Priority Actions

Priority Actions Tablelow risk

Power BI: table

Table visual with conditional formatting for overdue dates and status

Actions by Ownerlow risk

Power BI: clustered_bar_chart

Bar chart showing action distribution by owner

Data Quality

Data Quality Issues Openlow risk

Power BI: card

Card visual with conditional formatting

Data Quality Issues by Sourcelow risk

Power BI: clustered_bar_chart

Bar chart showing issues by data source

Data Quality Issues Tablelow risk

Power BI: table

Table visual with conditional formatting

Slicers & Filters

Overview

DimDirectorate[DirectorateName]

Dropdown slicer

Filter all visuals by directorate

DimControlArea[ControlAreaName]

List slicer

Filter by control area

DimDate[Year]

Dropdown slicer

Filter by year

Control Maturity

DimDirectorate[DirectorateName]

Dropdown slicer

Filter matrix by directorate

Priority Actions

FactAssuranceAction[Status]

Dropdown slicer

Filter by action status

FactAssuranceAction[Priority]

Dropdown slicer

Filter by priority level

Data Quality

DimDirectorate[DirectorateName]

Dropdown slicer

Filter by directorate

FactDataQualityIssue[Status]

Dropdown slicer

Filter by issue status

Table Relationships

FactAssuranceAction[DirectorateId] → DimDirectorate[DirectorateId]

many-to-one (single)

FactAssuranceAction[OwnerId] → DimOwner[OwnerId]

many-to-one (single)

FactAssuranceAction[ControlAreaId] → DimControlArea[ControlAreaId]

many-to-one (single)

FactAssuranceAction[RiskLevelId] → DimRiskLevel[RiskLevelId]

many-to-one (single)

FactAuditFinding[DirectorateId] → DimDirectorate[DirectorateId]

many-to-one (single)

FactAuditFinding[ControlAreaId] → DimControlArea[ControlAreaId]

many-to-one (single)

FactAuditFinding[RiskLevelId] → DimRiskLevel[RiskLevelId]

many-to-one (single)

FactControlAssessment[DirectorateId] → DimDirectorate[DirectorateId]

many-to-one (single)

FactControlAssessment[ControlAreaId] → DimControlArea[ControlAreaId]

many-to-one (single)

FactControlAssessment[AssessorId] → DimOwner[OwnerId]

many-to-one (single)

FactDataQualityIssue[DirectorateId] → DimDirectorate[DirectorateId]

many-to-one (single)

FactDataQualityIssue[RiskLevelId] → DimRiskLevel[RiskLevelId]

many-to-one (single)

DimOwner[DirectorateId] → DimDirectorate[DirectorateId]

many-to-one (single)

Power BI Limitations

Real-time updates

Standard Power BI refresh is not real-time

Workaround: Use Power BI streaming datasets for real-time data or DirectQuery for near real-time

Complex interactions

Web demo may have smoother transitions and animations

Workaround: Use bookmarks and buttons for navigation, accept simpler transitions

Custom styling

Power BI theming is less flexible than web CSS

Workaround: Use Power BI theme files for consistent branding

Customisation Options

KPI thresholds

Adjust RAG thresholds
Add additional KPIs
Change KPI definitions

Thresholds can be adjusted in measure DAX or conditional formatting rules

Date range

Add date range slicer
Add comparison periods
Add rolling windows

Additional date filters can be added using DimDate dimension

Drill-through pages

Add detail pages for actions
Add detail pages for findings
Add detail pages for assessments

Drill-through pages can be configured for each visual

Delivery Notes

Data model should be built in Power BI Desktop using the defined tables and relationships

Measures should be created in a dedicated measures table for easy maintenance

Conditional formatting rules should be documented for consistency

Theme file should be created to match brand colors

Bookmark navigation should be configured for multi-page dashboards

Drill-through pages should be configured for detail views

Data source should be tested with synthetic data before client deployment

Refresh schedule should be configured based on business requirements

Scoping options

Dashboard Blueprint

scoped after review

Data model, measures, and visual specifications for a defined dashboard need

Starter Dashboard Build

source-dependent

Essential KPIs and focused reporting in Power BI

Professional Dashboard Build

page-count dependent

Multi-page dashboard with defined measures, interactions, and handover notes

Analytics System Build

discovery required

Connected reporting structure with refresh, documentation, and governance considerations

Ongoing Support

support scoped separately

Dashboard maintenance, updates, and improvement backlog support

Commercial scope depends on data condition, number of sources, dashboard pages, refresh requirements, and handover expectations.