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.

Subscribe to the Data Insider Newsletter

Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays

Subscribe to the Data Insider Newsletter

Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays

Resource Details

Microsoft logo
Provided by:
Microsoft
Topic:
Big Data
Format:
HTML