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.

September 2009 Archives

Having read David Linthicum's blog on MDM and Cloud computing about the impact on data of applications moving off premise, I have to say that I couldn't agree more with him. What David is pointing out is that the fracturing of data caused by the adoption of cloud computing raises the importance of MDM in keeping disparate data synchronised.

This brings back memories of Business Process Outsourcing adoption several years back and what it did to companies that had no business process integration in place before they outsourced some process activities. The result of that strategy was that it fractured processes even more in many cases and sent some of the data outside the enterprise making it more difficult to get at. As applications go off premise there is a real danger MDM could get out of reach. It requires MDM to start to get implemented to get control over data. SalesForce.com data is already coming inside the enterprise via ETL tools into DWs. Several ETL vendors support this. I just don't think that there has been many bringing it back in to populate MDM. Siperian has some case studies of their MDM customer working with cloud applications - in particuar SalesForce.com. What it does say, is that pursuing a cloud computing strategy on external cloud based virtualized servers without a data governance strategy, could very well wreak havoc on any enterprise.

With virtualization being high on the agenda of many CIOs, I would suggest that they should also keep an eye on risk management and compliance otherwise they could well cause make it harder to achieve trusted data. Without MDM, a clound computing deployment strategy certainly puts an Enterprise Data Quality Firewall and data integration services high up the agenda priority list!


Posted September 28, 2009 1:07 PM
Permalink | No Comments |

First of all let me apologise to all my readers for not having blogged for a while. This year has turned out to be manic - crazily busy. I also confess to having become addicted to twitter - a "tweetaholic" where I have been micro-blogging. If you want to see my tweets you can do so here.  So I return to my blog the day after "Arthur Day" - 250 years ago yesterday a certain young Irishman named Arthur Guiness started a beer making company in Dublin. My topic today is that exciting topic of Enterprise Data Governance.  From research I did in a survey it was clear that many companies at the end of 2008 were not fully underway with Enterprise Data Governance in terms of getting their data under control and into a trusted, well managed state. Many had more to do in terms of organising themselves together with getting the necessary technology and processes in place to do this.  But the question I get asked the most is how do you know how well or poorly your company is governing its data? There are a few questions you can ask that will give you a good inkling.  These are as follows:

 

·         Do you know what data exists in your enterprise?

·         Do you have an inventory of data items in use?

·         How many names have you got for the same data item?

·         How many metrics with same name but with different formulae?

·         Do your Excel metrics formulae, DBMS metrics formulae, BI tool metrics formulae, ETL tool calculations, ... all agree?

 

If the answer is no to any of these questions, what chance do you stand of remaining compliant or of trusting your data? If you don't know how many different variations of a data item exist in your enterprise how can you govern your data?

 

Some other questions to ask here from a business perspective are:

·         How many times do your core processes break because of dirty data?

·         Have your company ever messed up an order and angered a customer because of dirty data?

·         In terms of compliance, do you trust your data enough to tell it to a judge?

 

In my opinion what companies actually need is an interactive data map so that you can press a button and see where your customer data is or where your order's data is.  In order to be able to do this you need to have common data definitions for your customer data attributes and for your order data attributes etc. In fact you need to have a common set of enterprise wide definitions for all core entity data, transaction data and metrics. 

 

Having established this, the next step is to discover where you data actually is. Therefore Data Discovery technology (albeit a new area in data management) is critical help do this. In fact I would go as far as to say that without data discovery technology it is very difficult to get data under control. Increasingly therefore we are seeing vendors acquire or build this kind of software.  Once you data is located you need to map disparate data definitions for the same data to common enterprise wide definitions to be able to see where data is. Physical column names, data models, BI tool semantic layers, reports, SPREADSHEETS, files, XML schema, Access databases... If you can't tie all these to the same corporate definitions how to you govern data?  This is where data dictionaries/ business glossaries are key.  Lineage matter.

Ultimately the objective is to get consistency across the enterprise. You have to unravel your spaghetti ball.  

This means you need to get organised correctly, get the right technologies in place and get the right processes in place for enterprise data governance. 

 

Master data is also part of the program. You need to find out where your master data is maintained. How is it synchronised? What screens on what applications are used to update it? Do you know? MDMis not as simple as it looks. It is often a multi-year investment. So ask yourself do you want to start with read-only or read write? If  you buy an MDM system and you start updating master data centrally, what happens if you are still updating it also in other applications? Companies need a well thought out strategy for MDM as part of the Data Governance program. I will be addressing this in further blogs in the near future.

 

For now though, let me salute my fellow Irish countryman. Arthur Guiness. If you are stressed out on Data Governance at the end of a hard week there is nothing like a decent pint to help you unwind. Cheers!

 

IMG_2224[1].JPG

 

 


Posted September 25, 2009 7:40 AM
Permalink | No Comments |