Business Intelligence

Aperture™ by Apollo Hedge Advisors

Dashboards and reports on your own mortgage data, built by your team and trusted by everyone who reads them.

Overview

Most lenders already have the data. It is spread across the LOS, accounting, the hedge and a pile of spreadsheets, and getting a new report means waiting on someone who knows SQL.

Aperture™ by Apollo Hedge Advisors puts a governed model over your data and gives your team a drag-and-drop builder on top of it. Authors build and publish dashboards; everyone else filters, drills in and exports, all working from the same definitions.

What Aperture Does

Drag-and-Drop Dashboards

Arrange widgets on a flexible grid and save as you go, with draft and published versions so viewers only see finished work.

The Charts You Need

Bar, line, area, pie, combo, scatter, funnel, waterfall, heat map, KPI tiles, tables and pivot tables, with reference lines and comparison periods.

Filter & Explore

Dashboard-wide and per-widget filters, click-to-filter, calculated fields and Top N, plus full-screen and export from any widget.

A Governed Data Model

Measures and relationships defined once on top of your database, so every dashboard counts loans and dollars the same way.

Authors & Viewers

Authors build and publish; viewers explore without being able to change what others rely on. Permissions are enforced on the server.

Your Brand

Workspace branding and light and dark modes, so dashboards look like they belong to you.

How It Works

1
Connect Your Data
Aperture connects to your PostgreSQL or SQL Server database, or to a warehouse we build with you.
2
Model It Once
We define the measures and relationships your business uses, such as units, volume, margins and pull-through.
3
Build Dashboards
Your authors assemble dashboards for each role, from leadership to the secondary desk.
4
Share & Explore
Viewers filter, drill in and export, working from the same numbers as everyone else.

Built for Lenders

Mortgage-Ready Widgets

Mortgage-specific views such as mark-to-market and revenue sit alongside general-purpose charts.

Role Dashboards

Purpose-built dashboards for each team replace the report emails and spreadsheets they rely on today.

Separate Workspaces

Each client’s data and dashboards live in their own workspace.

Key Benefits

✓

One Version of the Truth

Shared definitions mean the numbers in every meeting match.

✓

Answers Without a Ticket

Your team builds the view they need instead of waiting in a report queue.

✓

Less Spreadsheet Risk

Dashboards replace hand-maintained workbooks and emailed reports.

✓

Grows with Your Data

Add sources to the model and every dashboard can use them.

Works Well With

Data Warehouse & Integration

One Source of Truth

Your LOS, accounting, payroll, pricing, hedge and servicing data brought together in one warehouse, in your environment.

Learn more →

Mortgage Pipeline Hedging

Pipeline hedging, TBA trading, best execution and direct investor commitments in one capital markets platform.