We choose Microsoft SQL Server 2005 as the tool to build the data warehouse and OLAP cube.
Microsoft SQL Server 2005 provides the creation of a data warehouse, and data analysis of the operation of a series of tools, and also has a good graphical interface and a rich programming interface. Microsoft SQL Service 2005 Integration Service (SSIS) can fmish the data extraction, transformation and loading process.