We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

Blog: Claudia Imhoff Subscribe to this blog's RSS feed!

Claudia Imhoff

Welcome to my blog.

This is another means for me to communicate, educate and participate within the Business Intelligence industry. It is a perfect forum for airing opinions, thoughts, vendor and client updates, problems and questions. To maximize the blog's value, it must be a participative venue. This means I will look forward to hearing from you often, since your input is vital to the blog's success. All I ask is that you treat me, the blog, and everyone who uses it with respect.

So...check it out every week to see what is new and exciting in our ever changing BI world.

About the author >

A thought leader, visionary, and practitioner, Claudia Imhoff, Ph.D., is an internationally recognized expert on analytics, business intelligence, and the architectures to support these initiatives. Dr. Imhoff has co-authored five books on these subjects and writes articles (totaling more than 150) for technical and business magazines.

She is also the Founder of the Boulder BI Brain Trust, a consortium of independent analysts and consultants (www.BBBT.us). You can follow them on Twitter at #BBBT

Editor's Note:
More articles and resources are available in Claudia's BeyeNETWORK Expert Channel. Be sure to visit today!


Operational BI is becoming quite the buzz today. There are countless articles, tips, vendors with operational BI offerings, case studies, etc., available today. Yet, I still get asked the very basic question of how do you get started. What are the first steps? Well, here are my thoughts on how to get started...

I plan to focus a lot of my attention on operational BI this year and next. It is a fascinating and critical form of business intelligence but it is also quite foreign to traditional BI implementers for one very big reason -- it requires climbing back into the world of operations and truly understanding the processes, procedures, and workflows of operations. We in the BI space were happy to turn our backs on operational procedures and processes, choosing to create a completely separate world where we could store our data and then analyze it until the cows come home. We gave little thought or care about what was happening in operations. That was the operational IT folks' problem...

Well, operational BI changes all that!

For operational BI to be effective, it must be injected into the ordinary operational procedures and processes at the right moment to impact the decision-making process of the operational personnel. so what should BI implementers be thinking about before starting down the road of creating operational BI applications? Here are two suggestions:

1. Start small -- sound familiar? It should. It is what we have always said about BI projects but in this case, I mean really small. I recommend that you examine well-documented operational processes (that is the first trick -- finding well-documented operational processes) to see where in the process you can inject a bit of BI. Perhaps the process is inefficient or requires considerable manual intervention (of the analytical kind) before moving to the next step. Look for productivity gains that can be acquired through the use of BI. And make sure you consider collaboration in the overall process flow. Why small? Because you are not only creating the analytic capability -- you are also impacting a standard operating procedure. These may have to be rewritten, the operational personnel may have to be retrained, the interfaces between the involved applications may have to be recreated. And so on. My first piece of advice -- Don't try to make big changes to operational processes. You open a can of worms when you do. Just speed up or make more efficient the processes you already have in place.

2. Second suggestion - Perform a honest assessment of your existing data warehouse and BI delivery capabilities. What technologies do you have? How suitable are they for operational BI? How mature is your overall DW and BI architecture? What about your existing DW and BI personnel? Are they suitably experienced and skilled? Why do I ask these questions? Because I guarantee that any weaknesses that you discover in your assessment will only be exaggerated as you speed things up -- as you squeeze out any and all latencies in your DW creation and BI delivery processes. For example, if your ETL infrastructure is weak, it will only get worse. If your data quality processing is fragile or inefficient, speeding it up will only make it shoddier. If your ability to delivery data is frail, trying to drive out latencies in it will only cause it to fall apart.

Once you have picked an appropriately sized project and have assessed your ability to delivery on it, you can begin implementing the operational BI application. I hope these tips have convinced you that an operational BI application does has ramifications way beyond the project’s immediate boundaries. It also has significant benefits to the enterprise if integrated appropriately into the operational procedures and processes.

Good luck to you on this exciting and new adventure. I encourage those of you that have experience with operational BI to share your thoughts on getting started as well. I look forward to reading them.

Yours in Operational BI success!


Technorati Tags: operational BI, Operational Procedures, BI, Business Intelligence, business performance

Add to Technorati Favorites

Posted May 31, 2008 3:54 PM
Permalink | 3 Comments |


We just implemented an operational BI solution for our supply chain organization using our global data warehouse (replacing a siloed regional data mart). The data we deliver is very time sensative and directly impacts daily operations. The biggest challenge we had was meeting the daily SLA for the ETL process. So if, as you pointed out, any part of your infrastructure is fragile, you may be in trouble. The good news was that we were able to identify a weakness in the process, and a gap in the support montoring. Those have been fixed and we are now on our way to also having a more user friendly dashboard for our own EDW operational metrics.

Operational BI is VERY hard, but meeting the challenge will improve your overall infrastructure and processes.

Just waving hi to Claudia. Good to see you are still on top of the data mountain!

I continually ask customers what percentage of all BI and reporting and BI applications ultimately end up in an Excel spread sheet. The response is 85% on the low end and up to 100% on the high end. My next question is why do you invest in the intermediate tools if you are ultimately going to work in Excel anyway. I use this as a point of departure of a much deeper conversation around general user acceptance and usage across the organization. What are your thoughts and what do your blog memebers think?

Could you also comment on the new Microsoft add-in for Excel 2010. Microsoft has a new addition to Excel 2010 called Powerpivot - (powerpivot.com) seems to be a game changer. The general thinking across a broad customer sampling is that the tool can be easily used by business analysts for very quick prototyping on the front end and serious analysis on the back end. The middle is still reserved for all the datawarehousing and datamart ETL and processing as usual. But with the ability to have over 100 Million rows of data in memory on a notebook, seems to change the game - and it is Excel.

Leave a comment


Search this blog
Categories ›
Archives ›
Recent Entries ›