You can use SQL Server for data warehousing in your enterprise.
The widespread use of data warehousing has been one of the most significant developments, after the Internet, in the information technology industry. Data warehousing is the process whereby an organization extracts data from its production information systems, and also sometimes from external systems, and stores the data in data warehouses optimized for query access and decision support.
Databases have mainly been used for online transaction processing (OLTP) systems, characterized by speedy transactions and rapid updates of data. Decision support systems (DSS) or data warehouses, characterized by large amounts of historic data, are gaining in importance.