Business Intelligence - Multi-Company

 
 

Multi Company Consolidation

Solution

Visibility Business Intelligence Reporting & Analytic Solutions

Solution Benefits

By applying a well-defined set of Visibility Business Intelligence Analyzer solutions the customer was able to:

  • Visualize information for analysis and decision support across all business units

  • Reduce the amount of time required to affect proactive changes to business processes

  • Effectively share engineering data across the enterprise

  • Deliver both de-centralized performance reporting AND consolidated fiscal performance information on demand

Customer Background

A Visibility client, located in the United Kingdom with annual revenues of $50M, manufactures antennas for the mobile telecommunications industry. The company is unique in its ability to provide solutions on a global basis to satisfy the wireless network infrastructure needs of the cellular, telecommunications and broadcast markets throughout the world.

Key Challenges

  • Lengthy financial reporting cycle at month end

  • Poor analysis of departmental performance

  • No departmental accountability or awareness of targets

  • Business analysis needed to cope with diversity and breadth of the business

Detailed Challenges

This company was founded in the early 1970s and has grown steadily, acquiring offices in Europe, Africa, the United States, the Middle East and the Far East.

The client must actively meet the changing demands of the continually evolving broadcasting and telecommunications industries while offering the most practical solutions.

The business consists of a number of distinct areas of activity including overseas sales operations, two project based business units (large and small antennae projects) and a manufacturing operation.

Prior to implementing the Visibility Reporting & Analytic solution, the company could only monitor business performance on a project-by-project basis. This was a time-consuming process making month end reporting slow and inadequate.

At the same time, the management of the company wanted to make each of its divisions accountable and entirely responsible for its own profitability. This would give the division sales operations the freedom to purchase manufactured assemblies from sub-contractors if a better price could be obtained, and the manufacturing operation the ability to work for third parties to maximize utilization of their resources. The objectives were to maximize overall profitability, ensure full utilization of resources, introduce an element of competition into the company and allow the divisions to focus on their core competencies.

With their previous system, analysis of divisional performance was impossible; therefore, management reporting to support the new structure could not be provided.

Solution Details

Utilizing proven interview techniques together with an analysis of analytic requirements driving the Customer's business, Visibility structured a data mart that retrieved information already captured in the clients' business systems. Particular focus was paid to the data represented in finance and operations across multiple business entities. Key performance information critical to the analytic data mart creation included:

  • Engineering data shared across divisions

  • Common general ledger coding structure so that each division uses the same general ledger codes and report their results in exactly the same way

  • Sales analysis codes providing common sales analysis capture across all divisions

  • De-centralize (by division) financial information for division profitability

  • De-centralize operational data providing each division’s inventory, purchase orders, sales orders and works orders.

Financial consolidation of financial data – A Finance data mart is used to provide a consolidated view for the overall company. The company’s management team is able to view financial performance by division and spot trends critical to making quick, fact-based decisions. The data mart makes it easy to provide side-by-side analysis of each division’s performance. With the flexibility provided, instant re-configuration of the standard reports is possible providing on-line analysis and answering ad-hoc queries.

The Reporting & Analytic solution and its' flexibility has resulted in the company’s ability to act proactively based on the key performance indicators suggested by each division. This flexible view has made it easier for the company to focus on business strategy and face the demands of their constant evolving industry. This totally new view of the business components has promoted a sense of competitive advantage.

 
 

Next

 
 
 
Stat Counter include code - add to each page to be indexed for searching