Use case in the finance industry
Collection of needs
Mr. Smith manages an investment fund. He wants to develop an application to track the evolution of his customers' investments over time. To do this, he turns to the back-office solution.
He also wants to set up a decentralized database that allows him to catalogue his customers, instruments, and clients' portfolios.
Finally, Mr. Smith wishes to manage the performance of his investment fund through metrics that track financial movements over time.
Implementation
We offer an application model to Mr. Smith to meet his needs.
Our schema consists of 6 entities:
- Investment
- Portfolio
- Brokerage account
- Life insurance
- Customer
- Instrument
Investment
An investment has a quantity attribute and two virtual fields amount, whose function is $quantity * $instrument.price, and share, whose function is $amount / $portfolio.amount * 100. An investment depends on a portfolio and an instrument.
Portfolio
A portfolio has a virtual field amount, which is calculated as SUM($investments.amount). A portfolio belongs to a customer.
Brokerage account
A brokerage account inherits from portfolio.
Life insurance
A life insurance inherits from portfolio. A life insurance has a fees attribute.
Customer
A customer has an email, first_name, last_name, address, phone attribute and a full_name virtual field whose function is $first_name $last_name.
Instrument
An instrument has an attribute ISIN, label, price, risk level, and type. The possible types are stock and bond.
Management
In order to get an overview of his business, we suggest that Mr. Smith create metrics and charts.
Metrics
Mr. Smith wants to highlight the total amount of the investments made. To do this, we create the associated metric.
Sum of amount of investments
| Attribute | Value |
|---|---|
| Aggregate | Sum |
| Data | Investment |
| Field | Amount |
Charts
Mr. Smith wants to manage the performance of his business. To do this, we add a chart to the main dashboard to monitor the average investment amounts per month.
Average amount of investments per month
| Attribute | Value |
|---|---|
| Type | Column chart |
| Aggregate | Average |
| Data | Investment |
| Y-axis attribute | Amount |
| X-axis attribute | Month |