Solovis Academy

About this Certification

Download the Exercise Guide

Course Player Tutorial

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

Quick Reference Card - Market Values

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

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)

Deferred Cash Transactions

Transactions Quiz

Quick Reference Card- Performance

How to Enter and Import Performance Data

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

Exposure Data Overview

Exposure Profiles

Exposure Rollups

How to Enter Exposure Data (Gateway portal)

How to Upload Exposure Data (Upload Spreadsheet)

Exposure Data Related Reports

How to Edit or Delete Exposure Line Items

Exposure Data -Profiles with Multiple tag sets

Performance and Exposure Data Quiz

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

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

Quick Reference Card - Benchmarks (Portfolio Analytics)

Quick Reference Card - Managing Benchmarks in Benchmark Blender

Benchmarks Quiz

Quick Reference Card - Asset Selection Sets

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

Quick Reference Card - Report Manipulation

Report Manipulation Overview

Report Manipulation: Sorting and Grouping

Report Manipulation: Column Settings

Report Manipulation: Filtering

Report Manipulation: Modifying Table Settings

Report Manipulation: Show as Chart Report Option

Report Manipulation: Select and Adjust Report Columns

Saving Reports as Featured Links

Report Manipulation Quiz

Introduction to Data Reconciliation & Review Process in Solovis

Data Reconciliation & Review Process Overview

Data Review Process in Solovis

Cash Account Balances Report

Above-Below Portfolio Mismatch Check Report Overview

Above-Below Portfolio Mismatch Check Report - Below the Portfolio Mismatch Example

Above-Below Portfolio Mismatch Check Report - Above the Portfolio Mismatch Example

Above-Below Portfolio Mismatch Check Report - Performance Comparison & Report Summary

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

Data Management Certification Survey

Verification of Course and Successful Quiz Completion