The Macrosite for News, Analysis and Opinion about the Future of the Internet
Scott Koegler

Business Analytics Get Better at Reporting

Written by Scott Koegler
10/27/2009 8 comments
DISCUSS   Digg   Del.icio.us   Reddit   Email This   TWEET THIS

Data analytics is not a new topic. In fact, in some ways data is useless unless it's analyzed in some way -- even if only sorted in a spreadsheet. But these days, the crushing amounts of data generated by a wide variety of applications is tough for any enterprise to digest.

Because of that, most of the systems put in place over the last few years have required significant processing horsepower, continuous development energy, and access to large data stores in order to deliver usable information. On top of that, these systems have typically been historic in their views.

The next step in the evolution of analytics is to deliver analysis to the desks of people who can understand and act on the information in time for their actions to have relevance to the business.

Enter business analytics reporting, a task that is easier said than done. But it’s a problem on which several suppliers are focused.

Data visualization and presentation are key to this new kind of usable information, says Venkatesh Komarla, general manager and head of the analytics business unit for IT services firm MindTree Ltd. In his view, sophisticated visualization programs can quickly represent trends and significant variables via high-quality graphics and constructs.

The point is to intuitively understand the underlying data; the days of looking at large tables and manipulating pivot tables are past -- they consume too much time, and the complexity of the task could lead to errors.

Detail is the key. A program should support well known binary (WKB) representation, Komarla says. It should also display new visual constructs such as dispersion graphs and statistical outputs like intuitive box plots. And it should leverage advances in Web technologies to provide easier access to very rich visuals through just a browser.

Another supplier stresses the value of having predefined sets of tools with prebuilt links to widely used applications. "With our data growing at a rate of 15 petabytes of new data each day, it's necessary to get the right analysis to the right users so they can make smart decisions,” said Farhana Alarakhiya, business unit executive for analytic applications at IBM, which recently announced additions to its analytics reporting software.

Alarakhiya points to an early user in the HR industry, where the staff typically acted in response to queries from their field offices and customers. "They were generating head counts and other reports that were needed by the managers of their remote offices on a regular basis." What the staff didn't have time for was the analysis of whether the offices had the right kind of talent, were recruiting the right skills, and were anticipating the growth in the proper segments of the business.

According to Alarakhiya, a reporting and analytics package now allows a staff of four to obtain forward-looking information that guides immediate and ongoing decision-making for 10,000 employees.

A growing roster of solutions and products for data analytics reporting are available from other vendors, including Oracle Corp. (Nasdaq: ORCL) and Birst, which is issuing release 4.0 of its SaaS-based analytics reporting tool next week.

While each supplier has its own claims, and some products are only starting to become available, it is clear that the groundwork to deliver analytics information is being laid, and the promise of more usable intelligence based on live data may be in the works.

— Scott Koegler was a CIO for 15 years, and has been writing about technology for the last 18 years. He is editor of www.ec-bp.org, a newsletter that addresses supply chain technologies, and EDI in particular. You can contact him at scott@koegler.net.

DISCUSS   Digg   Del.icio.us   Reddit   Email This
Current display:       newest comments first       display in chronological order
no ratings

Thanks, makes sense, but the high cost and the variety of data sources are all the more reasons for someone to start an open source alternative and disrupt that market niche a bit!

no ratings

I would guess that there are opensource solutions, but the magnitude of supporting the data transformations between multiple systems means there needs to be significant effort put into development and maintenance. As for Google Analytics - it's a great tool for web traffic analysis. These systems go beyond web traffic, and link directly to the data housed in the applications. In fact, these apps may not even be available as web based apps.

 

no ratings

So many areas of software have been challenged by open source, that I wonder if there's any equivalent to Google Analytics in other arenas?

Scott Koegler
Thinkernetter
Wednesday October 28, 2009 1:22:06 PM
no ratings

Analytics is probably THE hot topic in a number of realms now. The financial crunch has meant that most companies are not expanding - an activity that took tremendous resources in years past. Rather, they are focusing on better understanding and optimizing their existing business model. Analyzing the data that's flowing through their systems, and being able to react in real time is not only the new priority for many - it's the only real option they have to increase the bottom line.

DHagar
Thinkernetter
Wednesday October 28, 2009 1:08:32 PM
no ratings

Those are the kind of tools that really provide value!

DHagar

aum007
Rank: Cyborg
Wednesday October 28, 2009 8:12:57 AM
no ratings

Tableau is a great piece of software.Having used it throughout my company as well as when I was working as an Consultant for a Bank;I must say the Analysis that it did was awesome.I think it goes very well with SAPs ERP system.

