Prism Team Metrics Calculator
An automated reporting flow that turns raw project-tracker exports into a live team throughput and turnaround dashboard.
Problem
Placeholder copy — understanding how the team was actually performing — turnaround time, revision counts, capacity by editor — meant manually pulling exports from the project tracker and rebuilding the same pivot tables every reporting cycle. The numbers were always a week stale by the time anyone looked at them.
Solution
Placeholder copy — a Power Automate flow pulls project-tracker data on a schedule, cleans and reshapes it, and feeds it into a structured Excel workbook. Calculated fields and a summary dashboard surface turnaround times, workload by editor, and revision trends automatically, with no manual export step required.
Outcome
Placeholder copy — the team went from reconstructing metrics by hand each cycle to checking a dashboard that was already current. Bottlenecks in the review pipeline became visible early enough to actually address, instead of showing up after the fact.