Medical Device Performance Tracking Pivot Dashboard

Create an advanced Excel pivot table and Power Query solution for tracking medical device performance across multiple healthcare facilities. The dashboard must integrate failure rates, maintenance logs, and repair costs, with dynamic filtering capabilities. Implement conditional formatting to highlight critical device performance metrics, and develop a predictive maintenance scoring algorithm that flags potential equipment failures before they occur.