We have the reporting software, what next?
Every BI consultant I've encountered has worked with clients who've paid for and installed a complex reporting solution without a plan for how they were going to implement it in their workplace. The story often unfolds as follows:
Let's get the ball rolling again and talk about common KPI's you may find useful in your reporting and analytic environment! You may find them useful, or discover that your company uses variations of the ratios I present here. Either way, in articulating where we are similar or different, you solidify ideas of what may be useful in your reporting environment!
10 KPIs Every Finance Solution Needs
The AIA (American Institute of Architechts) have an excellent write-up of Key Performance Indicators for the Balance Sheet and Income Statement. While some of the KPI's and examples reviewed are clearly written from the perspective of a services company, documents like this may get your mind churning. Additionally, I regularly discover new business metrics under Klipfolio.com's body of KPI examples and Templates which I had not considered.
Walkthrough: Adding KPIs to your Cube using Jet Enterprise
This tutorial shows you how to implement many of the measures highlighted in the earlier graphics using Jet Reports' Jet Data Manager product to manipulate a Microsoft SSAS Cube.
For readers with a Sales or Operations bent, in an earlier blog post, I reviewed calculating 'Top 10 Customers' and 'Yesterday's Sales'.
That's All Folks!
As a freelance BI and Jet Reports consultant at Onyx Reporting, I'm available to provide both consulting services and training for Microsoft BI and Jet Reports products as well as dashboarding in Excel.