01
Project Portfolio Dashboards
Solstice Advanced Materials · 2025 to present
Challenge
- Multiple laboratory and validation projects needed better visibility of status, KPIs, budgets, timelines, risks and resources.
Action
- Designed interactive Smartsheet dashboards and structured project tracking across QA, QC, Finance, Procurement and Regulatory teams.
Result
- Stakeholders gained visibility of status, KPIs, budget, timelines, risks and resource utilization across multiple cross-functional projects.
Tools: Smartsheet · Excel · SAP
Portfolio overview
Illustrative sample data. Recreated to show the method, not any company system.
Illustrative sample data for four generic projects: 75% on schedule, 62% of budget used against a 65% plan, and 3 open risks. Of 31 milestones, 14 are complete, 9 in progress, 6 not started and 2 delayed. Workstream A is complete, Workstream B is in progress, and Workstreams C and D are planned for later quarters.
- 4
- Active projects
- 75%
- On schedule
- 62%
- Budget used vs plan
- Plan: 65%
- 3
- Open risks
Milestones by status
- Complete 14
- In progress 9
- Not started 6
- Delayed 2
Workstream timeline
- Complete
- In progress
- Planned
