Data Governance Metrics Dashboard
Metrics are very useful for many reasons. They can help you track your progress and give you a clear, non-subjective view of how you are doing. You can build goals around them and they are incredibly useful in presentations to others not so familiar with your program. I recently found myself having to give a spur-of-the-moment presentation to our executive sponsors, and I thought I’d give you a little insight on how I quickly put together a strong presentation with information I already had. I didn’t have to spend a lot of time developing material or crunching data, it was already available to me.
We all know that metrics are important to executives. They basically see the world in metrics… balance sheets, sales data, margins, share prices, etc. I’ve talked before about speaking the language of your audience and in this case it should be pretty obvious that elegant and clear metrics will be easily understood by the executives. My key metrics center around four different topics:
- Number of Issues Opened in the past Quarter
- Number of Issues Closed in the last Quarter
- Segmentation of issues by type
- Changes in the Data Maturity Model
I always put the numbers in a table, and then use a pie chart next to it so that they can visually see how the data is breaking down. This data is automatically tracked for me on a daily basis via a simple access database that tracks all of our issues. As issues are opened, closed and categorized the queries and reports in the background are automatically updated. Because of this my metrics are always current and ready to be presented at a moments notice.
So all I did was grab an old presentation that already had the table structures present and updated the numbers to what they currently are. The charts automatically updated and all I had left to do was clean up some talking points and detail some current issues and where executive involvement may be beneficial. I’d recommend tracking your issues in a software program that keeps you up-to-date, as our little Access database does for us.