Feeds

Gearing up for DIY BI

BI for the masses - if they're ready for it

The essential guide to IT transformation

Comment Every coming trend or market needs a good name to define it, so let’s try this one: DIYBI, the Do IT Yourself Business Intelligence system.

The premise being put forward by companies looking to move into DIYBI is that BI so far is only being performed by the largest enterprises, and then only by white-coated rocket scientists operating as something close to a secret society. Now, they say, it is time for BI to be open to `the masses’ as a self-service offering that no longer requires a trip to the BI Masonic lodge.

Microsoft is, of course, the big name player that is now starting to sniff round the BI honeypot currently sweetening business for the likes of SAS Institute, Business Objects, Oracle, Information Builders, SAP and Cognos. These companies mainly pitch BI at the high-end enterprises, and are accused of creating an environment where mere mortals such a business managers are obliged to ask the BI `rocket scientists’ for any information they require.

But the trend towards empowering those massed mere mortals is now well underway, though they will need to look carefully at what they think they are buying, for not all BI tools are born equal. This is not to knock them, however. More it is just important for users to understand that, for example, an analytical presentation tool will only be as good as the data - and the data management environment - that underpins it.

As the direct interface to the user presentation tools are vitally important and as Dan Vesset, research director of IDC, has been quoted as saying in a press release from Spotfire, “reporting and dashboarding software often falls short in providing true decision support functionality for business professionals.” True enough, and Spotfire is claiming that its new DXP (Data Experience) offering helps overcome that problem, not least by packaging up some of the common queries business people need to make. So there is a range of `solution-configured’ packages for sales, marketing and portfolio management.

The company has also introduced Guided Analytics as part of DXP. This allows users to publish a guided walk-through of their view of an information set - a BI `slideshow’ in a way, that seems like a potentially useful tool. There is also DXP Metrics, a collection of embedded statistical routines together with a tool for building statistical expressions. Built on .NET, DXP can connect to whatever databases or data results the user needs.

Quality assurance

By packaging up statistical routines and standard queries for common market sectors DXP will certainly take the masses some of the way towards BI, though it is not unreasonable to observe that it will only be as good as the management of the raw data on which it draws - the validity and quality of which is the equally important alter ego of BI, and something the `rocket scientists’ tend to take quite seriously as an integral part of the BI mix. Quality assurance of the data used is really the crux of BI and usually one of the expensive parts of the process. Poor or zero data QA management will invalidate the reason for having BI at all, and could be seriously damaging to a business in the hands of the naïve or unscrupulous.

Because front-end systems need a back-end to drive them, one trend that will be seen as vendors jockey for a share of the BI-for-the-masses market is rationalisation via acquisition. The latest example of this has been the move by Applix to acquire Temtec International BV. The latter’s Executive Viewer is an analysis and reporting front-end tool aimed at the self-service-analysis sector. It integrates with a number of back end systems, such as Hyperion Essbase, Microsoft Analysis Services and SAP.

Applix plans to use it to provide a single interface to performance management systems that can be applied across a diverse range of business monitoring and management requirements.

And is all this Business Intelligence needed? Well, according to a survey conducted by Vanson Bourne for Microsoft, the answer is yes. This report sets out to establish that businesses - and UK businesses in particular - have very bad Business IQ because they are not using BI properly or at all.

One of the problems it identifies is a traditional one, and not necessarily a BI one at all: namely, that much business information and intelligence is held by people rather than the system, and that there is a need to break down these information silos. That, however, is arguably more a cultural and knowledge management issue than a BI one.

According to the press release, it does seem that the report uses some strangely irrelevant statistics to help make its point, such as `63 per cent of organisations using BI technology deploy Microsoft SQL Servers while 33 per cent use Business Objects’, which does seem to be a `car/combine harvester’ comparison. But despite that, there is a point to it - that there is a need for DIYBI, and for it to really take off there is still a good deal of end user education required. ®

Secure remote control for conventional and virtual desktops

More from The Register

next story
Munich considers dumping Linux for ... GULP ... Windows!
Give a penguinista a hug, the Outlook's not good for open source's poster child
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Intel's Raspberry Pi rival Galileo can now run Windows
Behold the Internet of Things. Wintel Things
Microsoft cries UNINSTALL in the wake of Blue Screens of Death™
Cache crash causes contained choloric calamity
Eat up Martha! Microsoft slings handwriting recog into OneNote on Android
Freehand input on non-Windows kit for the first time
Time to move away from Windows 7 ... whoa, whoa, who said anything about Windows 8?
Start migrating now to avoid another XPocalypse – Gartner
You'll find Yoda at the back of every IT conference
The piss always taking is he. Bastard the.
prev story

Whitepapers

Endpoint data privacy in the cloud is easier than you think
Innovations in encryption and storage resolve issues of data privacy and key requirements for companies to look for in a solution.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Solving today's distributed Big Data backup challenges
Enable IT efficiency and allow a firm to access and reuse corporate information for competitive advantage, ultimately changing business outcomes.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.