本文へ移動
cccskills
無料GitHub で公開

ropa-executive-dashboard

Creates executive reporting and visualization from RoPA data including processing activity counts, risk heatmaps, compliance scores, trend analysis, and supervisory authority readiness indicators. Activate for RoPA dashboard, executive reporting, risk heatmap, compliance score, trend analysis, board reporting, KPI.

インストール方法を見る

含まれるファイル(5)

  • SKILL.md9.9 KB
  • assets/template.md3.8 KB
  • references/standards.md3.0 KB
  • references/workflows.md2.8 KB
  • scripts/process.py14.9 KB

SKILL.md(原文)

インストールする前に、エージェントに与えられる指示の中身を確認できます。

RoPA Executive Dashboard

Overview

The RoPA is a compliance document, but its data also serves as a strategic management tool. Aggregated RoPA data reveals the organisation's processing landscape, risk concentrations, compliance posture, and trends over time. This skill defines the metrics, visualisations, and reporting structures that transform raw RoPA data into executive-level insights for board reporting, DPO annual reports, and supervisory authority readiness assessments.

Dashboard Metrics Framework

Tier 1: Compliance Metrics (Supervisory Authority Readiness)

MetricDefinitionTargetData Source
RoPA completeness scorePercentage of entries meeting all Art. 30 mandatory fields with quality scoring>=95%Completeness audit engine
Staleness ratePercentage of entries not reviewed within 12 months<=5%Last reviewed date field
DPA coveragePercentage of processor recipients with documented Art. 28 DPAs100%Recipient and DPA fields
Transfer mechanism coveragePercentage of international transfers with documented safeguard mechanisms100%Transfer field
DPIA linkage completenessPercentage of high-risk entries linked to approved DPIAs100%DPIA reference field
Purpose specificityPercentage of entries with purposes free of vague terms>=95%Purpose field text analysis
Retention concretenessPercentage of entries with concrete retention periods>=95%Retention field text analysis

Tier 2: Risk Metrics

MetricDefinitionCalculationSignificance
Special category processing countNumber of entries involving Art. 9 dataCount of entries where special_category != "None"Higher count = greater regulatory risk
High-risk processing ratioRatio of DPIA-required entries to total entriesDPIA-required / TotalIndicates processing risk concentration
International transfer countTotal number of documented cross-border transfersSum of all transfer entriesEach transfer is a potential enforcement point
Third-country transfer risk scoreWeighted count of transfers by destination riskTransfers to non-adequate countries weighted 3x, adequacy countries 1xHighlights transfer risk concentration
Processor dependency countNumber of unique external processorsDistinct count of processor recipientsHigher count = greater supply chain risk
Average entry ageMean days since last review across all entriesSum of days since review / Total entriesIndicates overall currency of records

Tier 3: Operational Metrics

MetricDefinitionTarget
Total processing activitiesCount of active RoPA entriesTracked over time for growth trends
Entries per departmentDistribution of entries across business unitsBalanced coverage expected
New entries (quarter)Entries created in the current quarterIndicates processing activity discovery rate
Archived entries (quarter)Entries archived in the current quarterIndicates decommissioning activity
Change velocityNumber of RoPA changes per quarterStable trend expected; spikes indicate organisational change
Remediation closure ratePercentage of audit findings remediated within deadline>=90%
Processing owner response ratePercentage of review requests responded to within 14 days>=95%

Visualisation Specifications

1. Risk Heatmap: Processing Activities by Risk Level and Department

Axes: X = Department (HR, Clinical, Marketing, Finance, IT, Facilities, Sales), Y = Risk Level (Low, Medium, High, Critical)

Cell content: Count of processing activities in each cell. Colour intensity proportional to count.

Risk level determination:

  • Critical: DPIA required + special category data + international transfers to non-adequate countries
  • High: DPIA required OR special category data
  • Medium: International transfers OR large recipient list (>5 processors)
  • Low: Standard processing with no risk indicators

Example heatmap for Helix Biotech Solutions:

DepartmentLowMediumHighCritical
Human Resources3210
Clinical Operations0123
Digital Marketing2200
Finance4100
IT3200
Facilities1010
Sales3100

2. Compliance Score Gauge

Type: Radial gauge (speedometer style) Range: 0-100% Zones: Red (0-50), Amber (50-70), Yellow (70-85), Green (85-95), Dark Green (95-100) Current value: Overall completeness score from the audit engine Comparison: Previous quarter score shown as reference marker

3. Trend Analysis: Processing Activity Growth Over Time

Type: Line chart X-axis: Quarters (8 quarters rolling) Y-axis: Count of active processing activities Lines: Total entries, new entries added, entries archived Purpose: Shows whether the organisation is actively discovering and recording processing or whether the RoPA is stagnating

4. International Transfer Map

Type: Geographic flow map Base: World map with EEA highlighted Flows: Arrows from organisation location to each transfer destination country Arrow width: Proportional to number of transfers to that country Colour: Green = adequacy decision, Blue = SCCs, Purple = BCRs, Red = no mechanism documented

5. Supervisory Authority Readiness Indicator

Type: Traffic light indicator per metric Metrics displayed: Each Tier 1 compliance metric with Green/Amber/Red status

MetricStatusValueThreshold
Completeness scoreGreen96.2%Green >=95, Amber >=85, Red <85
Staleness rateAmber7.8%Green <=5, Amber <=15, Red >15
DPA coverageGreen100%Green = 100, Amber >=90, Red <90
Transfer coverageGreen100%Green = 100, Amber >=90, Red <90
DPIA linkageGreen100%Green = 100, Amber >=80, Red <80

Executive Report Structure

