Thursday, May 22, 2008

Business Intelligence:”I’m not dead.”

If you are a fan of Monty Python, you will recognize this line from “Monty Python and the Holy Grail”.

I had a bit of a positive experience today with a client that caught me a bit off guard. It may be because there are times in this industry where you feel business intelligence has become a commodity. Seems like every organization owns at least one, and in most cases, multiple BI tools. There is pressure in the consulting industry from offshore resources, which I am personally not convinced about for BI applications. So needless to say, at times I am a bit jaded.

So that brings me to today. I am working at a client to build out a new reporting architecture. It’s a pretty significant size initiative and will replace numerous disconnected reporting packages that are managed through a hodge podge of manual processes. We are using the Cognos 8 reporting platform, specifically Report and Query Studio. As part of design, we have been prototyping a reporting package that is currently being done in Excel and packaged into PowerPoint. There are a lot of charts, formatting and commentary that goes into the package. Thus far, I have been thoroughly impressed with the Cognos tools to replicate the current set of reports. But the shocker was the level of excitement from business users who are currently saddled with creating these reports manually. And on top of that, the flexibility to expose the dimensional model would support a majority of the ad-hoc requests that the group receives.

So the point is I guess people are still not getting what they can from their investments in business intelligence and corporate performance management technologies. A majority of organizations are still in the 80/20 position of spending 80% of their time gathering data, creating highly formatted reports manually. If that is the case, it is hard to be called a commodity. I guess the software could be since the tools are there, but organizations haven’t yet realized the value from the investments.

There is another scene from the Holy Grail that draws parallels to the current state of BI.

King Arthur: Go and tell your master that we have been charged by God with a sacred quest. If he will give us food and shelter for the night, he can join us in our quest for the Holy Grail.
French Soldier: Well, I'll ask him, but I don't think he will be very keen. Uh, he's already got one, you see.
(Replace King Arthur with software sales rep and Holy Grail with BI tool)

Tuesday, May 20, 2008

Back in the Saddle

After taking a couple of days off, I have found that I have a bit of writer’s block. Between responding to the mountain of emails that piled up last week and getting back into the blogging groove, I am a bit stuck. That being said, I came across a couple of articles that I wanted to post some thoughts on.

There seems to be a lot of chatter around mobile BI. I came across 3 separate articles in the last week related to analytics being delivered to mobile devices. The first was an announcement by IBM that they will deliver business solutions through new BlackBerry devices. This includes the Cognos 8 Go software. The second article was from Intelligent Enterprise and had three case examples of businesses that are using mobile devices to deliver BI. The interesting thing I found with this was the simplicity of the applications, which seems critical when dealing with a small interface and only needing specific KPIs. The final announcement is a clinical specific application built by Vaultus Partners and Covisint that delivers patient dashboards to mobile devices.

One trend in all three of these articles is that BlackBerry is the device of choice. Not surprising since RIM has a strangle hold on the enterprise mobile market.

If you read through these and are wondering “How the heck can I be thinking about mobile BI?” when you can’t even get desktop-based reporting, don’t worry. Eventually, you will get to the point where these type of solutions will be possible.

Friday, May 16, 2008

Day 3 Highlights - Conference Wrap Up

Well, DIG 2008 wrapped up yesterday. I just got back from Vegas and have finally recovered from the long flight back to Boston. It was a great event and some of the informal feedback from attendees confirmed that feeling. It would be great to get some comments from attendees on what people thought was valuable and where we could improve for next year.

Day 3 was focused on Enterprise 2.0. If you aren't familiar with E2.0, our keynote for the day was able to level set the group on the definition, usage and benefits. Andrew McAfee from Harvard Business School, who coined the term Enterprise 2.0, provided his perspective on E2.0. From his presentation he provided the following definition:

"Enterprise 2.0 is the use of emergent social software platforms within
companies, or between companies and their partners or customers."

He also identified a list of representative technologies below this definition: wikis, blogs, prediction markets, social networking software, RSS, links, search, tags.

After Andrew's keynote, we then moved into our case study presentations with R. Todd Stephens, Mat Fogarty and Euan Semple. We followed up the case study presentations with Q&A. I was happy to see that we got a lot questions from the group, since prior to the conference a large majority of the attendees (70%) had no plans in their organizations to adopt E2.0 technologies.

