Customer credit risk is accessed with visual clues being provided with stoplights and cell highlights.
Value-at-risk calculations highlight the probable credit default value and its quantum is expressed as a percentage of sales and profit. (EG. a VAR to Profit Ratio of 2%, implies that you are 95% confident that your company will lose 2% of your profit this year to bad debts.)
These powerful metrics allows sales or finance managers to take quick action to mitigate the risk by imposing additional restrictions or adjusting the credit or payment terms accordingly.
Although this sample report was written in SSRS with a SQL back end, the concepts can be applied to most current business intelligence and reporting systems.
