Business Intelligence is a hot button with most managers and executives these days, because the immediacy of having real-time data turned into actionable insights is priceless for strategic decision-making. In a recent class on “Business Intelligence Training – The Microsoft Self-Service BI Toolset,” one of our most popular courses, a student asked me an excellent question. With a little research, I came up with a better answer than I was able to give in class off the top of my head. So I thought I’d share it with you.
The question is, “How do I set a KPI (Key Performance Indicator) column for every object in my SharePoint list or library?” Our answer will be applicable to SharePoint 2010 and 2013, but I’ll be using screenshots from SharePoint 2010.