# Charting market trends in ION Infralogic

_Product design case study by Paul Kennedy. [Portfolio home](../../index.md) · [View the full page](index.html)_

*Data visualisation · Infrastructure finance*

A chart module for Infralogic’s transaction data, helping lenders, GPs and structuring desks see how margins, prices, tenors and debt volumes move over time in the market they care about.

## Overview
- **Problem:** Clients could not explore the data visually
- **Role:** Product Design Principal, ION
- **Team:** I led two other designers on this project, appraising and guiding their output
- **Platform:** Infralogic web app, desktop, dark theme
- **Product:** Infralogic, part of the ION Analytics family
- **Scope:** Chart structure and behaviour, time controls, comparison and interaction colours.

### Results
- **Signed off:** Stakeholders approved the search-led direction
- **Built:** Chart module handed to engineering
- **Tested:** Users found it more intuitive, with fewer clicks to view chart data
- **Adopted:** Colour rules used across ION Analytics brands

## Research
- As a GP I want to see how EBITDA has changed over time in a market
- As a Lender I want to see price trends that account for generation capacity ($/kW)
- As someone on the structuring desk I want to see how prices and tenors have changed over time in a given market (geography + subsector)

### Key decisions
1. Two states for every chart
2. Ten years as the ceiling and the default
3. Compare in the terms people search with

## How people narrowed a deal search
- Sector + geography together: 30 of 70 sessions (42.9%) (Infralogic: Search chips, e.g. Europe + Renewables)
- Free text only: 21 of 70 sessions (30.0%) (Infralogic: All transactions search box)
- Lifecycle stage: 21 of 70 sessions (30.0%) (Infralogic: Status tabs: All, Live, Future, Closed, Cancelled)
- Dates: 12 of 70 sessions (17.1%) (Infralogic: Time range presets and timespan control)

share = sessions using the filter / 70 deal-search sessions; sector 38/70 = 54.3%, geography 40/70 = 57.1%, both 30/70 = 42.9%; sector + geography filter volume (266+184)/646 = 69.7%

## Interaction states
- Default (step 60): Background 60, white label
- Hover (step 65): Background darkens to 65
- Pressed (step 70): Background darkens to 70
- Focus (step 70): 70 plus a yellow #FFD600 border
- Disabled (step —): Shown on the state board; values not annotated in the file

## Margin rates in context
The clickable prototype: the dashboard, then the expanded chart

1. Closed deals, Europe + Renewables — Search, status tabs and Debt view set
2. Dashboard — Debt by country, debt by sector, margin rates, closed transactions
3. Expand margin rates — Chart takes the full width
4. Margin rates in the past 10 years — Time range presets and timespan control

**The toolbar only appears when needed** (Interactive prototype): My decision: expand Margin rates (top right) and the time controls arrive with the full chart.
**Time range presets** (Interactive prototype): Pick 3 years or Year to Date; Max (10 years) matches the data retention policy.
**Timespan control** (Interactive prototype): Drag the two handles under the axis to narrow the years. Hover a point for its value.

## Set the market
The search-led foundation: on the old site 94.7% of user actions were search or filter

1. All transactions search — Geography and subsector chips, e.g. Europe + Renewables
2. Filter by — Geography, Sector, Transaction Type, Investor Type, Dates and more
3. Which deals?
4. Equity or Debt?
5. Save search — Keeps the market so it can be reused and compared

**Search sets the frame for every chart** (Search and filters): Sector and geography were 51% of old-site filters, so they lead the search bar.

## Read margin trends
From the dashboard card to the expanded chart

1. Margin rates card — Dashboard view: chart, title and expand only
2. Expand — Opens the zoomed-in view with its toolbar
3. Time range?
4. Timespan control — Drag handles to zoom in and out across years
5. Split by deal type — Greenfield, Brownfield, Refinancing against a LIBOR benchmark
6. Hover a deal — Tooltip: deal type, month, margin and benchmark
7. Highlight outliers — Rings deals far from the benchmark

**The toolbar only appears when it is needed** (Margin rates: default card): My decision: the dashboard card stays quiet; the toolbar arrives with the zoomed-in view.
**Tooltip with context** (Tooltip on hover): The coloured dot matches the deal type; the benchmark sits beside the margin for comparison.
**Outliers stay visible** (Outliers highlighted): Outliers are ringed and the rest fade, so unusual deals are checked, not hidden.

## Debt over time
Issuance and maturity, with granularity and comparison

1. Debt next 10 years card — Closed, Europe + Renewables
2. Expand — Toolbar: time tabs, granularity, compare, download
3. Granularity?
4. Compare — Add another saved search to the same chart
5. View trendline — Optional overlay

**Granularity sits next to the time range** (Zoomed in by year): Year, Quarter, Month and Week share one dropdown, so the chart never moves.
**Fewer labels as columns get thinner** (Zoomed in by quarter): Columns narrow at quarter level, so only Q1 is labelled to avoid crowding.

## Prices and tenors
How loan prices move with tenor in a given market

1. Prices and tenors over time — Price against tenor in years, 0–20
2. Tenor as decimal or whole number?
3. Loan prices in the past 10 years — Expanded view with time presets 7 days to Max

**Two encodings tested side by side** (Tenor in decimals / Tenor in whole years): Decimals show the trend; whole years show the price spread at each tenor.