We concluded the DIG conference with an entertaining talk from Jeff Ma. If you aren't familiar with Jeff, he is the real life character from the book "Bringing Down the House" and subsequent movie "21". Aside from the challenge of being the final presenter at 4 pm, Jeff kept the crowd entertained and was peppered with questions by the group at the end.

I haven't had a chance to step back and try to put the different presentations and dialogs over the week into something coherent. I took a ton of notes during the 3 days and we have the audio recorded, so it will be good to go back and listen to the presentations and discussions. We are hoping to make some of these great assets available through the blog. Stay tuned.

I want to finally thank everyone that attended the conference: the speakers, delegates and sponsors I was happy to see that even with all the distractions of Las Vegas, everyone stayed engaged throughout the entire week.

Thursday, May 15, 2008

Day 2 Highlights from the Conference

We had a great second day at DIG. We covered our first two themes of the conference built around "Creating one version of the truth" and "Insights from advanced analytics".
The Boston Globe and Central Intelligence Agency discussed data management topics for their respective organizations. There was a lot of great discussion with the attendees on governance, which seems to be a hot topic for many organizations. Dan Power from Hub Design also spoke on the topic of Master Data Management.

Infosys, Reliant Energy and Kelley Blue Book each presented for the second theme. It was interesting to see that both Infosys and Reliant use the Balanced Scorecard to frame their dashboard and operational reporting. Most of the panel discussion questions were on the topic of ROI, which was interesting. Bruce Hoffman from Kelley Blue Book didn't need to answer that question since the KBB business model is based on selling the data and analysis on the automotive industry!
We also video taped our megavendor panel discussion with our platinum sponsors SAP, Microsoft and Oracle. We will be posting that discussion once we have a production copy available. Stay tuned.

One last comment. Jevon MacDonald put a nice post on his blog on the conference thus far.







Wednesday, May 14, 2008

Day 1 is in the books!

Just finishing up day 1 of DIG. We had a great first day with the clinics and a cocktail reception to welcome the conference attendees. I have a couple of observations from the day I wanted to quickly share:

1. Glyn Heatley delivered his CPM overview clinic in the morning. He had a pretty diverse group of IT and business functions in the room, which was great. There were a couple of observations from the group that I found interesting. One was the lack of statistical capabilities in a majority of the BI vendor platforms. I found this interesting and is something that I would like to research a bit to see where the gaps are. I am not in anyway knowledgeable in the area of statistical packages like SAS, so it would be interesting to see how big of a functional gap exists.

2. I sat in the Enterprise 2.0 clinic with Jevon and Thomas in the afternoon. This was a great session with a ton of learning. It was a bit like drinking from the fire hose. There were a couple of things that came up that we discussed in the session. The first was the concerns around privacy and sharing of certain types of data. I was surprised to hear that there are some E2.0 software vendors that are focused on becoming SOX compliant. The second interesting discussion was the differences between business taxonomy and folksonomy. Business taxonomy is the practice of establishing structure around things like enterprise data, while folksonomy is the practice of allowing the collective group to describe "objects" as they see them. An example would be tagging of content, like this blog post. The two worlds are very different but when done correctly, specifically creating the appropriate linkages between taxonomy and folksonomy, will enhance an organizations collective ability to describe information.

3. The reception was a great informal setting to meet and great with attendees. I had an opportunity to spend some time with our platinum sponsors Oracle, Microsoft and SAP. They will be participating in our "megavendor" panel tomorrow. Looking forward to the discusson.

That's it for me. It's been a long first day. The good news is that I am even at the tables thus far. The same can't be said for a couple of other folks who will go unmentioned.

Monday, May 12, 2008

Heading to Vegas for DIG

Well, the week of the DIG conference is finally here. Looking forward to the three days. My guess is that the week will go by quickly. Here are some random thoughts and things to look forward to:

1. The clinics on Tuesday should be a good opportunity to roll the sleeves up on some great topics. I will be helping out Glyn Heatley during his clinic on CPM and BI architecture. I took a look at the content this afternoon and there is a lot to cover in the 3.5 hours, but it should provide people with some follow up actions for their organizations! Mark Lorence's talk on analytics is great, especially if you are struggling with what are the right measures for your organization (one thing to note, Mark's clinic will be in the afternoon on Tuesday, not the morning). I am very interested and will be attending Jevon MacDonald's and Thomas Vander Wal's clinic on Enterprise 2.0. If you aren't currently signed up for a clinic, there is still time to register!

