Case Studies: Manufacturing

The Hyundai Motor Company, which manufactures and sells vehicles around the world, wanted to analyze data from parts sales, vehicle sales, and other information to reveal subtle vehicle repair trends not discernable from warranty data alone. The company sought to identify and fix problems sooner, both in the field and on the assembly line, potentially saving Hyundai a significant amount of dollars in warranty repair costs and increasing the quality of the vehicles it builds. Working with partner Nagamoto Designs, Hyundai is deploying a business intelligence data warehouse using Microsoft® SQL Server™ 2005, running on Microsoft Windows Server™ 2003 Enterprise Edition. Hyundai anticipates the data warehouse will help it to reduce warranty costs by millions of dollars while enhancing customer satisfaction by detecting potential problems earlier.

To help its enterprise run more efficiently, Gates Corporation, a leading manufacturer of automotive and industrial belts and hoses, needed a monitoring system that could provide comprehensive reporting data on its 400 business-critical servers. By migrating to Microsoft® System Center Operations Manager 2007, Gates is benefiting from object-level server monitoring and accurate, reliable in-depth reporting. Consequently, Gates estimates that it will improve manufacturing productivity by 10 percent, boosting annual revenue by more than U.S.$10 million.

"This data warehouse opens up a lot of possibilities for us. Now we can get to the data that we need to understand how to serve our independent business owners better." Mike Olson, IT Supervisor and Project Lead for the Global Data Warehouse, Alticor

The Kruuse Group, a global leader in veterinary supplies, wanted more intelligence than it was getting from its Oracle-based business intelligence system. So Kruuse turned to timeXtender 2.0 software and Microsoft® SQL Server™ 2005. It now hosts 5 data cubes instead of 1, and 30 standard reports instead of 3. Customizations that took two weeks are now implemented whenever needed. Better analysis drives sales, marketing, and operational efficiencies.