Executive Summary
Created a comprehensive Power BI dashboard that provides enterprise-wide visibility into End-of-Life (EOL) risks across the IT landscape, enabling proactive risk management and strategic planning.
Business Challenge
MUFG needed clear visibility into:
- Which applications were running on EOL software
- Database versions approaching end-of-support
- Server operating systems requiring upgrades
- Dependencies between applications, databases, and infrastructure
Without this visibility, the organization faced:
- Security vulnerabilities
- Compliance risks
- Unplanned downtime
- Emergency upgrade projects
Solution Architecture
Data Integration
Connected multiple data sources:
- ServiceNow CMDB: Application and CI relationships
- Database Discovery: Version and vendor information
- Server Inventory: OS versions and patch levels
- Vendor EOL Databases: Official end-of-life dates
Dashboard Structure
1. Executive Overview
- Total EOL assets by category
- Risk heat map
- Upcoming EOL deadlines (30/60/90 days)
- Trend analysis
2. Application Layer
- Applications by EOL status
- Business criticality mapping
- Application-to-database dependencies
- Owner assignments
3. Database Layer
- Database versions and EOL dates
- Server-to-database relationships
- Upgrade complexity scoring
- Licensing implications
4. Infrastructure Layer
- Server OS versions
- Physical vs. virtual breakdown
- Location and data center mapping
- Migration planning views
Technical Implementation
Power BI Features Used
- Data Modeling: Star schema with fact and dimension tables
- DAX Measures: Complex calculations for risk scoring
- Drill-Through: Navigate from application to underlying infrastructure
- Row-Level Security: Role-based access control
- Automated Refresh: Daily updates via gateway
Sample DAX Calculation
EOL Risk Score =
VAR DaysToEOL =
DATEDIFF(TODAY(), [EOL Date], DAY)
VAR BaseScore =
SWITCH(
TRUE(),
DaysToEOL < 0, 100, -- Already EOL
DaysToEOL < 90, 75, -- Critical
DaysToEOL < 180, 50, -- High
DaysToEOL < 365, 25, -- Medium
10 -- Low
)
VAR CriticalityMultiplier =
SWITCH(
[Business Criticality],
"Critical", 1.5,
"High", 1.2,
1.0
)
RETURN
BaseScore * CriticalityMultiplier
Results and Impact
Immediate Outcomes
- Identified 500+ EOL assets across the enterprise
- Launched remediation program for critical systems
- Secured executive sponsorship for modernization initiatives
- Improved compliance posture through proactive management
Strategic Benefits
- Risk Prioritization: Data-driven decision making
- Budget Planning: Multi-year upgrade roadmap
- Stakeholder Alignment: Shared visibility across IT teams
- Audit Readiness: Comprehensive EOL documentation
Key Insights
- Data Quality Matters: CMDB accuracy directly impacted dashboard reliability
- Relationships Are Critical: Understanding dependencies prevented siloed decisions
- Visualization Drives Action: Executive-friendly visuals accelerated buy-in
- Automation Scales: Daily refreshes kept data current without manual effort
Technologies Used
- Power BI Desktop: Dashboard development
- Power BI Service: Publishing and sharing
- Power Query: Data transformation (M language)
- DAX: Calculations and measures
- ServiceNow REST API: CMDB data extraction
- SQL Server: Data warehouse integration
Future Enhancements
Planning to add:
- Predictive analytics for upgrade planning
- Cost modeling for remediation
- Integration with project management tools
- Automated alerting for upcoming EOL dates
This dashboard transformed EOL management from reactive fire-fighting to proactive strategic planning, demonstrating the power of data analytics in IT governance.