Quarterly RoPA Report to Data Protection Steering Committee

Page 1: Executive Summary

  • Overall compliance score (gauge)
  • Key changes since last quarter
  • Top 3 risks
  • Top 3 remediation priorities

Page 2: Compliance Dashboard

  • Tier 1 compliance metrics table
  • SA readiness traffic lights
  • Trend chart (4-quarter rolling)

Page 3: Risk Landscape

  • Risk heatmap by department
  • Special category processing summary
  • International transfer map
  • Processor dependency chart

Page 4: Operational Metrics

  • Processing activity count and trend
  • Change velocity chart
  • Remediation closure rate
  • Review response rate

Page 5: Findings and Actions

  • Open audit findings by severity
  • Remediation progress tracker
  • Upcoming review deadlines
  • Recommendations

Annual DPO Report to the Board

The annual DPO report required under Art. 38(3) should include a RoPA section covering:

  1. Processing landscape overview: Total activities, departments covered, year-over-year growth.
  2. Compliance posture: Annual completeness score, comparison to previous year, SA readiness status.
  3. Risk summary: High-risk processing activities, DPIA coverage, international transfer overview.
  4. Significant changes: New processing activities, decommissioned activities, major regulatory changes.
  5. Audit outcomes: Summary of annual completeness audit findings and remediation status.
  6. Recommendations: Investment needs (tool upgrades, staffing), process improvements, regulatory preparation.

KPI Definitions

Primary KPIs (Report to Board)

KPIDefinitionTargetFrequency
RoPA Compliance IndexWeighted average of all Tier 1 metrics>=95%Quarterly
Time to Record New ProcessingDays from processing activity identification to RoPA entry approval<=10 business daysMonthly
Audit Finding Closure RatePercentage of findings closed within deadline>=90%Quarterly
SA Readiness ScoreComposite of compliance metrics indicating ability to respond to SA request within 48 hoursGreenQuarterly

Secondary KPIs (Report to DPO/Steering Committee)

KPIDefinitionTargetFrequency
Review Response RatePercentage of annual review requests completed on time>=95%Annually
Change Management IntegrationPercentage of IT change requests that complete privacy impact screening>=98%Monthly
Automated Discovery CoveragePercentage of IT systems covered by automated RoPA scanning>=80%Quarterly
Cross-Reference IntegrityPercentage of RoPA-DPIA cross-references that are valid100%Quarterly

Data Sources for Dashboard

MetricPrimary SourceRefresh Frequency
Completeness scoresCompleteness audit script outputMonthly (automated), Annually (manual)
Staleness dataRoPA last_reviewed_date fieldReal-time
Risk indicatorsDPIA reference, special category, transfer fieldsReal-time
Trend dataHistorical RoPA snapshots (stored quarterly)Quarterly
Remediation dataAudit finding trackerWeekly
Change velocityRoPA change logReal-time
Processing owner responseReview workflow systemPer review cycle

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

Implements 42 CFR Part 2 protections for substance use disorder patient records. Covers written consent requirements stricter than HIPAA, re-disclosure prohibition, court order procedures, qualified service organization agreements, and 2024 amendments aligning Part 2 with HIPAA. Keywords: 42 CFR Part 2, substance use disorder, SUD records, re-disclosure, consent, Part 2 amendments.

日本語の概要は準備中です。原文の説明を表示しています。

mukul975/Privacy-Data-Protection-Skills3032026年3月17日 更新

Guides assessment of third-country adequacy decisions under GDPR Article 45 for international data transfers. Covers the current EC adequacy decisions list, adequacy assessment criteria, partial adequacy handling, and monitoring of adequacy decision reviews. Keywords: adequacy decision, Article 45, third country, adequate protection, EC adequacy list.

日本語の概要は準備中です。原文の説明を表示しています。

mukul975/Privacy-Data-Protection-Skills3032026年3月17日 更新

Implements age-gating mechanisms for online services to restrict access based on user age. Covers hard gates versus soft gates, neutral age prompts, re-verification triggers, circumvention prevention, and regulatory requirements under GDPR, COPPA, UK Online Safety Act, and DSA. Keywords: age gate, age restriction, neutral prompt, children, online services, access control.

日本語の概要は準備中です。原文の説明を表示しています。

mukul975/Privacy-Data-Protection-Skills3032026年3月17日 更新

Evaluates and implements age estimation and verification technologies for online services. Covers facial age estimation, digital ID verification, self-declaration with risk assessment, AI-based age estimation, and the accuracy versus privacy tradeoff. Includes ICO guidance and euCONSENT framework. Keywords: age verification, age estimation, facial analysis, digital ID, children, online safety.

日本語の概要は準備中です。原文の説明を表示しています。

mukul975/Privacy-Data-Protection-Skills3032026年3月17日 更新

Preparing EU AI Act compliance documentation for high-risk AI systems. Covers Annex III classification, technical documentation under Art. 11, conformity assessment, risk management systems, and CE marking requirements. Keywords: EU AI Act, high-risk AI, Annex III, conformity assessment, CE marking.

日本語の概要は準備中です。原文の説明を表示しています。

mukul975/Privacy-Data-Protection-Skills3032026年3月17日 更新

Implements GDPR Art. 22 automated decision-making and AI Act Art. 14 human oversight requirements for AI systems. Covers identification of solely automated decisions, meaningful human intervention design, logic explanation mechanisms, and contestation procedures. Keywords: Art. 22, automated decision, human oversight, AI Act, profiling, contestation.

日本語の概要は準備中です。原文の説明を表示しています。

mukul975/Privacy-Data-Protection-Skills3032026年3月17日 更新

mukul975 のスキルをすべて見る

このスキルの問題を報告する