Author Archive | Andy Graham

How much master data do you have?

Organisation’s are storing/creating more and more data year after year. This is an ever increasing problem. So how much master data does a typical organisation actually have? Let’s look at two examples: Example 1/ A local government organisation for a city or a state/county. In the UK we call these county councils. Probably has a […]

Continue Reading

Redundant Data

Redundant data can be both a benefit and a problem to organisations but ultimately it means we have more data to manage. Some redundancy is clearly required for backups and optimisation reasons but unknown or inconsistent redundancy is a disaster. I would like to get some sense of the level of redundancy of data that […]

Continue Reading

Update to 2011 predictions

Back in early 2011 I made a number of predictions in relation to the world of data architecture and data management. In this blog I’m going to revisit those predictions and see how well I scored. So starting from the top my predictions (and results for the year) are as follows: 1/ Data Security will […]

Continue Reading

European data protection laws get more aggressive

In January the European Union commission on data protection is intending to publish proposed legal changes that will have huge potential fines attached. Companies found to be mishandling personal data can be fined up to 5% of global turnover. This means we could see fines entering the billions of euro’s for global organisations. This is […]

Continue Reading

A rant about data and information architecture

Data is unquestionably the life blood of any organisation, but it is paid less attention than it deserves. It is more important than technology and software application but in most organisations it doesn’t command the same level of respect. If you don’t architect your data the consequences are widely understood. Examples of these consequences are […]

Continue Reading

Data Architecture Training Course

Todays blog is a piece of self marketing so apologies upfront. I have recently launched a data architecture course as there seems to be a bit of a gap in the market for courses that focus on the non vendor or more strategic elements of the data architecture role. The course covers subjects such as: What is a […]

Continue Reading

Why is Data Quality an Issue?

We have all heard the stories of letters sent to dead customers either though the company has been told about their death or cheques sent out for £0.00. Companies are continuing to risk damaging their relationship with clients and their hard won professional reputation by paying too little attention to the quality and organisation of […]

Continue Reading

Conformed Dimensions and Inheritance

One specialised and high profile aspect of any organisations enterprise data architecture is the delivery of data for analysis and reporting purposes. This is known in the industry as data warehousing and business intelligence. A common data structure used within this area are dimensional data structures. One particular dimensional data structure concept that is often […]

Continue Reading

Multi Language Data Warehouse Design

As the world becomes more global in nature it’s not surprising that multi language data warehouses become more and more desirable. In today’s post we are going to looks at a dimensional design approach that fulfils this need whilst providing a relatively simple design pattern that can be used throughout your multi-lingual data warehouse. Let’s start […]

Continue Reading

A few Predictions for 2011

It’s been a good few weeks (even longer probably) since I last sat down at my desk and wrote a blog entry. My consultancy work has been a bit too full on, plus Christmas has meant time has just slipped away. Anyway I decided it was time a wrote my predictions for the coming year […]

Continue Reading