Solovis Reporting Certification

The Solovis Data Management Certification contains ten chapters focusing on:

  • Managing the Investment Model (Entities/Investments)
  • Maintaining Data (Market Values, Transactions, Exposure Data, Performance Data, Exchange Rates, etc.)
  • Data Reconciliation
  • Introductory lessons related to miscellaneous Portfolio Analytics Functionality

Time Commitment

The certification is designed to be flexible and fit into your schedule:

Average lesson length: ~3.5 minutes
Total completion time: ~6 hours
Pause and resume anytime
Content remains accessible after completion

Certification Curriculum

  • 1

    Certification Introduction

    • About this Certification

    • Download the Exercise Guide

    • Course Player Tutorial
  • 2

    Ch. 1: Investment Model

    • Quick Reference Card - Investment Model

    • Investment Model Overview

    • How to Create New Entities - Single Entry Option

    • How to Create New Investments - Single Entry Option

    • About Spreadsheet Imports (Entities, Investments)

    • About Data Import Codes for Entities and Investments

    • How to Create/Edit Entities (Spreadsheet Imports)

    • About the Special Entity Type Entity-Level Property

    • How to Create/Edit Investments (Spreadsheet Imports)

    • Troubleshooting Upload Errors

    • How to Edit Entity & Investment Properties (One at a Time) & How to Use the Since Date to Capture How Property Values Change Over Time

    • How to Use Spreadsheet Imports to Update Property Values in Bulk & How to Use the Date Column to Effective-Date Non-Static Property Values

    • About Properties & Property Types

    • How to Create Custom Property Definitions

    • About Tag Sets

    • How to Add a Custom Tag Set (Part One)

    • How to Add a Custom Tag Set (Part Two)

    • How to Modify Existing Tag Sets

    • Investment Model Quiz
  • 3

    Ch. 2: Market Values

    • Market Values - Quick Reference Card

    • Introduction to Market Values, Portfolio Analytics Value Estimate Updater, and Value Estimate Calculation Trace

    • Market Value Data Entry Fields

    • Introduction to the Value Estimate Updater & When to Manually Run It

    • Add/Edit/Delete Market Values from the Asset Info Page

    • How to View Archived Market Values

    • Market Value Grid Editor: How to Use the Market Value Grid Editor to Update Multiple Market Values in Portfolio Analytics

    • Market Value Grid Editor: Entering Estimated Returns to Calculate Market Value Estimates

    • Market Value Grid Editor: Currency Helper

    • Introduction to Market Value Spreadsheet Imports

    • Using the Create Market Value Upload Template Shortcut

    • How to Edit/Delete Existing Market Values Using Spreadsheet Imports

    • Default Value Estimation Methods Based on Special Entity Types & How to Override Using the Value Estimation Method Property

    • Market Value Types & Custom Estimate Levels

    • Market Values Quiz

    • Link to Book Values Course
  • 4

    Ch. 3: Transactions

    • Quick Reference Card - Transactions

    • Introduction to Transactions (Methods to Add Transactions, Transaction Groups, Impact of External/Internal on Performance Estimates)

    • Transaction Grid Editor Basics (Default View, PE View, Column Chooser, Keyboard Shortcuts)

    • Overview of Basic Transaction Properties

    • Entering Drawdown Fund-Related Transactions

    • Example "Above the Portfolio" Transaction Group (Investor Buy into Portfolio)

    • Modifying Transactions (Edit, Delete, Unlink, Make Primary)

    • Transaction-Related Reports

    • Checking for Mismatched Values Using the Above-Below Mismatch Check Report

    • How to Upload New Transactions using a Spreadsheet Formatted for Import

    • Using the PrimaryTxOffset Column to Create Transaction Groups

    • Transaction Imports: Creating Unique Transaction Import Numbers for Use When Updating Existing Imported Transactions

    • About the Import Trail (View Transaction Upload Details, Obliterate Transactions)

    • Transaction Upload Errors

    • Using the Balance Cash Tool in the Transaction Grid Editor (Requires Setting a Default Tx Cash Account)

    • Balance Cash Deferred Cash Transactions

    • Transactions Quiz
  • 5

    Ch. 4: Performance and Exposure Data

    • Quick Reference Card - Performance Data

    • How to Enter and Import Performance Data

    • Creating a Ready-Made Upload Template with the ‘Create Performance Upload’ Link

    • Exposure Data Overview

    • Understanding Exposure Roll-ups

    • Exposure Profiles

    • Entering Exposure Data Line Items Individually

    • Uploading Exposure Data Using a Spreadsheet Import (Includes How to Create Exposure Upload Template)

    • Exposure Spreadsheet Import Upload Errors

    • Introduction to Exposure Reports

    • Exposure Over Time Reports

    • Performance and Exposure Data Quiz
  • 6

    Ch 5: Exchange Rates

    • Note regarding this chapter

    • Exchange Rates Overview

    • Creating Currencies & Currency Pairs

    • Uploading Exchange Rates Using a Formatted Spreadsheet Import

    • More Columns & Import Directives for Exchange Rate Imports

    • Target Currency Report Parameter & Computed Estimates for Exchange Rates
  • 7

    Ch 6: Benchmarks

    • Quick Reference Card - Benchmarks (Portfolio Analytics)

    • How are Benchmarks Managed in Solovis

    • Creating a Single Entity Benchmark

    • Creating a Weighted Benchmark

    • Creating a Flat Return Benchmark

    • Creating an Excess Return Benchmark

    • How to Assign a Benchmark to an Asset

    • Benchmarks Quiz
  • 8

    Ch. 7: Asset Selection Sets

    • Asset Selection Sets Quick Reference Card

    • About Solovis Selection Sets

    • Selection Set Criteria Overview

    • Using Selection Sets with Upload Templates

    • How to Create an Ad Hoc Selection Set

    • How to Create and Save a Selection Set

    • Selection Sets Quiz
  • 9

    Ch. 8: Interacting with Portfolio Analytics Reports

    • Report Manipulation Quick Reference Card

    • Interacting with Portfolio Analytics Reports

    • Understanding the Date Parameter

    • Sorting, Grouping, Filtering

    • Table and Column Settings

    • Select Columns & Add Custom Columns

    • How to Export Raw Data to Excel (Quick Excel Export)

    • How to Quickly Show A Table As A Chart

    • Interacting with Portfolio Analytics Reports Quiz
  • 10

    Ch. 9: Data Reconciliation and Review

    • List of Data Reconciliation-Related Reports

    • Transaction Data Reconciliation: Cash Account Balances Report

    • Above-Below Portfolio Mismatch Check Report Overview

    • Transaction Data Reconciliation: Above-Below Portfolio Mismatch Check Report (Net Amount in Comparison)

    • Market Value Data Reconciliation: Above-Below Mismatch Check Report (Value Comparison - Entity-Below Value Deltas)

    • Market Value Data Reconciliation: Above-Below Mismatch Check Report (Value Comparison - Entity-Above Value Deltas)

    • Data Review Process
  • 11

    Ch 10: Liquidity

    • Liquidity Model Overview

    • Create Liquidity Model Part 1

    • Create Liquidity Model Part 2

    • Create Liquidity Model Part 3

    • How to Link a Liquidity Model

    • Liquidity Reports

    • Adding Tranches

    • Side Pockets

    • % of Initial Units
  • 12

    Survey

    • Data Management Certification Survey

    • Verification of Course and Successful Quiz Completion