Ashish.

DHagar
Thinkernetter
Tuesday October 27, 2009 7:12:21 PM

That's the key.  To be able to build a strong data base and link it with tools like Tableau that enable you to compile mixes of data and put it into company intelligence is key to gaining value.

I think the use, and building, of intelligence through the use of business analytical tools like IBM-Cognos, Oracle, etc., is where companies increasingly are going to focus.  I think this is where technology will gain stature as well with business.

DHagar

RamonAntonio345
Rank: Scrivener
Tuesday October 27, 2009 5:24:08 PM

I suggest to take a look to Tableau which is now in its 5.0 generation. I have been using it for a while and it gets better in each reincarnation. Basically you link data from Excel, for my purpose, but it can link from servers in other formats. Once you link the original data, you start to cross reference the data by dragging into columns or rows and the program automatically displays alternative visualizations.

The great thing is that you can use the program with your own produced raw data or reports, which means you basically know the basic issues. however, the visualizations made posible by Tableau can sometimes blew your mind by the trends, relations and most importantly clustering of the data.

I am truly impressed by it and its application and use goes totally in sync with Mr. Koegler well focused article.

The ThinkerNet does not reflect the views of TechWeb. The ThinkerNet is an informal means of communication to members and visitors of the Internet Evolution site. Individual authors are chosen by Internet Evolution to blog. Neither Internet Evolution nor TechWeb assume responsibility for comments, claims, or opinions made by authors and ThinkerNet bloggers. They are no substitute for your own research and should not be relied upon for trading or any other purpose.
previous posts from Scott Koegler
Scott Koegler
Scott Koegler   10/12/2009   4 comments
Collecting data from multiple sources ceased to be a problem some years ago, as online connections became pervasive. And storage of the massive amounts of information generated by the plethora of computing systems has become a relatively less expensive matter with the decreasing costs of disk capacity and online storage systems. But making sense of the information in those archives has become increasingly difficult as the volume and diversity of the data continues to expand.
Scott Koegler
Scott Koegler   10/9/2009   5 comments
Supply chains are the backbone linking manufacturers with retail, but that link is anything but a direct line.
5
of
IETV: the thinkerNet on film
5
of
2pm EST
Tue
Dec 1st
an IBM information resource
sponsored content
big blue blog
Todd Watson
Todd Watson   11/20/2009   Post a comment
While Google introduces its new Chrome OS (which I'm hearing will be widely available in one year?  Did I mishear that?), IBM announced 10 new products today to help companies using IBM System z mainframe technology.
white papers & case studies
an IBM information resource
sponsored content
Smarter Collaboration: How to Thrive in a Challenging Business Environment
Market conditions are changing faster than ever, and organizations need to improve their agility and adaptability in order to provide better service and improve processes. The ability to work with customers, business partners, and employees as effectively as possible - while at the same time holding down costs - is a key to success.

READ THIS eBOOK
your weekly update of news, analysis, and
opinion from Internet Evolution - FREE!

REGISTER HERE
Wanted! Site Moderators
Internet Evolution is looking for a handful of readers to help moderate the message boards on our site – as well as engaging in high-IQ conversation with the industry mavens on our thinkerNet blogosphere. The job comes with various perks, bags of kudos, and GIANT bragging rights. Interested?

Please email: moderators@internetevolution.com
Copyright © 2009 United Business Media Limited - All rights reserved.      About Us  |  Privacy Policy and Terms of Use  |  Contact Us
CMP Media LLC
Internet Evolution – not for thickies
Singer at C-Level
Smart Grid Opportunities

11|20|09   |   2:49   |   No comments


Industry initiatives and government stimulus funds are giving enterprise software vendors a great opportunity to help build out and manage smart grid technologies.
Reiter's Block
Tweeting for Customer Support

11|18|09   |   2:20   |   No comments


When Reiter gets incensed over incompetent Verizon FiOS order-taking and support, he broadcasts it via Twitter. Did it do any good? How should your company offer Twitter support? Watch this for all the answers.
Reiter's Block
Is the BlackBerry 9700 'Bold' Enough?

11|17|09   |   3:07   |   4 comments


The successor to the BlackBerry Bold 9000 – the Bold 9700 – will be available soon in the US. Is it worth upgrading? Reiter's got one, and offers advice.
Full Nelson
Financial Service Transformation: Part 3

Part 3 of 3   |  
See complete series
11|13|09   |   2:17   |   7 comments


In order for banks to grow, they'll first have to start by retaining their standing client bases. To do this will require better customer service and more transparency. Banks are meeting these needs through more automated commodity services and mobile banking applications.
Sweeney Blog
Microsoft's Relevance in the Windows 7 Era

11|13|09   |   2:17   |   3 comments


The release of Microsoft's newest OS raises the question of the company's relevance in an era when Google dominates applications and search, and Apple runs circles around Redmond with its gadgets and user interfaces.
Full Nelson
Financial Service Transformation: Part 2

Part 2 of 3   |  
See complete series
11|12|09   |   2:21   |   No comments


Data is at the heart of any financial services firm, but analyzing that data in real time, and making decisions and predictions based on that data, is where the future is – whether that is customer data, trading data, or even risk management data.
Full Nelson
Financial Service Transformation: Part 1

Part 1 of 3   |  
See complete series
11|11|09   |   2:22   |   No comments


Financial services companies are focused on modernizing and consolidating their core applications. The goal is to provide a holistic customer view, become more agile, and offer new products quickly, in a personalized way. SOA is one key building block of this transformation.
Rob Salkowitz
Wave Poised to Hit Enterprise

11|11|09   |   2:07   |   4 comments


Google flexed its collaboration muscles at the Enterprise 2.0 conference with a much talked-about Wave demo, but is the cool real-time application too big a leap for ordinary work tasks?
Tom Nolle
Stop Raining on the Cloud, Google!

11|10|09   |   2:18   |   No comments


Cloud computing is being dampened by the lack of local application support for offline use. Google's partnership with open-source should encourage it to build tight integration between Google Docs and OpenOffice, and thus boost the cloud and counter Microsoft at the same time.
The Incredible Hultquist
Tweet Less, Get More Clicks

11|9|09   |   2:24   |   No comments


Evidence shows that you can tweet too much. Sites and services like Twitter and Facebook are a good place to reach your audience, but think quality over quantity.
what.the.ferraro
Facebook Lacks Social Skills

11|20|09   |   1:53   |   1 comment


Facebook's 'Suggestions' for users demonstrate how little social networking sites understand about true social relationships.
Singer at C-Level
Smart Grid Opportunities

11|20|09   |   2:49   |   No comments


Industry initiatives and government stimulus funds are giving enterprise software vendors a great opportunity to help build out and manage smart grid technologies.
Tom Nolle
Total Telephony Transcends Telepresence

11|20|09   |   2:11   |   2 comments


The problem with telepresence is that it's not universally accepted, because video calling isn't. While we can all do video calling, we also apparently worry too much about how we look. If we want HD telepresence in our future, we have to dress down, mess up our hair, and dive into our online life.
what.the.ferraro
ThinkerNet Wins Min's Award for Best Blogs!

11|19|09   |   1:13   |   4 comments


ThinkerNet wins the Min's award for 'Best Blogs' – Internet Evolution's fifth award this year!
Full Nelson
SanFran.gov

11|19|09   |   8:51   |   No comments


Fritz has an exclusive talk with the mayor and CTO of San Francisco about that city's latest e-government efforts.
Robert D. Atkinson
America Has Much to Learn About Digital Piracy

11|18|09   |   2:09   |   No comments


The US loses about $20 billion a year on pirated software, movies, and music. But public policy can help stem the tide of digital theft. For example, France has recently passed a 'three strikes and you’re out' law, whereby if after two warning letters an individual continues to download pirated software then his Internet access will be cut off. US policy makers should consider adopting similar policies.
Singer at C-Level
Connecting Stakeholders: Part 3

Part 3 of 3   |  
See complete series
11|18|09   |   2:09   |   No comments


Financial management planning does not need to include Voodoo economics, but it does help to tap into the knowledge base of your team through some sort of real-time system. We explore your options.
Reiter's Block
Tweeting for Customer Support

11|18|09   |   2:20   |   No comments


When Reiter gets incensed over incompetent Verizon FiOS order-taking and support, he broadcasts it via Twitter. Did it do any good? How should your company offer Twitter support? Watch this for all the answers.
what.the.ferraro
Dogster.com More Popular Than Gov 2.0

11|17|09   |   2:05   |   1 comment


A lot of attention is being paid to launching Gov 2.0 Websites, but these sites aren't attracting a lot of visitors.
Reiter's Block
Is the BlackBerry 9700 'Bold' Enough?

11|17|09   |   3:07   |   4 comments


The successor to the BlackBerry Bold 9000 – the Bold 9700 – will be available soon in the US. Is it worth upgrading? Reiter's got one, and offers advice.
TechWeb The Global Leader In Technology Media