Introducing Oracle Enterprise Data Quality

Thursday, August 23rd, 2012 by

Visually, BI dashboards and analyses can be impressive and appear to meet the user’s needs, but if the data displayed on the dashboards isn’t reliable or correct then those same users can quickly lose faith in what they contain. Therefore, it’s important that assessing and managing data quality becomes an important part of any BI [...]

Geography Hierarchies

Tuesday, May 24th, 2011 by

I have been thinking about address a lot recently, in part it was moving house and all of the 1001 people that need to be notified. In the main, though, it was thoughts inspired by a data warehouse project I am working on. For this DWH people are geo-located by their street address, but for [...]

Regular Expressions in OBIEE

Friday, December 18th, 2009 by

When reporting against an OLTP system, in many ways, OBIEE works like an ETL tool, transforming the source system data and presenting it as a star schema. After years of writing ETL code, if there’s one thing I hate to be without, it’s regular expressions. So, when working on a project to map an OLTP [...]

Data quality is not a one-off

Wednesday, November 12th, 2008 by

In my Blog post on End-to-end data quality I mentioned the desirability of fixing bad data at source. This certainly attracted comment both here and on other blogs for example One point to keep in mind about fixing bad data on the source; it is just that, fixing DATA. We are not fixing bad applications [...]

End-to-end data quality

Saturday, October 25th, 2008 by

One of our customers is about to embark on a significant BI project; but being in the “public sector” they have to (by EU law) publish tender documents so that qualified suppliers throughout the EU can bid to do the work. This means they have a gap of almost a year before the, yet to [...]

Website Design & Build: tymedia.co.uk