[repost from Stephen Forte`s Blog]
Most developers are scared of “Business
Intelligence” or BI. Most think that BI consists of cubes, pivot/drill
down apps, and analytical decision support systems. While those are very
typical outcomes of a BI effort, many people forget about the first
step, the data warehouse.
Typically this is what happens with a
BI effort. A system is built, usually a system that deals with
transactions. We call this an OLTP or on-line transaction processing
system. Some time passes and reports are bolted on and some business
analysts build some pivot tables from “raw dumps” of data. As the system
grows, reports start to slow...