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

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
Commentary
3/12/2009
07:36 AM
Cindi Howson
Cindi Howson
Commentary
Connect Directly
Twitter
RSS
E-Mail
50%
50%

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

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.

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.

caption goes here
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.

caption goes here
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.

caption goes here
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, BIScorecardUsers 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.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
News
8 AI Trends in Today's Big Enterprise
Jessica Davis, Senior Editor, Enterprise Apps,  9/11/2019
Slideshows
IT Careers: 10 Places to Look for Great Developers
Cynthia Harvey, Freelance Journalist, InformationWeek,  9/4/2019
Commentary
Cloud 2.0: A New Era for Public Cloud
Crystal Bedell, Technology Writer,  9/1/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Data Science and AI in the Fast Lane
This IT Trend Report will help you gain insight into how quickly and dramatically data science is influencing how enterprises are managed and where they will derive business success. Read the report today!
Slideshows
Flash Poll