Data | Connect

Data Warehouse: One Source for Fund Data

Empower your team to make faster, more reliable decisions with a scalable, purpose-built data framework.

Back office · Operations & data teams

Data | Connect. Pull returns, holdings and benchmarks out of every silo and into one governed, standardised source of truth.

Data Hub

Every source in one place, reconciled. Sync custodian, platform, benchmark and file data into one validated dataset — through scheduled pipelines with built-in upload validation.

app.quantreports.com/sample-manager/sourcesConcept

Data hub6 sourcesNext run 06:00

Sources

Custodian feedDaily · 06:00
Platform extractDaily · 06:15
Fund admin · SFTPWeekly · Mon
BenchmarksDaily · 07:00
Weights.xlsxOn upload
In-house system · APIHourly

Connect a source

PipelineToday

Ingest12,480 rows
Validate3 exceptions
Reconcilematched to custodian
Publishreporting-ready

Recent runs

Today · 06:00Completed

Yesterday · 06:00Completed

Upload validation3 to review

12,477 of 12,480 mapped

Sources & pipelineEvery source mapped once, then pulled on a schedule and validated before it lands.

Connect your dataConfigure once

Custom IntegrationsGot a niche source or in-house system? We'll build the connector for you.
APIAll widgets, data and components can be exposed in API.
SpreadsheetsDrop in Excel / CSV files and map columns once: refresh after that is automatic.
FTPPoint us at your FTP/SFTP drop folder and files are pulled in on schedule, no manual uploads.

Support & automationOngoing

Expert SupportReal specialists on call to troubleshoot mappings, reconciliations and edge cases.
White-glove SupportOur team can build and maintain your data connections, so yours doesn't have to.
DatabasesConnect, sync and pull from your database, either cloud or on prem.
Pipelines & WorkflowsAutomate the path from raw data to reporting-ready, with no manual handoffs.

Upstream sources and benchmarksPlatformsFund administratorsCustodiansMorningstarPublic benchmarks

Portfolio Core

One taxonomy, applied to every holding. A structured record of every holding, classified by asset class, category and factor — custom-configured and fully auditable.

app.quantreports.com/sample-manager/taxonomyConcept

Portfolio coreBalanced 70Taxonomy v4

ClassificationWeight

Growth assets62.0%
Australian equity24.0%
International equity28.0%
Developed markets21.0%
Emerging markets7.0%
Property & infrastructure10.0%
Defensive assets38.0%
Fixed interest26.0%
Cash12.0%

Add a category

Category exposure

Growth 62%Defensive 38%

Portfolio model

BenchmarkComposite 70/30

Grouped byAsset class

Custom fields

esg_screenEnum

liquidity_tierEnum

internal_codeText

Audit trail

Sub-category renamed12 Aug · Ops

Custom field added04 Aug · Ops

Taxonomy & auditOne classification over the whole book, extended with custom fields and logged on change.

Classify & structureConfigure once

Investment TaxonomyA single hierarchy of asset class, category and sub-category, applied consistently across every investment.
Category ExposuresBreak down every holding by asset class, categories or any other factors.
Custom ConfigurationAdd custom fields to extend the model beyond the standard structure, to match how you actually invest.

Governance & modelingOngoing

Portfolio ModelGroup and structure by categories and benchmarks, with custom fields configured to how you actually invest.
Audit TrailEvery change to the book is logged and traceable, so you always know who changed what and when.

Before Quant Reports

Before

After

Data Foundation
Fragmented spreadsheets, unclear truth
Unified hub for financial data with one consistent source
Data Connections
CSVs, emails, brittle scripts
Managed connectors for custodians, fund admins, benchmarks, platforms
Synchronisation
Manual refresh, deadline risk
Automated, event-driven sync with real-time accuracy
Reliable Output
Hidden logic, fragile and hard to audit
Transparent, versioned pipelines built for finance workflows
Quality Control
Errors found late, patchy access
Validations, reconciliations, and full governance built-in

Accelerate your path to a single source of truth

By centralising, standardising, and automating your data, it eliminates errors, reduces manual tasks, and accelerates delivery—all while adapting to evolving compliance requirements.