Rittman Mead - Delivered Intelligence

Ask a group of IT specialists (especially BI specialists) what is meant by Business Intelligence and you will probably get a different answer from each person. Some will take a very narrow view and focus on, perhaps, the backend database technology, a single reporting application, or even a specific way to analyse data. Others take [...]

Investment in Business Intelligence, as for all other IT endeavours, is driven by one of three factors: “Does knowing this information (at the right time) allow me to sell more?” “Does knowing this information allow me to reduce my business costs (e.g. buy cheaper, reduce headcount)?” and “Do I need to report this information to [...]

A while back I blogged about a data warehouse review we are doing for a customer. At the time I was less than impressed by the consistency of the approach to DW design and the lack of knowledge of how Oracle works and what is ‘built-in’ as functionality. I have now moved on to another [...]

You may have read in a previous Blog that I am a great believer in the use of constraints (not null, primary key and, of course, foreign key) in a data warehouse. In an Oracle data warehouse these constraints inform the query optimiser about relationships between dimension and fact data. Without this information features such [...]

Well that’s probably it from me for 2005, as I’ve just got a couple of days on-site with a customer and then I’m off until after the break (although Nick Goodman and I are talking about doing a “Review of 2005″ Podcast. so watch this space…) Until then, have a Merry Christmas and a safe [...]