====================================================================== FMEA Risk Prioritization Dashboard (Power BI) ====================================================================== DEFINITION ---------------------------------------- The FMEA Risk Prioritization Dashboard (Power BI) is a dynamic, interactive business intelligence tool built in Microsoft Power BI that visualizes and prioritizes failure modes using Failure Mode and Effects Analysis (FMEA) metrics—primarily the Risk Priority Number (RPN) and/or Action Priority (AP)—to support data-driven risk mitigation decisions. It integrates structured FMEA data (e.g., severity, occurrence, detection ratings) with real-time filtering, drill-down capabilities, and conditional visual cues (e.g., color-coded heatmaps, Pareto charts) to highlight high-priority risks. Designed as a reusable template, it enables cross-functional teams to collaboratively assess, monitor, and track risk reduction efforts across product development, manufacturing, or service delivery processes. OVERVIEW ---------------------------------------- At its core, the dashboard operationalizes the FMEA methodology by transforming static spreadsheet-based risk assessments into an agile, visual decision-support system. It leverages Power BI’s modeling capabilities—such as DAX (Data Analysis Expressions) for calculated columns and measures, relationships between dimension tables (e.g., Components, Failure Modes, Causes), and time-aware metrics—to compute and display risk scores consistently. The dashboard typically includes interactive slicers for process step, subsystem, team owner, or mitigation status, enabling contextual analysis; visualizations like bubble charts (size = RPN, x-axis = Severity, y-axis = Occurrence) and waterfall charts (showing RPN delta pre/post mitigation) enhance interpretability. Crucially, modern implementations increasingly adopt AIAG-VDA harmonized Action Priority (AP) over legacy RPN, reflecting a shift toward qualitative risk response logic—where high-severity failures demand immediate action regardless of occurrence or detection ratings. The dashboard also supports auditability and continuous improvement through versioned data ingestion (e.g., from Excel, SharePoint, or Azure SQL), change logs, and integration with Jira or Teams for action item handoff. KEY COMPONENTS ---------------------------------------- 1. Risk Score Calculation Engine (RPN/AP) 2. Interactive Visual Hierarchy (Heatmaps, Pareto, Bubble Charts) 3. Mitigation Tracking & Status Workflow APPLICATIONS ---------------------------------------- - Manufacturing Process FMEA (PFMEA) Prioritization - Design FMEA (DFMEA) Validation Support - Healthcare Equipment Safety Risk Review KEY FORMULAS ---------------------------------------- Risk Priority Number (RPN): RPN = Severity × Occurrence × Detection -> A composite score (1–1000) quantifying the overall risk level of a failure mode based on three 1–10 Likert-scale ratings. Action Priority (AP): AP = IF(Severity >= 9 && Occurrence >= 4, "High", IF(Severity >= 8 && Detection <= 3, "Medium", "Low")) -> A categorical priority level (High/Medium/Low) determined by predefined AIAG-VDA rulesets—not a numeric product—to guide corrective action urgency. RPN Reduction Rate: (RPN_Before_Mitigation - RPN_After_Mitigation) / RPN_Before_Mitigation -> Percentage improvement in risk score post-mitigation, used to quantify effectiveness of implemented controls. RELATED CONCEPTS ---------------------------------------- - Failure Mode and Effects Analysis (FMEA) - AIAG-VDA FMEA Handbook - Root Cause Analysis (RCA) REFERENCES ---------------------------------------- AIAG & VDA: FMEA Handbook (1st Edition, 2019) (https://www.aiag.org/standards/quality/fmea) Microsoft Power BI Documentation: DAX Guide (https://learn.microsoft.com/en-us/dax/) ISO 14971:2019 — Medical Devices — Application of Risk Management to Medical Devices (https://www.iso.org/standard/70658.html) TAGS ---------------------------------------- FMEA, Power BI, risk management, manufacturing analytics, quality engineering