How to create an automated annual scorecard that tracks various metrics?

Set targets, calculate %to target, weightings, threshold, stretches, aggregated score.

Create snapshots of live datasets to do monthly and quarterly comparison.