After my DW/BI post yesterday, a reader mailed me pointing me to the Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) Series by John Lowther. John has some great ideas – and recommendations, so check it out.
Here’s the summary from John’s blog -
As the last post in this series, I wanted to recap and try to give a high level of what we wish to accomplish.
If you remember on the first post we wanted to achieve two things, and that was not to hurt the performance of the Applications or of the BI Solution.
In the second post, we defined some generic ways of thinking about data in general. Things like concentric data, superfluous data, solitary data, relational data, etc.
Then we look at a way to keep the number of SQL Jobs down so that we have a maintainable system in the end.
Then we looked at a way to monitor the system to make sure that performance does not degrade over time.