An Enterprise Data Warehouse

The last project ended a complete success. So I have been running a new project for the last three weeks. This time I’m responsible for implementing a data warehouse. The overall project looks like its going to be broken down into two projects. The first project is going to last three months. The goal of this project is to build a single data mart for one area of the business. For this project I have a four man team. It consists of a BI Specialist, two Software Engineers, and QA Specialist. It will be interesting to manage a slightly larger team; although still smaller than the teams I manage at NG. One interesting aspect is two of team members are commuting from Philly each week.

We just completed the third week of the project. Everything is running smoothly so far. We have learned quite a lot about the company’s business processes. We have built a base architecture using SSIS packages within a SQL Server 2005 Enterprise server. We have extracted data from five different data sources. Two of these data sources used Oracle, two used SQL Server, and one used Pervasive SQL to store data. We have built preliminary dimensions and facts to prove our ETL methodology. All in all it’s been a successful three week.