Overview

Transforming excel sheet to an interactive dashboard for accessing, visualizing, and analyzing 80K+ Leveraged Loan indices.

PitchBook is a financial data and research platform that provides information on private and public companies, investors, deals (like venture capital, private equity, and M&A), and market trends.

Impact

  • 4 hrs

    Saves per analyst for each research session.

  • 25%

    of support calls about Leveraged Loan Indexes reduced.

Contribution
User research, product design, prototyping.
Collaboration
Design lead (1), product manager (1), solutions (3), data analyst (1).
Tools
Figma, Zoom, Lucidchart.
Client
PitchBook Data
Notes
This is a limited case study. Please contact me for more details.

Business problem

Keeping users in platform.

With the acquisition of Leveraged Commentary Data (LCD), PitchBook brought in a plethora of Leveraged Loan indices to their platform. However, this access was only available through two main methods: APIs and direct Excel downloads. Because Excel files are static, they saw a demand to integrate these key reports into their platform as a market analysis tool.

One tab of the Leveraged Loan Index spreadsheet: a dense table of returns by month.

User problem

Retrieving scattered data from multiple tabs.

Manual effort to download and break out data.

With 18 tabs and 80+K data points, getting specifics of a few loans that they worked on was a challenge. Plus, every week, they had to download, extract and break out the data just to see the value of the updated index they were working on.

Lack of visual representation for quick scanning.

Due to static file structure of the excel files and the large number of data on each tab, seeing the trends required additional steps. This elongated users access to meaningful data and slowed their benchmarking processes.

Process

Information architecture exploration.

Started by grouping and consolidating relevant data points. Then organized based on the most to the least used tabs and iterated further based on more user feedback.

The user flow through the analytics workspace.

Used lo-fi iterations to get buy-in from stakeholders.

Translated the user findings and needs into features through lo-fi prototypes and tested them with the research and solutions team to get feedback on the user flows and key features without distracting them with visuals.

Three wireframe versions of the dashboard, each with returns, industries, big movers and other data charts.

Challenges

Creating alignment and setting the expectations.

Showing different layers of data in a fixed chart.

Based on long-standing reports, the team was accustomed to a specific chart style and wanted it replicated on the platform, even though another format would have been more effective. This preference limited the amount of data we could display

Scoping and re-scoping to manage expectations.

Managing stakeholder excitement and multiple requests required a collaborative approach. I worked closely with the product manager and the team to prioritize needs, define the roadmap for the minimum viable product (MVP), and ensure we could move the project forward within the given timeline.

Solution

Analytics workspace for 80K+ Leveraged Loan data points.

The finished dashboard: returns statistics with a table and an industries chart.
Two views of the finished dashboard side by side: the Morningstar Leveraged Loan Index industries chart and its detail.
The finished dashboard: volatility of returns as a line chart.