2. If you didn't notice the Twitter update box on the right side of the blog, take a look at the talkdig Twitter user. If you aren't familiar with Twitter, it is a "micro-blogging" technology that uses text messaging to make posts. I have been using Twitter for about 3 months and it is a fun way to communicate with friends and colleagues. We are hoping that DIG attendees sign up and use it as a way to receive conference updates, ask questions during the Q&A, or simply try to informally organize with colleagues while at the DIG conference. It will also be a way to stay connected after the conference ends. Signing up is free and all you need to do is start "following" the talkdig user once you are setup.

3. We have one speaker change for Thursday. Bo Cowgill from Google will unfortunately not be able to join us, but instead we will have Mat Fogarty presenting on the topic of prediction markets. Mat is the founder of Xpree, which focuses on providing enterprise prediction market solutions. Prior to starting Xpree, Mat was the Director of Financial Planning on Electronic Arts where he was responsible for running prediction markets forecasting key metrics. Mat's session will be titled "Using prediction markets to tap employee wisdom". We are excited to have Mat speak at DIG!

4. On Wednesday, we have a "mega vendor" panel planned with our three platinum event sponsors Oracle, Microsoft and SAP/Business Objects. I am looking forward to have all three vendors on stage together in a moderated discussion on future technology trends. Since this is a bit of a unique opportunity to have them all together on stage at once, we are going to video tape the discussion and make it available in the coming weeks. Stay tuned.

5. Go Celtics - could you at least win one road game during the playoffs!!!

That's it for now. Looking forward to seeing everyone in Las Vegas. Stay tuned for updates during the week. We plan on blogging at the end of the day and hopefully get some pictures posted.

Thursday, May 8, 2008

Composite Metrics

Here are some interesting examples of composite metrics - metrics whose values are determined by a mathematical formula involving other metrics. Composite metrics can be very effective in dashboards and scorecards, as they can quickly represent high-level information with a single number based on multiple underlying values (think Dow Jones Industrial Average).



The first is from traffic.com and is called the Jam Factor, which sounds like the name of a bad 80’s rock band but is an extremely useful metric.

The Traffic.com Jam Factor is like a Richter Scale for traffic. It’s an overall measure of the traffic intensity on a roadway, or on a section of a roadway. Because the Jam Factor calculation uses real-time and historical speed data from our digital sensors and those of our partners, as well as our detailed accident, construction and congestion information, it’s a comprehensive measuring tool that is unique to Traffic.com.

The Jam Factor is measured on a scale of 0-10, with 10 representing the worst traffic conditions. This numerical scale also provides color coding to give you a quick, at-a-glance picture of conditions on the roadways.


The second is a software analysis tool called WKO+ from TrainingPeaks. WKO+ provides a variety of tools that cyclists can use to monitor data from heart-rate monitors, power meters, and GPS devices to analyze their training. Working with exercise physiologists, TrainingPeaks developed two metrics that are used in their product: Training Stress Score (TSS) and Intensity Factor (IF). TSS tells you how much stress you put on your body during a workout, and IF tells you how intense the workload was compared to last months’ similar workout.

According to Gear Fisher, Chief Technology Officer at TrainingPeaks:

“The beauty of TSS and IF is that, combined, they can tell the amount of physiological stress put on a person’s body. They are all based on an individual rider’s threshold. So unlike heart-rate or even power zones, where 400 watts is 400 watts but if I weight 300 pounds and the guy next to me weighs 150 pounds the end result is something dramatically different in terms of velocity. If I go out and do 200 TSS points, or Lance Armstrong goes out and does 200 TSS points, the relative effect on each of our bodies is the same. So he put his body through the same amount of stress as I did, even though it only took me 2 hours to get 200 TSS points and it might take Lance Armstrong 3 hours – or even an hour, depending on how hard he’s going.”

The third is from a co-worker, who’s Slapdown Index is calculated from the number of hours of sleep she had the night before, the length of her commute that morning, and the frequency of annoying email requests she gets before 10:00am. A high Slapdown Index is a leading indicator of her propensity to inflict bodily harm on those who dare approach her cube.

I’ve started using Jam Factor, TSS, and Slapdown Index to optimize my daily performance. What composite metrics have you found to be useful?