Rittman Mead - Delivered Intelligence

OTN have just published my article on
Data
Profiling and Automatic Correction using Oracle Warehouse Builder 10gR2. It
takes a look at the data profiler, and how you can use the results to generate
data rules and data corrections.

If you’re looking to use OWB for a data migration or data cleansing project,
or you’re interested in one of these […]

On the basis that Tuesday and Wednesday seem the most popular days, and we don’t want to leave the
blogger event until too late in the week, I’d like to propose the
evening of Tuesday October 24th, from 7.00pm, for the 2nd Annual Open
World Blogger Meetup.
Having taken a look through Wikitravel
for decent bars in San Francisco to […]

After being away all last week, next week’s going to be a bit nicer, with two
days working for a client in the record industry in London, the UKOUG
Business Intelligence & Reporting Tools SIG on Wednesday and then two
days working out of Brighton. The record industry client is a particular
favourite of mine - they’re based in […]

To my mind there are three types of BI query tool - those from database vendors, the traditional vendor agnostic suites such as Business Objects, Cognos and Microstrategy and the high-end specialist tools used by data analysts with PhDs in the subject.
For a long while the database vendors achieved a low market share; customers either […]

Many years ago I worked for a company (in some ways, through the vagaries of mergers and divestments, I still work there) that had a commodity view of BI. The big plan was to implement a generic database on a Tandem Non-Stop machine and offer a ‘blackbox’ service to host data and provide reporting to […]

Well, I’m back home in my own house tonight after my week of misery and despair
in my hotel in
Newbury. I guess I’ve been spoilt recently working up in Soho, London, but a
week of nights on my own in a bleak single room, with only a sandwich to look
forward to the next day from the Texaco […]

I was working today with the latest beta release of OWB “Paris” and looking in particular at the new data profiling and cleansing features. Data Profiling is one of the major new features in Paris, and what particularly caught my eye was the ability of the tool to automatically build correction mappings for data that […]

Thanks to all the people who had kind words to say yesterday
when I was feeling a bit down in the dumps; it was my son’s first day
at school yesterday but instead I was working onsite with a client on a
new data mart project. I’m usually a pretty positive person and it
doesn’t usually take me much […]

The children our growing up fast. The elder wanted to go to a concert by a popular beat combo. Sorry, a “Rise Against” gig at the Academy in Birmingham. She had originally arranged to go with friends, however as she was the only one with foresight to get a parent to buy a ticket before […]

Whilst I don’t usually have much of a problem working away for
a few days, today was my four year-old son’s first day at school, and I
wasn’t there to take him down to the school and see him off. He’s been
at nursery two days a week up until now, so going to school isn’t
something that concerns […]