BUSINESS OF PRACTICE: MANAGING THE HEALTH OF YOUR PRACTICE AND PERSONNEL
Fig. 1. Veterinary Balanced Score Card Model.
over any period of time and obtain a comparison with any prior selected period or date range. Self- serve options are useful when seasonal practice activity is a complicating factor to baseline compar- ison, and alternate date ranges can clarify interpretation. The following examples of KPI trends use Excel spreadsheet models, updated by month, and include a moving trailing 12-month total (TTT). The TTT
trendline is extremely helpful for visualizing prac- tice improvement or adverse changes that should be quickly addressed (Fig. 3). Many available business intelligence applications
are built on balanced scorecard modeling. The for- ward thrust of these apps is to extract and combine data from multiple databases within the business. The apps knit the results together into effective data visualization through virtual dashboards. Any
Fig. 2. Example of a Balanced Score Card Dashboard Design and Results. AAEP PROCEEDINGS Vol. 66 2020 357
