All case studies

Financial services

The committee report that put every allocation change in one clear view

A financial services team's twice-a-month committee report pulled from one allocation export, but the slides made the changes hard to see. We consolidated them into one view per model and redesigned the deck so the committee could read what changed at a glance.

One consolidated, readable committee deck
Committee reports a month
2x
Allocation export as the single source
1
Per model: summary, then example
1 view

Before and after

The information was there. It was hard to read.

Before

  1. Allocation export
  2. Problem: Changes scattered across slides
  3. Screenshotted tables, long headlines
  4. Hard to see what changed
What we built

After

  1. One view per model
  2. Short, clear headlines
  3. Native tables and charts
  4. Outcome: What changed, at a glance
  • Every change in one place
  • Readable charts per model
  • Editable tables, no screenshots

01The problem

Twice a month, the team presents allocation changes to an investment committee. The numbers all came from one export. But the deck spread the changes across many slides, used screenshots for tables, and carried headlines too long for the layout. The committee had to hunt for what actually changed.

02What we built

A consistent deck structure that puts every change for a model in one place.

What the new deck does

  • Groups slides by model: a summary first, then an example
  • Splits one long combined headline into a short headline per group
  • Picks the chart view that fits each model, such as equity versus fixed income
  • Uses native, editable tables instead of screenshots
  • Leaves missing values off instead of guessing them

03How it came together

We built the first version against a real export on the first call. Then we refined it in small rounds from Will's feedback on the headlines, the charts, and the voting table.

How the work ran

  1. 01

    Real export

    Built on the first call

  2. 02

    One view per model

    Summary, then example

  3. 03

    Feedback rounds

    Headlines, charts, voting table

  4. 04

    Committee-ready deck

You were incredibly responsive... The first try didn't work out as well as we would have liked. And so... being able to go back to the drawing board a little bit and everything that you said you were going to do and on the timeline you said you were going to do it was accurate... Everything is exactly the way that I would have wanted it.
Will, Financial advisor team lead, financial services company

04Why it worked

It didn't add new software. It took information the team already had and made it easier to read and easier to act on. That's often where business intelligence should start.

The company is not named; the client is credited by first name. This project improved how existing information was presented and consolidated. It did not add new software, and we don't claim time savings we haven't measured.

Common Questions

Frequently asked questions

How do you make an investment committee report easier to read?+

Put every change for a model in one place, lead with a short summary, use one clear headline per group, and replace screenshots with real tables and charts the team can edit.

Do you need new software to consolidate financial reporting?+

Not always. In this project the data already came from one export. The improvement came from structuring and presenting it as a single view, not from adding a new system.

What kind of business intelligence work is this?+

Reporting and presentation. It's the step where numbers a team already has become a view people can read in one pass. Dashboards and automated reports build on the same idea.

Facing a similar challenge?

Book 20 minutes. We'll listen to how things work today and tell you whether there's something worth fixing.

More case studies

All case studies

Nonprofit

A Luzerne County nonprofit, now easy to find

What we did: Nonprofit website, Town-by-town pantry guide

100Lighthouse accessibility score on the launch build

Read the case

Nonprofit

A food pantry in Beaver Meadows, back on the web

What we did: Nonprofit website, Online giving setup

100Lighthouse accessibility score on every page

Read the case