Welcome Guest. | Log In| Register | Membership Benefits

Intelligent Enterprise

Better Insight for Business Decisions

RSS
Webcasts
Digital Library
Subscribe
Home

Tech Center:

Next-Era Business Intelligence

Self-Service BI: Let Users Get on the (Soccer) Ball | Intelligent Enterprise Blog

Cindi Howson's BI Scorecard
Cindi Howson is the founder of BIScorecard, a Web site for in-depth BI product reviews. She has been using, implementing and evaluating business intelligence tools for more than 15 years. She is the author of Successful Business Intelligence: Secrets to Making BI a Killer App and Business Objects XI R2: The Complete Reference. She teaches for The Datawarehousing Institute (TDWI) and is a frequent speaker at industry events.
See More by Cindi Howson

E-MAIL |

Self-Service BI: Let Users Get on the (Soccer) Ball

Posted by Cindi Howson
Thursday, March 12, 2009
7:36 AM

You know that I am a big football fan, Packers in particular, because of my son, but everything I know about soccer (a.k.a. European football), I have learned from my English husband.

What does this have to do with BI? Information Builders just launched this cool new soccer dashboard of the 2009 Champions League. As I wrote about rich reportlets in this Cool BI article, such an interactive report is what most users envision for self-service BI. Users don't want "ad hoc," as in starting at a blank screen with 1,000 possible data elements to choose from. No. Most information consumers want to interact with an existing report or dashboard as a starting point. Self-service BI means users don't have to go to IT for a relatively simple enhancement request to get a sort, filter, chart or new calculation added to the report.

Figure 1

(click image for larger view)

The soccer dashboard uses Information Builder's Active Reports, an optional module first launched in 2006. Based on a combination of Java Script and XML (AJAX), users can save this file locally and still have a high degree of interactivity while disconnected. To launch, click the link "launch the full report" (you can do it live from the link above, but the starting point is pictured at right in Figure 1). To sort the data, you click the down arrow on each column. Want to know who has the most fouls? It's Atletico Madrid (Figure 2). This sort option is not something a programmer had to explicitly add to a report definition or user interface. Instead, it's automatically available when the report is saved or rendered as AJAX output in the same way you would save as PDF.

Figure 2

(click image for larger view)

A bigger question of course is whether or not these fouls are worth it. Does aggression on the field result in more goals? With Active Reports, you can readily create a scatter plot (Figure 3) by right-clicking on the Foul column. The chart shows there is a "slight" relationship between higher number of fouls and goals scored. Unfortunately, the hover-over only shows the coordinates of 5 goals to 21 fouls. It would be better if the hover displayed that this is from the German team of Bayern.

I think you would agree, though, that this level of interactivity is a big improvement over some Web-based BI tools that seem to only automate former paper-based reports or that require users to go into a sophisticated design environment. For the record, while Information Builders was one of the first to provide such robust interactivity using AJAX, other vendors now have varying degrees of rich reportlets via Flash. Information Builders supports both AJAX and Flash output.

Figure 3

(click image for larger view)

Sadly, so far the Brits are not looking too good in this. But we are only a few weeks into the tournament. Our favorite, Leeds United, never makes it to this level anyway, so I guess I should focus only on the BI aspects of this app! For a more in-depth review of Information Builders' BI capabilities, check out this BIScorecard report.

Regards,
Cindi Howson, BIScorecard

E-MAIL |

This is a public forum. United Business Media and its affiliates are not responsible for and do not control what is posted herein. United Business Media makes no warranties or guarantees concerning any advice dispensed by its staff members or readers.

Community standards in this comment area do not permit hate language, excessive profanity, or other patently offensive language. Please be aware that all information posted to this comment area becomes the property of United Business Media LLC and may be edited and republished in print or electronic format as outlined in United Business Media's Terms of Service.

Important Note: This comment area is NOT intended for commercial messages or solicitations of business.

In-Depth Reports

Seeing Connections: Visualization Makes Sense of Data
Using the latest visualization tools and approaches, you can map data, add context, make connections and communicate more convincingly and effectively than ever before. Take this visual tour that points toward a compelling and accessible new era of BI.

Insight at the Speed of Thought: Taking Advantage of In-Memory Analytics
Fast analysis, better insight and rapid deployment with minimal IT involvement: these are the leading benefits of in-memory analytics, but different products are appropriate for different environments. Here's how to choose from among a growing list of in-memory technologies.