TheSQLGuru (9/20/2013)
I too will recommend Kimball.I will also add that I have been pulled into numerous DW projects as a consultant that were near or complete failures, in an effort to get them back on track or be successful. I have heard the same from others and from articles I have read in trade journals. Most companies that attempt data warehousing think they can just slap something together and it is a disaster. The best way to have a successful DW project is to engage with a consulting firm that has significant experience in doing it - there are SOOO many ways things can go south!! Note I say firm because data warehousing encompasses multiple disciplines and I don't believe there is a single person out there that can provide all the services you would need to make the project a success.
that is the truth.
I am currently busy with one such company.
the previous person made it so extremely complex that it became totally useless to business and impossible to maintain by any bi team.
this has become a total rework case.
My company specialises in bi
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”