All Transactions - Schedule
The data model includes views like "All Transactions - Schedule," presenting a detailed schedule of financial transactions. Measures such as Amortization, Fees, Interest Amount, Maturity Amount, and Financial Line Amount are available to analyze and track the gradual loan repayment with principal and interest payments, additional transaction charges, total interest accrued, total amount due at maturity, and specific financial transaction amounts without using the count measure.
Benefits of This Data Model
- Enhanced financial analysis: The data model provides detailed measures such as Amortization, Fees, Interest Amount, Maturity Amount, and Financial Line Amount, enabling thorough analysis of loan repayment, transaction charges, interest accrued, and specific financial amounts without relying on count measures.
- Comprehensive transaction schedule: The "All Transactions - Schedule" view offers a complete schedule of financial transactions for in-depth analysis and tracking.
- Improved decision-making: With dimensions like Transaction Date, Transaction Montant, and Transaction Devise, the data model supports better decision-making based on specific transaction details and amounts.
Key Performance Indicators (KPIs)
- Amortization: The gradual repayment of a loan through periodic installments, including both principal and interest payments.
- Fees: Additional charges or costs incurred as a part of a transaction, typically outside of the principal amount.
- Interest Amount: The total amount of interest accrued on a financial transaction or loan.
- Maturity Amount: The total amount that is due at the end of a financial instrument's term or maturity date, including both principal and interest.
- Financial Line Amount: The total amount associated with a specific financial transaction or line item in a financial statement.
Available Visualisations
| View Name | Description |
|---|---|
| All Transactions - Schedule | Provides a complete schedule of all transactions for analysis. |