Financial Dashboards Advanced KPIs

The data model encompasses financial metrics such as total journal transaction amount and quantity, year-to-date (YTD) and last year-to-date (LYTD) revenues with running totals, monthly revenue figures, YTD variance percentages, as well as cost of goods sold (COGS) metrics mirroring the revenue structure. Key views include Revenue Turnover Variances, Debt Ratio, Sales by Segment 2: TY vs LY, Transactions by Account Group Code, and Key Performance Indicator View for comprehensive analysis and performance tracking.

Benefits of This Data Model

• Improved Financial Analysis: The data model provides detailed financial metrics such as revenue turnover variances, debt ratio calculations, and sales comparisons by segment to facilitate in-depth financial analysis.
• Enhanced Performance Tracking: With running totals for YTD and LYTD revenues, as well as monthly revenue figures, the data model enables comprehensive tracking of key performance indicators for better business insights.
• Efficient Cost Management: By mirroring revenue structures with COGS metrics, the data model supports effective cost management strategies and helps in analyzing variances in YTD expenses.
• Insightful Transaction Distribution: The model offers insights into transaction distribution across different account group codes, aiding in identifying transaction patterns and potential areas for improvement.
• Increased Operational Transparency: Through dimensions like company code, GL account details, and journal transaction specifics, the data model enhances operational transparency and visibility into financial transactions.

Key Performance Indicators (KPIs)

• Journal Transaction Amount: Total amount of financial transactions recorded in journals.
• Journal Transaction Quantity: Total quantity of financial transactions recorded in journals.
• Revenue YTD: Total revenue generated year-to-date.
• Revenue YTD (KPI): Key performance indicator measuring revenue generated year-to-date.
• Revenue YTD Running Total: Running total of revenue generated year-to-date.
• Revenue TY Monthly: Total revenue generated in the current month.
• Revenue LYTD: Total revenue generated last year up to the current date.
• Revenue LYTD Running Total: Running total of revenue generated last year up to the current date.
• Revenue LY Monthly: Total revenue generated in the same month last year.
• Revenue YTD Variance (%): Percentage variance in revenue generated year-to-date compared to the previous year.
• Revenue TY Monthly Variance (%): Percentage variance in monthly revenue compared to the same month last year.
• COGS YTD: Total cost of goods sold year-to-date.
• COGS YTD (KPI): Key performance indicator measuring cost of goods sold year-to-date.
• COGS YTD Running Total: Running total of cost of goods sold year-to-date.
• COGS TY Monthly: Total cost of goods sold in the current month.
• COGS LYTD: Total cost of goods sold last year up to the current date.
• COGS LYTD Running Total: Running total of cost of goods sold last year up to the current date.
• COGS LY Monthly: Total cost of goods sold in the same month last year.
• COGS YTD Variance (%): Percentage variance in cost of goods sold year-to-date compared to the previous year.

Available Visualisations

View Name	Description
Revenue Turnover Variances	Analyzes differences in revenue turnover to identify areas of growth or decline.
Debt Ratio	Calculates and visualizes the financial health of the company based on its debt ratio.
Sales by Segment 2 : TY vs LY	Compares current year sales with previous year by segment to track performance.
Transactions by Account Group Code	Provides insights into transactions distribution across different account group codes.
Key Performance Indicator View	Displays essential KPIs to evaluate organizational performance and track key metrics.