Bob, In my opinion (and experience) there are two key areas of focus: 1) the business side: you really need to understand what the business wants to get out of their data warehouse. Many data warehouse projects come to grief because the team building the data warehouse didn't know what the business really wanted and by the time the data warehouse is complete the business still can't get what they wanted. 2) the technology side: I think this is affected by how seriously you need the data warehouse. The heart of the data warehouse is the ETL (Extraction-Loading-Transformation) process. Depending on criticality, response time and budget you could consider a range of solutions from in-house development to commercial tools such as Data Stage or Oracle Data Warehouse Builder among others. Don't forget the customer interface (e.g. Business Objects) and user training too. Just my 2 cents. Cheers Oscar -----Original Message----- From: skunkworks-bounces@lists.my.co.ke [mailto:skunkworks-bounces@lists.my.co.ke] On Behalf Of bob@kenic.or.ke Sent: 17 April 2009 10:51 To: skunkworks@lists.my.co.ke Subject: [Skunkworks] data warehouse Gurus, Just soucing for your input. When developing a data wherehouse proposal, what would you be keen on, Or what what whould be considered best elements of a data ware house. Comments are welcome. Bob. "Open source for open minds" -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general