Infobright

Saw a great presentation on Infobright, column-oriented database last night. It looks like an inexpensive, low maintenance way to speed up BI queries.  Their KnowledgeGrid concept seems like it could provide blazing performance - especially if you’re smart about how you sort your data on the way in.

For years we at Dataspace have been saying that, rather than picking a corporate BI Standard, companies should pick standards for business-focused BI applications (e.g. Dashboarding, OLAP, Ad hoc query, online reports, GIS, etc.).  Interestingly, the Infobright speaker pushed the same concept for databases.  The point is that there isn’t a job like, “Database.”  Instead, there are jobs like high performance OLTP, BI and reporting, unstructured data, etc.  

It makes sense.  Think about automobiles.  You don’t buy a generic, “Auto”.  Instead, you buy a sedan, or a sportscar, or a station wagon, or a pickup truck, or a van, or an 18 wheeler…  Could you use a sedan instead of a pickup truck?  Sure, for some jobs.  Is it wise to buy a sedan if what you need is a pickup?  Probably not; After all, how many shovels full of compost do you really want to be carrying in the back seat & trunk of your Altima?

Anyhow, if you’re having BI performance issues, this technology is definitely worth a look.  Want to kick it around, let’s talk!

— Ben (btaub@dataspace.com)

Business Intelligence: Where to turn now?

In my discussions with customers and others in the BI field I am hearing a lot of anguish about software vendors.  Many of the larger BI players have been sucked up into bigger companies and I’m hearing that these BI vendors, which were never customer-friendly to begin with, are now becoming downright customer-hostile – even with customers who have paid maintenance for the privilege of obtaining technical support.  Take a look at this article from CIO Magazine for more detail on the turmoil, and this article on Business Intelligence vendors to watch.

BI software vendors used to be grouped into the top three or four players, with open source and smaller players taking a far back-seat.  Things have changed.  Every week I’m seeing product announcements from new entrants.  Some of the tools look really good.  One I’m a big fan of, despite some limitations, is QlikView.  They’ve been around for a while, but are still relatively new compared with long-time BI players.

As consultants, we have the opportunity to work with a great group of clients, and we apply our expertise regardless of the technology they have already deployed – even if its one of the aforementioned customer service-challenged companies.  What to do, though, when a client asks us to recommend a new technology to help them rid themselves of their BI headaches, or make a new start in the field?  We’ve learned that the company behind a technology is as important to a successful implementation as the technology itself.  After all, you can get management dashboards, alerts, statistical analysis and basic reporting from virtually all of the established players.

So, who to choose?

Of course it depends on the application, but if you’re looking for enterprise-class reporting, dashboarding capability, the ability to email basic business intelligence to a broad audience, reasonable licensing models, and an independent vendor partner with a great reputation for customer service, the answer could very well be Information Builders, IBI, the creators of Focus and WebFocus.

What?  Isn’t IBI an old-line mainframe reporting solution?  That’s what I thought.  But, then I saw the technology demonstrated to one of my clients.  Is it perfect?  No.  Other major vendors like Business Objects, Cognos and MicroStrategy each have their unique advantages and disadvantages.  But, IBI really seems to ‘get it’ in two very important ways:

1) WebFocus provides flexibility but also comprehends a fact I’ve been talking about for a long time: MOST USERS DO NOT CREATE REPORTS FROM SCRATCH.  In most BI environments reports are created by IT and, perhaps, a few power users.  The vast majority of users don’t want to and don’t need to create reports from scratch.  (For more on this see my post on tying the BI tool to the user. )

2) IBI customers are genuinely happy both with the tools AND with the vendor.  As with any piece of software, tech support issues do occasionally arise, but the feedback I’ve received is that when they occur, they are given top priority.  Can you say that about your BI vendor?

We were so impressed with the research we’ve conducted, that we’re considering partnership with IBI.  If you are evaluating Business Intelligence tool sets, I recommend that you consider them.

– Ben