Microsoft Information Technology Group (MSIT): Microsoft Cuts Costs and Improves Access to Information With Enhanced Data Warehouse
Microsoft Corporation has operations in 112 countries and more than 90,000 employees worldwide. To improve management of human resources information, Microsoft needed to accelerate query performance and ease maintenance. To improve performance, the Microsoft team tried multiple strategies, including designing OnLine Analytical Processing (OLAP) cubes to pre-aggregate summary data and hiring specialists to build indexed views. To accomplish these goals, the company deployed its new data warehouse technology. The solution tripled performance while simplifying management, and both users and engineers are more productive. As a result, the company expects to cut costs and drive user adoption.