Course Description
The Data Management Certification contains ten chapters of content, with the core focus surrounding functionality related to:
- Managing the Investment Model (Entities/Investments)
- Maintaining Data (Market Values, Transactions, Exposure Data, Performance Data, Exchange Rates, etc.)
- Data Reconciliation
Supplementary material included in this certification are shorter chapters dedicated to reviewing some of the key concepts necessary for all users to understand – such as Report Manipulation, Liquidity Models, Asset Selection Sets and Benchmarks.
Altogether, the instructional videos included in this Certification total approximately 7 hours. This content is broken down into chapters and subchapters. On average, each video’s length is 3.5 minutes. Videos can be replayed as needed as you take the course.
Course curriculum
-
1
Certification Introduction
03:22 -
2
Ch. 1: Investment Model
61:28-
Quick Reference Card - Investment Model
-
Investment Model Overview
-
How to Create/Add New Entities
-
About Spreadsheet Imports (Entities, Investments)
-
About Data Import Codes for Entities and Investments
-
How to Create/Add New Entities using an Upload Spreadsheet/Template
-
How to View Entities
-
Creating Investments Overview
-
How to Create/Add New Investments in the Gateway Portal
-
How to Create/Add New Investments using an Upload Spreadsheet/Template
-
How to View Investments
-
Troubleshooting Upload Errors
-
How to Edit/Update Existing Entities
-
How to Update/Edit Existing Investments
-
Non-Static Properties & Effective Dates for Property Values (Properties As of Date)
-
About Properties & Property Types
-
What are Properties and Property Definitions? How to Create Custom Property Definitions
-
How to Delete Property Values
-
About Tags Sets (How to Create)
-
How to Update/Edit Existing Tag Sets
-
Tag Set Related Solovis Reports
-
Investment Model Quiz
-
-
3
Ch. 2: Market Values
51:24-
Quick Reference Card - Market Values
-
About the Solovis Value Estimate Updater/Service
-
Investment Value Estimation Methods
-
Entity Value Estimation Methods
-
Managing Market Value Estimate Levels
-
How to Create/Add Market Values in the Gateway Portal
-
How to Create/Add Market Values using an Upload Spreadsheet/Template
-
How to Edit/Delete Existing Market Values in the Gateway Portal
-
How to Edit/Delete Existing Market Values using an Upload Spreadsheet/Template
-
Market Values Quiz
-
Link to Book Values Course
-
-
4
Ch. 3: Transactions
69:19-
Quick Reference Card - Transactions
-
Transactions Overview
-
Transactions - Properties
-
Enter Subscription Transaction
-
Entering Subscription Cash Leg Transaction
-
Entering Stock Purchase Transactions
-
Entering Stock Purchase Cash Leg Transaction
-
Investor Buy Transaction
-
Investor Buy Cash Leg Transaction
-
Net Capital Call from GP Transaction
-
Net Capital Call Cash Leg Transaction
-
Drawdown Monthly Cash Flows Transaction
-
How to Enter/Upload Transactions using an Upload Spreadsheet/Template
-
Transaction Upload Results and Import Trail
-
How to Edit Existing Transactions (Gateway Portal)
-
How to Edit Transactions using an Upload Spreadsheet/Template
-
How to Obliterate Uploaded Transactions
-
Checking for Mismatched Values Part One
-
Checking for Mismatched Values Part Two
-
Balance Cash Overview
-
Balance Cash Multiple Transaction Legs Transaction
-
Balance Cash Deferred Cash Transactions Transaction
-
Transactions Quiz
-
-
5
Ch. 4: Performance and Exposure Data
45:37-
Quick Reference Card- Performance
-
How to Enter and Upload Performance Data
-
Creating a Ready-Made Upload Template with the Create Performance Upload Link
-
Exposure Data Overview.mp4
-
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
-
-
7
Ch. 6: Benchmarks
25:35-
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
-
-
9
Ch. 8: Report Manipulation
21:31-
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
-
-
10
Ch. 9: Data Reconciliation and Review
29:00-
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
-
-
12
Course Survey & Feedback