We hide the columns with the older data.

I don't have a scorecard example, but I usually do a search for "KPI" or "metrics" to get started. So in your case a google search for "insurance industry KPI" would probably render a few examples to get you started. Then the metrics usually needs changes in wording so they can be measured weekly in a relatively simple way.