Project Description

User-Friendly Visual Reporting

JPMorgan, one of the world’s leading investment banks, develops innovative financial solutions for clients, including M&A advisory, capital markets, restructuring, risk and research platforms of unrivaled scale. An equity and analytics division of JP Morgan’s investment bank services was experiencing a lack of clear visual reporting which slowed business processes and resulted in double-billing.

The Challenge

An equity and analytics division of JP Morgan’s investment bank services needed a more visual way of communicating broker commission information without creating a drain on server performance. Additionally, the solution needed to be capable of handling navigation through the complex commission structure, which regularly double compensates traders. JP Morgan challenged Chateaux to create a more dynamic representation of their business that allowed for both a new visual user interface and the capability to handle the large amount of information that went into each commission report. The company also sought to cut down on the time-consuming process of creating a report in order to more effectively process commissions and pay its brokers.

After sitting down with end users to confirm the initial list of business requirements, it became clear they needed an entirely new way of building reports. Chateaux encouraged management to move away from their current Excel-based paradigm, which was unable to handle the thousands of imported data points, to Flex Reporting and a redesigned data structure much better suited to working within their BusinessObjects environment.

Chateaux worked with the client to create a list of critical information categories that could be chosen at a high level and then drilled down into for more details. The new delivery system was then tailored to the organization’s unique needs.

By re-architecting JP Morgan’s underlying data warehouse to be better suited to BusinessObjects, Chateaux technologists were able to create an interface that would allow users to develop their own reports on the fly for a variety of hierarchies and data sets. Chateaux also worked with end users to educate and train them on the new system and how to best utilize the new functionality.

JP Morgan’s new Flex Reporting solution created an intuitive, visual user interface that was easy to navigate for end users. Where they once used a spreadsheet system to deliver 10,000 data points on a single sheet, they now had the ability to define and develop reports on demand that were clear and easy to read.

Managers were able to access information and compile reports more quickly and effectively. What had once taken a week to compile, now only took a few minutes.

Broker commission overlap was easier to determine, and the department saved the organization more than $150,000 in excess broker commissions.

Flex Reporting was promoted throughout the organization as an example of the value of BI for increasing productivity and affecting the bottom line.

Chateaux was able to give us a great solution. They worked with our staff and mentored them on the proper use of BI solutions within our organization. They did a great job!
Cathie Jin, Analyst, JP Morgan