Canopy Analytics Process
We offer the best investment portfolio management software for your business development needs. Learn more about our software solutions on this page today.
![](https://cdn.prod.website-files.com/5fd0d3a18dd35f7763578246/5fe1ce0f0a4b57a3332c34a0_5fd847eea4a2f94f1ccc0154_pexels-maxime-francis-2246476-min.jpg)
Canopy Analytics Process
Canopy Analytics Process has the following steps
- Create a Segregated Database for each Customer
- Upload Transactions to this database
- Run Infinitely Configurable Calculations on them
- Use Canopy Visualizer, High End Customized Reporting or Hyper Personalized Dashboards to visualize the results by reading the Tables in the Analytics Database
![Canopy Analytics Process](https://cdn.prod.website-files.com/5fd0d3a18dd35f14fd578285/61710923cef1dacd8ec04a11_ea8a0f4-210429_Canopy_Components.png)
Step 1: Create a Segregated Database for each Customer
Canopy always creates a Segregated Database for each customer (this is an inherent part of the setup process for a new customer) and no additional steps are required from you.
This database is usually in our secure cloud location(s). However we can support this database to be in a cloud location of your choice/belonging to you. You can also get full read/write access to the database if so desired.
Step 2: Upload Transactions
Our public confluence page has a very good summary and a video demo of how to load transactions into Canopy
Step 3: Run Infinitely Configurable Calculations
3.1 Define a Strategy
Each strategy has Strategy Type and a Strategy Name and the Strategy Type + Strategy Name combination is unique for each user. Each Strategy also has a unique Strategy ID (which is an integer).
Users can create any number of Strategy Types and Strategy Names. Some Strategy Types are 'reserved' and are automatically created by Canopy Analytics Engine for each account. These are
- by_entire_account: One is created for each parent account and covers all transactions in that account
- by_child_account: Covers all transactions in each child account
- by_user_asset_class: One is created for each asset class defined by the user in their account.
- by_canopy_asset_class: One is created for each Canopy Asset Class in the account
- by_security: One is created for the most important securities in each account
Each Strategy is automatically stored in the Strategy Definitions table
3.2 Run the analytics engine
This can be run either of
- Strategy menu option in Visualizer
- Run Strategy button in Excel Add-in
3.3 Store results of these calculations in the Segregated Database
This step is automatic. Canopy Analytics engine will store the calculation results in the Consolidated Holdings and Strategy Records table(s) every time you run a calculation
Step 4: Visualize the Results
Almost all data visualization you see in Canopy (e.g. High End Customized Reporting and Hyper Personalized Dashboards) do it by reading the database in the Tables in the Segregated Database