A view of BI (part 2)

Friday, December 30th, 2005 by Peter Scott

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 […]

A view of BI (part 1)

Thursday, December 29th, 2005 by Peter Scott

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 comply with regulation?”
Of […]

Accidents waiting to happen

Wednesday, December 28th, 2005 by Peter Scott

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 […]

Customers do odd things

Monday, December 19th, 2005 by Peter Scott

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 […]

Merry Christmas & A Happy New Year

Monday, December 19th, 2005 by Mark Rittman

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 New Year, here’s […]

Website Design & Build: tymedia.co.uk