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
52:43-
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
38:52-
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
-
-
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