Achievement

    • Initial, tangible cost savings of $221,000

Function

    • Finance
    • Operations

Industry

    • Insurance

Products

    • QlikView

Aon reduces work load and clarifies revenue segment

Aon’s management needed a clearer picture of the company’s revenue streams, starting with the ability to segment revenue by industry and product.

As the leading provider of risk management services, insurance, reinsurance brokerage, human capital and management consulting in Asia — and as part of Aon Corporation, which employs approximately 47,000 professionals in its 500 offices in more than 120 countries —segmenting revenue was difficult and time consuming.

The existing situation made it difficult to gain a true view of the company’s income across different offices, even within a single region. As a result, it was hard to allocate the correct fees and commissions among their regional directors and country segment heads.

Each step in the chain required someone to manually compile the data and check for errors — a time-consuming process involving extensivefollow-up with separate parts of the business. It also led to the possibility of having different versions of the same data coming from different sources. The search began for a packaged solution that could make the process easier for everyone — by automating the processingand analyzing of financial streams.

Immediate Impact

According to Glen Francis, the regional Project Manager for this initiative, cost and ease of use were extremely important factors. Aon Asia had only 3 employees supporting the 12 countries in the region with one other employee dedicating half of his time to the project. “We needed to find something other than traditional OLAP tools, which require a lot of internal and external resources to implement, deploy and support.”

A local reseller referred them to Qlik. After seeing a live demo, Tom Gill, regional CIO, and team were impressed with the product. Aon began a trial period and developed a “show and tell” demo application for the management team.

Keith Edmonds, regional manager and architect for the data warehouse, built a QlikView application to analyze revenue across a number of dimensions. These dimensions included by region, by local office and servicer (account representative), by product line, by industry and by client type (new or existing client). The team demonstrated this application prototype during their annual regional CFO/CIO conference and then to Chairman. When they presented revenue detail by client, the Chairman and CEO for Asia Pacific said, “This is the information I’ve wanted for the past 10 years.” The project gained immediate approval.

After further refining the revenue analysis applications, Aon launched a project to use QlikView for their company’s budget process. QlikView was leveraged to help employees create data for their budget worksheets, including actuals, current figures and forecasts for the next fiscal year. When these worksheets are completed, they are uploaded to Qlikview for reporting. The automated process saves a significant amount of effort and time in getting and consolidating financial information from hundreds of employees.

Work loads reduced, clearer revenue understanding

Now, revenues are more clearly understood and segmented by geography, product, industry and client through the easy visualization of data using QlikView. Overlap has been eliminated, making performance very clear to each manager and thereby driving greater accountability.

QlikView has also allowed management to identify and address non-standard segmentations and identify strategic opportunities. According to Tom Gill, “The beauty is that we can now see exactly where things are performing well and where things have gone wrong. Before, we had multiple sources and never knew if a reporting problem was just bad data or a real issue. Now we can look at reports to see how the business is doing.”

Featured QlikView Customer Stories