Posted by: Adam Deane | 01/06/2010

BPM Reporting

A follow-up on yesterday’s post

BPM ReportingOne of the gaps that I find in BPM projects is the reporting.
For one of the most important business pains, it doesn’t get the attention it deserves.
Hours, days, months are spent on designing the process. Reporting – it’s an afterthought…

Reporting is not part of the process design (…I don’t think it’s defined in the BPMN either..)
If I’m lucky – it’s defined in the last paragraph of the technical spec or the functionality spec – and it’s probably defined badly.
So I have to put on my creative cap…

Yes, there are always the out-of-the-box process reports, but that’s not the customer is looking for.
In BPM suites, most of the out-of-the-box process reporting is done on the process metadata and most of the analysis is done on the process performance.
There is little on the business data inside the process, and that’s actually what the customer needs!

Below, I’ve written the steps that I take to build the reporting platform. It’s far from perfect, nothing to write home about, but it gets the job done.

1. Find the business pain.
2. Create gauges for the high management
3. Create crunch number reports for middle management
4. Create a mechanism for managers to create their own reports

Finding the Business Pain.
Sometimes finding the business pain is simple, the customer knows what they want. Sometimes it’s a bit more trickier, internal politics that they don’t want to expose. It usually takes a coffee (or a beer) to get to the bottom of it.
Most of the business pains that I’ve seen run something along the following lines:
• We want to find the slackers
• We want to be able to prove to the customer that we are on time
• We want to be able to prove to the customer that they are in the wrong
• We want to prove to the bosses that the company can’t do without us.

BPM GaugesMonitoring Gauges
Managers love pretty gauges. Sales love showing them. Visualization.
They are not as accurate as real crunch number reporting, but they do give a good indicator on what’s happening.

I‘ve even had a manager tell me that he wakes up in the morning, turns on his laptop, opens the portal. If the gauge is showing green – he turns around and sleeps for another hour. If it’s red – he gets out of bed and goes to work..

The gauges need to show answers to the business pains.
• Show me the efficiency-rate per employee in my department
• Show me the SLAs and KPIs for the last 3 months per customer.
• Show me the number of rejected/wasted time/redundant proposals sent to the customer.
• Show me the revenue/deals won/successful requests of my department

Crunch Number Reports
These are the real reports middle-management want. Numbers, drilldowns…
If possible, to be sent directly to them every Monday morning at 7:00. “Exporting to Excel and PDF would be nice”. “Can I have a logo on the top left corner?”
“I want to see all the information relevant to my department, except for closed, declined and anything marked with ‘QR101’ prefix.”

Create a mechanism for managers to create their own reports
Creating reports is the fun part of my projects. It a challenge between me and the database. It’s stimulating (in a geeky kind of way..)
But creating proper reports take time. Managers want the ability to create their own reports by themselves, now.
I use Microsoft’s Reporting Services to create models that enable them to build their own reports using the report wizard. I’m usually bashing Microsoft, but this time they did come up with a nifty piece of software that solves the business pain, and is quite user friendly and easy to use. I usually create around 5 models, leave them with the business analyst and come back a month later to find that they have created 50 reports by themselves. Kudos to Microsoft here.
That said, I’m sure non-Microsoft vendors have the same tools and functionality.

As I said before, it gets the job done. The customer is more than happy and I’ve ticked all the boxes.
But I get this feeling that with all the BPM notations, BPM methodologies and – we are still missing out on a better way to do reporting in BPM.


Responses

  1. […] BPM Reporting « Adam Deane The need for business data in process reporting, not just process data — key point, often overlooked (or ignored by vendors during demos). (tags: bpm bi analytics) […]

  2. Ideally we should find the ‘Business Pain’ in the exception paths. When we model business processes with the process modeling framework, we develop up to 4 levels of exception paths. Each of these have progressive handling and intervention requirements.

    If you take this approach, your instrumentation or reporting of the pain, will fall out naturally.

    • Hi Tom,

      Sorry for the delay of my answer. I was pondering over your comment.
      I’ve been trying to figure out how one would find the real business pain in the exception paths. If I have a process with 20 business rules, each of them could have an exception path (Did the manager approve, No…etc..).
      It’s nice to be able to report on exceptions, but is that really the business pain?
      * The response to the customer is too slow and causing us to lose business.
      * We have got employees that sit around all day and do nothing.
      * The decisions are based on hunches instead of real-time information.
      * I need to know about problematic cases before they spiral out of control.
      * I have no idea of the expenses that have been approved, and are we on target.
      These are examples of business pains. can we find them from a model?

      I don’t think business pains to fall out naturally from models. I have never seen business pains ‘fall out’ ever. It’s usually about prying them out. But I might be wrong and there is a way to find them from a business process model. Could you please exlain how is that done.

      Cheers,
      Adam

  3. True BI is a must-have for BPM tools. Instead of designing it ourselves, we decided to integrate our BPM software (ProcessMaker) with one of the leading BI software: Pentaho. I think the mashup path will likely be used by more BPM providers going forward.

    • Johan, I’ve never seen Pentaho used for BPM analytics, although have in other uses such as more standard website analytics. How does it compare for interactive dashboarding with commercial solutions?

      • Sandy-

        We currently have a rather simple integration with a few built-in report options, but we can do about anything you describe in your article “BPM: the Five Ps” for example.

        I will be happy to give you a quick demo if you are interested.

  4. […] BPM Reporting « Adam Deane The need for business data in process reporting, not just process data — key point, often overlooked (or ignored by vendors during demos). (tags: bpm bi analytics) Posted by Sandy Kemsley on Wednesday, June 2, 2010, at 8:01 am. Filed under Links. Follow any responses to this post with its comments RSS feed. You can post a comment or trackback from your blog. […]

  5. […] week my posts were related to BPM reporting, monitoring and analysis: (The BPM Bottleneck, BPM Reporting, The Five […]

  6. I didn’t write the 5 P’s article, Adam did. 🙂

    I would be interested in seeing what you’ve done with it.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: