Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

Introduction

Sophisticated clients (e.g. Corporates, Large Family Offices, Hedge Funds etc.) have complex requirements. The standard Canopy offering is often not enough for their purpose and they need a complete Data Eco-System to be able to efficiently operate and serve all their various stakeholders. In addition they need the ability to directly work with their own data and incorporate it in various work flow processes.

Canopy Data Eco-System has the following charactertistics

  • Complete Canopy Toolkit: The entire toolkit of Canopy is included in this package for unlimited flexiblity.
  • Database Access: Customers get full and direct access (read and write) to their database (a segregated database with only that particular customer's data is created for that purpose). Customers can download all the information as required, but also connect other applications (e.g. a BI tool like Tableau) to the database directly.
  • Data Integrity: Canopy data upload and cleaning processes maintain the data integrity at the point of upload and on an on-going basis.
  • Security: The database is secure, encrypted at rest and only accessible from authorized computers in the client's office

Data Eco-System Wire Diagram

There are two main parts to process, namely:

  • Data Input and Cleansing
  • Data Analytics and Output

Possible Use Cases

All sorts of reports and analysis is possible. For example

  • Liquidity and Cashflows
  • Assets and Loans
  • Every single transaction with all your banks across all your entities / geographies
  • Hedging and hedge effectiveness
  • Reports for Management / Investors

Connecting to the Database Directly

There are many ways of connecting to the database directly. For example

Details on the tables inside Canopy Data Eco-System

Currently there are 4 main tables inside the Database. We are constantly adding new tables based on customer feedback, so pls check here for details in case you see a table you do not recognize

  • Consolidated_Holdings: These are a daily snapshot of all your assets and liabilities for every child account that you have
  • IRR_Table: This has the XIRR and absolute return made in USD for every security for every child_account
  • Transaction_Snapshot: This is all the transactions in your account marked to market as of the last valuation date


Some Sample dashboards and some other useful links are attached below




  • No labels