Please read this first

We designed Canopy to be able to handle Financial Data and Analytics for any use case ranging from the simplest to the most complex.

The diagram below shows various Components of Canopy, all of which work together to solve all the use cases we cater to.

Canopy Components (showing the typical workflow as Raw Data converts into Analytical Information)

The Components of Canopy are (in sequence of a typical workflow):

1. Canopy Extract: Helps extract tables from Bank and Fund Admin statements in PDF (or paper)
2. Canopy UL: Canopy UL (or Canopy Universal Language) is an Open Source format meant for bulk input and output of data into Canopy. There are two version
   • Canopy UL 1.0: Excel format that allows all sorts of activities (Transaction Upload, Creating Accounts and Securities, Upload Historical Prices etc.)
   • Canopy UL 2.0: Specialized format which contains Transactions and Holdings in one single spreadsheet (to allow upload and reconciliation in a single step)
3. Canopy Engine: Has 3 main functions
   • Data Transformation: Transforms all incoming data into Canopy’s format and uploads it into the Visualizer Database after checking for errors and inconsistencies.
   • First level of Analytical Calculations: Engine calculates Asset Allocation, Networth, Profit, Performance, Asset Allocation on a Child Account level and stores it in the Visualizer Database.
   • Housekeeping: Engine also does housekeeping like Creating Accounts and Securities etc.
4. Visualizer Database: This is Canopy’s master database. It stores all output from Engine and is the primary source of information from Canopy Visualizer (not to be confused with Segregated Databases we create for individual customers - see below).
5. Canopy Visualizer: This is our main client facing front end. It allows customers to slice and dice their data in multiple ways. There are three main functions of Visualizer
   • Visualize your data: Our flagship front end
   • Generate Reports: A powerful report generator
   • See Customizable Dashboards: Dashboard created in Canopy Insights can be embedded here
6. Analytics Calculator: This is a utility that
   • Calculates Analytics: Calculates the next level of analytics on data in the Visualizer Database. The calculation results are then stored in the Segregated Database.
   • Triggered in two ways: Analytics Calculator can be trigger either from the Visualizer or from the Excel Add-in
   • Auto-runs overnight: Since calculations can be time consuming, it usually updates overnight. Users can trigger a manual update whenever desired.
7. Segregated Database: There is a separate database for each client. It contains all data and analytics Canopy has for that client.
8. Canopy Insights: This is our self hosted implementation of Tableau and is used to make customized dashboards for our customers. Any dashboards made can also be embedded into the Visualizer if so desired

Visualize your Data and see Customizable Dashboards

Use the Visualizer to see your Data along with any Customizable Dashboards

Run Configurable Calculations on your Data

The Analytics Calculator can be triggered either from the Visualizer or from the Excel Add-in