Feeds

Setting application data free

Liberating the user, or IT?

  • alert
  • submit to reddit

Security for virtualized datacentres

Workshop The best time to sell someone pain relief is when they are hurting, and so it was back in the 90s, when the first wave of ERP software was offered to customers to ease their suffering from point solution chaos and broken automation. The next best time to sell medication, of course, is when someone is looking forward to some future hurt, and the second wave of ERP was sold on this basis as a way of avoiding the pain of Y2K.

OK, so this might be a bit of a generalisation, and many organisations have invested in packaged applications for more positive and proactive reasons over the years. The point is, though, that the focus has generally been on fixing or optimising processes and transactions.

Yet simply going about business with such applications in the mix leads to the growth of a potentially valuable asset – business intelligence (BI). With each transaction captured, we accumulate a little more data on the way our business is performing and, as importantly, on interactions with those we trade with, whether on the buy or the sell side of the equation.

The truth is, however, that we generally do a pretty poor job of exploiting all of that goodness. In study after study we uncover gaps, inefficiencies and inconsistencies in the way information is managed and used. Despite almost every system having some kind of query and reporting component embedded in it, it’s still common practice for users to download information into spreadsheets so they can manipulate stuff offline.

We won’t dwell on the problems here in terms of user productivity hits, IT support overhead, compliance and risk management, etc. We also won't mention the dodgy differences between different information sources and the way gifted amateurs process the same or similar data using different assumptions, calculations and tools here, either. You would think with all of the automation we have in place, we’d be past all that now - but with very few exceptions, we’re not.

Meanwhile, there has been some useful stuff going on in the packaged application vendor community in recent years. From the smallest footprint accounting application to the largest suite of ERP and CRM software, it is becoming increasingly common to see sophisticated analytical and reporting capability either bundled or offered as an option. We are not talking about the old fashioned tabular reporting stuff here, it’s serious functionality that until very recently would have been considered the domain of specialist business intelligence players.

Unlike the latter, however, ‘accessibility’ has been the watchword, as in a packaged application context the aim is typically to cater for general as well as specialist users. Indeed, one of the phrases that we often hear nowadays is ‘embedded analytics’, which basically means injecting snippets of information and analysis into the business process at the right time, so even transaction workers can make on-the-fly decisions in an informed manner. An example here is presenting supplier or customer assessments calculated in real time, based on recent transaction history and the appropriate business rules, which can avoid the need for manual approvals, escalations and so on.

Beyond traditional core groups, there are many situations in which information derived from business application data is relevant to even non-users, i.e. those that don’t interact with the system directly. The ability to surface information through the company’s intranet portal or via Microsoft Office is therefore a welcome facility that has emerged over the past few years.

Whether it’s interactive dashboard or scorecard views for senior executives, or routine budget versus actual analysis for cost centre managers, more flexible access options mean there is a lot of potential to set free all of that previously locked up information for entirely new audiences.

But what are the practicalities? While we might want to wean users off their Excel habit, how well do business intelligence facilities or add-ons associated with application suites deal with different information sources? Is it a case of horses for courses, with some users served by embedded capability and others by separate dedicated business intelligence systems? And standing back from the technical detail, are business users generally getting hungrier for information, and if so, how is this impacting IT?

Whether or not you think the BI related efforts of packaged application vendors have the potential to liberate users or IT, it would be great to have your views and experiences in the comment area below. ®

Security and trust: The backbone of doing business over the internet

More from The Register

next story
Phones 4u slips into administration after EE cuts ties with Brit mobe retailer
More than 5,500 jobs could be axed if rescue mission fails
JINGS! Microsoft Bing called Scots indyref RIGHT!
Redmond sporran metrics get one in the ten ring
Driving with an Apple Watch could land you with a £100 FINE
Bad news for tech-addicted fanbois behind the wheel
Murdoch to Europe: Inflict MORE PAIN on Google, please
'Platform for piracy' must be punished, or it'll kill us in FIVE YEARS
Phones 4u website DIES as wounded mobe retailer struggles to stay above water
Founder blames 'ruthless network partners' for implosion
Sony says year's losses will be FOUR TIMES DEEPER than thought
Losses of more than $2 BILLION loom over troubled Japanese corp
Radio hams can encrypt, in emergencies, says Ofcom
Consultation promises new spectrum and hints at relaxed licence conditions
Why Oracle CEO Larry Ellison had to go ... Except he hasn't
Silicon Valley's veteran seadog in piratical Putin impression
Big Content Australia just blew a big hole in its credibility
AHEDA's research on average content prices did not expose methodology, so appears less than rigourous
prev story

Whitepapers

Secure remote control for conventional and virtual desktops
Balancing user privacy and privileged access, in accordance with compliance frameworks and legislation. Evaluating any potential remote control choice.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
The next step in data security
With recent increased privacy concerns and computers becoming more powerful, the chance of hackers being able to crack smaller-sized RSA keys increases.