Summary
This series of articles showed a very simple example of building a data warehousing solution. Even with this sample, numerous steps must be taken to build an accurate, functioning warehouse. What’s more important, the warehouse is never "finished"—it continues to evolve and grow along with company’s reporting requirements. Therefore, before undertaking a DW initiative, ensure that you have appropriate support from the business owners. Although your boss might request a data warehouse overnight, he/she isn’t going to rip many benefits from such system. Be sure to mentor and educate your stakeholders so that their expectations are appropriate from the get-go.