Outstanding Evolution by Semester
The data model includes views tracking Outstanding Capital, Amortizations, Interests, Net Rent, Charges, and Maturities by semester. It enables analysis of sales performance, comparison of semester trends, identification of top-selling products, measurement of customer retention rate, and revenue forecasting based on historical semesters.
Benefits of This Data Model
- Improved Sales Analysis: Enables detailed tracking of outstanding capital, amortizations, interests, net rent, charges, and maturities by semester for comprehensive sales analysis.
- Enhanced Trend Identification: Facilitates comparison of semester trends through views like Outstanding Sales by Semester and Semester Comparison.
- Optimized Product Performance Analysis: Identifies top-selling products per semester to understand product performance and make informed decisions.
- Effective Customer Retention Measurement: Helps in measuring customer retention rate by analyzing the rate at which customers return each semester.
- Accurate Revenue Forecasting: Supports revenue forecasting based on historical semesters data, assisting in predicting future revenues with more accuracy.
Key Performance Indicators (KPIs)
- Outstanding Capital: The total amount of capital that has not been repaid yet within a specific semester.
- Amortizations: The sum of money paid towards reducing the outstanding loan principal within a semester.
- Interests: The total interest accrued on the outstanding loan balance during a semester.
- Net Rent: The net rental income received after deducting expenses and costs for a specific semester.
- Charges: Any additional fees or charges incurred within a semester related to the outstanding loan or rental agreement.
- Maturities: The total amount of loan principal that is due for repayment within a specific semester.
Available Visualisations
| View Name | Description |
|---|---|
| Outstanding Evolution by Semester | Tracks sales performance by semester for analysis. |