I need to develop a High Quality KPIs dashboard using Power BI software (14 KPIs).

Hi,

I hope all is well,

I need to develop KPIs dashboard using Power BI software (14 KPIs). The 14 KPIs details are attached in the excel sheet. Please note for the following requirements in developing the KPIs (if you miss any of the following your work Is not accepted):

– The dashboard must be readable and clear and easy to understand.

– See the attached KPIs template (power bi format file) this one is something close to what I want to show.

– This is a sample template request, so I am expecting you to show me random numbers data with results.

– Please consider using Button links in the dashboard such as the one I attached, to switch and have the below 3 different dashboards in 1 page.

– The Dashboard must contain 3 different dashboards: 1- Main general dashboard that shows a summary for dashboards number 2 and 3. 2- Internal team KPI, 3- Groups Head (14) and Entities (86) dashboard.

– The dashboard number 3 contains a total of 100 (14+86) different teams that we need to test their KPIs as listed above Groups Head (14) and Entities (86).

KPIs
#
1
2
3
4
5
6
KPI Title
KPI Description
KPI Calculation Formula
Group Adoption %
Percentage of
Group Entities
have adopted the
Program
Number of Group Entities
who have adopted the
Program / Total number of
Group Entities
Group Implementation %
Percentage of
Number of Group Entities
Group Entities who
who have implemented
have fully
the Program/ Total
implemented the
number of Group Entities
Program
Minimum Standards
Implementation Progress/ Status
%
Percentage of
minimum
governance
standards
implemented by
each Group Entity
Timeliness of CSAs Completion %
Percentage of CSAs Number of CSAs
completed by
submitted within reporting
control owners on period / Total number of
time for all key
applicable controls within
controls
reporting period
ToD Failure Rate %
Percentage of
internal controls
failed ToD testing
Number of ToD control
failures / Total number of
applicable key controls to
test
ToE Failure Rate %
Percentage of
internal controls
failed ToE testing
Number of ToE control
failures / Total number of
applicable key controls to
test
Number of Minimum
Governance standards
implemented / total
number of applicable
minimum standards
No. of open deficiencies
past their remediation
dates / Total number of
deficiencies that should be
closed as per the specified
dates
Timeliness of Remediation %
Percentage of
deficiencies past
their remediation
date
8
Severity of Deficiencies
Number of
significant
Sum of significant
deficiencies and
deficiencies and material
material
weaknesses
weaknesses found
9
Number of successfully
Percentage
completed Sign-offs within
Timeliness of Internal Controls Sign- internal control
expected date / Total
off %
sign-offs
number of expected Signcompleted on time offs to be completed by
expected date
10
Training Completion Rate %
Percentage of
Completed Program
Program trainings
training by required
that have been
employees / Total number
completed on time
of employees required to
by the required
take Program training
employees.
GRC Development
Percentage
completion of the
GRC development
and readiness for
deployment
GRC Adoption
Number of Group
Entites that have
Number of Group entities
successfully
using a GRC Tool
implemented an
adequately/Total number
adequate GRC tool
of Group Entities
and being used
sufficiently
7
11
12
Number of required items
tested and ready for
use/Total number of items
requested for
development and
implementation
13
14
Quality Assurance Review Visits
Completion %
Percentage of
Group Entities
visited as per
Quality Assurance
Review Visit Plan
Number of Group Entities
visited / Total number of
Group Entities to be
visited as per plan
General/ Overall Control
Environment Measure for Group
Assessment
Average control
environment
health score for
affiliates based on
general/ overall
measurement
elements
Sum of individual
weighted scorecard
measurement elements /
Total possible score
Draft Target Threshold
1. Controlled Entities:
– 2024 and onwards:
100%
2. Other Entities:
– 2024: 20%
– 2025: 35%
– 2026: 50%
1. Controlled Entities:
– 2024: 50%
– 2025: 75%
– 2026: 100%
2. Other Entities:
– 2024: 10%
– 2025: 25%
– 2026: 50%
12 months from
adoption date.
100%
< 2% 1. Implementation (year 1): < 15% 2. Implementation (year 2 onwards): < 2% < 5% open deficiencies past remediation timeframe 1. Material Weaknesses: 0 2. Significant Deficiencies: < 10% 100% 100% 100% 1. Controlled Entities: - 2024: 50% - 2025: 75% - 2026: 100% 2. Other Entities: - 2024: 10% - 2025: 25% - 2026: 50% 100% 4 (out of 5 point maturity assessment scale, with 5 being the highest)