Case Study: BI Portal Gives Pump Manufacturer Daily Access to Business Data for Better Decisions
Colfax created a Web-based reporting solution that automatically pulls current business data from four enterprise resource planning systems (SAP, Movex and IFS) and creates customized, user-friendly reports. The solution was built using DSP Portal Edition, Microsoft Windows SharePoint Services, Microsoft SQL Server 2000, and SQL Server Analysis Services. The solution gives executives timely data for making daily decisions and eliminates the need for manual report generation, yielding an annual savings of U.S.$180,000 and 2 months ROI.
Colfax is a global manufacturer of industrial pumps and fluid-handling solutions with companies in Germany, The Netherlands, Sweden, and the United States. Creating monthly reports for executives used to take two full-time analysts two weeks. By the time managers received the reports, the data was a month old. With the help of Microsoft Certified Partners Meta-Logix and Decision Support Panel, Colfax created a Web-based reporting solution that automatically pulls current business data from four enterprise resource planning systems and creates customized, user-friendly reports. The solution was built using Microsoft Windows SharePoint Services, Microsoft SQL Server 2000, and SQL Server Analysis Services. The solution gives executives timely data for making daily decisions and eliminates the need for manual report generation, yielding an annual savings of U.S.$180,000.
Read case study (PDF)
"By adding DSP to the Microsoft BI stack we were able to customize Web Parts . . . giving our employees in-depth information and key metrics, making it possible for them to directly act on the information now available."
- Lei Fu, Vice President of Business Applications, LendingTree
"Even without the POC on site, through only a few web meetings, we were shown a process which was promising. The identified gaps in the other POCs were solved in a very short period of time. Everyone involved showed they were knowledgeable in the field of financial planning and knew their software inside out."
- Stephan Rueckert, Director of IT and Business Process Management, Sterling Fluid Systems