Data warehouse developed with help from Capgemini provides improved access to management information within the entire group.
“Capgemini is an excellent partner for us. It understands our business and has solid expertise in finance and IT.”
Thomas Andersson, Assistant Vice President, ABB
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.
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.
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.