To meet this challenge, it is necessary to integrate, consolidate, and summarise information from heterogeneous data sources. By doing this, you create a data warehouse - a large, central data store where information is collected, organised, and made readily available to decision makers for more automated analysis. Since the introduction of OLAP with SQL Server 7.0, Microsoft has become a leader in providing the foundation for Business Intelligence. In SQL Server 2000, you get all the advantages of this foundation with increased functionality, web-ready benefits, and additional scalability. Data warehouses serve the needs of an entire enterprise.
Data marts serve specific business units or functions.
With data warehousing, you deliver sophisticated and interactive analytics throughout your organisation and to your trading partners, customers, and suppliers. High Scale, High Performance Data warehousing also helps you build highly scalable, high-performance business intelligence solutions that take advantage of the most advanced database engine in the industry. End to End platform Integrated tools allow you to build, manage, and use your data warehouse for fast time to market, improved productivity, and lower total cost of ownership. Bridging the Data Gap Without a successful prototype, a bank's most sophisticated data warehousing project could collapse. At approximately 11am, the US's Tacoma Narrows suspension bridge slowly began to sway.