Page 01
Portfolio baseline
Reconcile asset population, ownership, lifecycle coverage, and data-quality gaps.
ServiceNow · Power BI · DAX · technology risk
IT asset lifecycle intelligence.
A graduate capstone covering lifecycle risk, legacy dependencies, KPI standardization, and executive reporting for approximately 4,200 IT hardware assets.
Portfolio overview
Demonstration dataset aligned to the documented project scale
Reporting period · Q2
Assets in sample4,200Hardware population
At-risk rate11.4%Lifecycle and support criteria
Legacy dependencies184Relationship flags
Lifecycle compliant73.0%Policy alignment
Lifecycle and end-of-life profile
Asset exposure by support status
Source pattern: ServiceNow asset records
Assets by lifecycle position
Risk matrix
High risk / high dependency72
High risk / low dependency96
Low risk / high dependency112
Controlled3,920
Legacy dependency review
Prioritized asset cohorts
Priority combines lifecycle, dependency, and control status
| Asset group | Lifecycle state | Assets | Dependencies | Primary issue | Status |
|---|---|---|---|---|---|
| Endpoint fleet A | Within 12 months | 420 | 32 | Replacement sequencing | Monitor |
| Network appliance B | Past support | 84 | 61 | Legacy application dependency | Escalate |
| Server cohort C | Date unresolved | 126 | 18 | Lifecycle data quality | Validate |
| Managed device D | Supported | 1,140 | 24 | Standard monitoring | Controlled |
Unified performance framework
From source-system audit to leadership action
Four report-page architecture
Page 02
Lifecycle exposure
Model end-of-life timing and rank assets by support-window risk.
Page 03
Dependency risk
Connect legacy assets to internal dependencies and control indicators.
Page 04
Executive action
Standardize KPI definitions, priorities, and decision-ready reporting for leadership.