Blog: Mike Ferguson Subscribe to this blog's RSS feed!

Mike Ferguson

Welcome to my blog on the UK Business Intelligence Network. I hope to help you stay in touch with hot topics and reality on the ground in the UK and European business intelligence markets and to provide content, opinion and expertise on business intelligence (BI) and its related technologies. I also would relish it if you too can share your own valuable experiences. Let's hear what's going on in BI in the UK.

About the author >

Mike Ferguson is Managing Director of Intelligent Business Strategies Limited, a leading information technology analyst and consulting company. As lead analyst and consultant, he specializes in enterprise business intelligence, enterprise business integration, and enterprise portals. He can be contacted at +44 1625 520700 or via e-mail at mferguson@intelligentbusiness.biz.

March 2008 Archives

In 2008, some 18 years since I moved into the BI sector of the industry, you would think that this space would be exhausted. Yet here we seeing more announcements from relatively 'new generation' vendors agressively going after this market. I refer of course to the announcement yesterday between LogiXML and Vertica on integration between LogiXML’s Web-based BI platform with the Vertica Analytic Database. It seems clear that columnar data warehouse appliance vendors are climbing the popularity charts with Vertica, ParAccel and SybaseIQ all gaining ground. LogiXML is clearly also on a growth path with its web based BI platform. With consoilidation still happening in the BI market, it would be no surprise to me if these kinds of partnerships ultimately go further in future but for now, companies should not assume that just because the software giants (IBM, Microsoft, Oracle and SAP) have made their moves into the BI market that the game is over. This kind of announcement really offers an attractive and competitive alternative


Posted March 25, 2008 11:10 AM
Permalink | No Comments |

Over the last year or so I have noticed a real surge in companies using or evaluating products to rapidly develop dashboards. In my consulting activities in this area, I have been amazed at the reliance on one particular primary source of data that users have latched onto in dashboard development. This is of course Excel data. While there is nothing unusual about Excel data, it is the trait that users almost 'prefer' to access Excel data (because they are familiar with Excel) that I find concerning. Many users seem to either just have these spreadsheets or are downloading data into Excel from a range of data sources including operational systems, flat files (perhaps supplied from some other department or system), data marts and data warehouses. Once data is 'in the wild' like this, it takes on a life of its own with people manipulating it and sending it to others via email attachment. It's like data management just got left behind.

While Excel can never be ignored in any organisation, the increasing demand to analyse Excel data raises questions as to whether or not that data can be trusted especially if you have been sent this data in your email. It brings back the issue that has plagued many companies for years when it comes to Excel. Do you know where the data in the spreadsheet came from? How do you know you have the right version of the spreadsheet? Are spreadsheets managed? Is there other server side data sources that can be accessed from the dashboard tool that would give you more confidence in trusting the data?

With Office Excel 2007 increasing the maximum limit on the number of rows in a spreadsheet from 64000 to 1 million, my concern is that the increasing demand for dashboards will raise the likelihood of million row "spreadmarts" being created all over the organisation by business users rather than pointing dashboards at server side data in a BI system. Only time will tell however policy is clearly needed around spreadsheet management and dashboard development if we are to remain in control of the data and have confidence in it. I would be interested in hearing from many of you out there who are encountering this problem and what you are doing to manage it


Posted March 22, 2008 10:52 PM
Permalink | No Comments |