Business Intelligence Lets ABB Controllers Get Right Information, Fast

The Situation

ABB, one of the world’s biggest companies in the field of power and automation technology employs over 100,000 employees. ABB’s Corporate Control unit processes and distributes huge amounts of information throughout the organization each month. As this process requires considerable resources, the company sought an easier, more efficient way to distribute and analyze the information from a group-wide ABACUS reporting system.

The Solution

Capgemini developed a data warehouse for ABB using the Microsoft ETL, Data Warehouse and OLAP cubes tools. Incoming results, forecasts and budgets from the group reporting system are gathered in the warehouse. ABB also implemented the ProClarity analysis and presentation tool, which displays the information and allows users to analyze it at every possible level.

The Result

Today, ABB has a very efficient method of distributing its financial information, so that it reaches all users at the same time, securely. Now each controller and manager at ABB can analyze the financial values of the current status, budget and forecasting at product and geographic levels, and all combinations of these, based on their own area of responsibility.