Sales Invoices (TY vs LY)

The data model encompasses key measures such as total sales amounts, margin figures, quantity sold, and invoice counts, facilitating detailed analysis of sales performance metrics for the current and previous years. Views include comparative analysis of sales values, year-over-year growth percentages, individual sales representative performance evaluation, identification of top customers and products by net sales, monitoring of product and customer margin erosion, visualization of temporal sales distribution, anomaly detection in daily sales, and KPI calculation template.

Benefits of This Data Model

• Improved Sales Performance Analysis: The data model allows for detailed analysis of key sales performance metrics for the current and previous years, enabling better insights into total sales amounts, margin figures, quantity sold, and invoice counts.
• Enhanced Sales Representative Evaluation: Facilitates evaluation of individual sales representative performance, aiding in identifying top-performing sales representatives and areas for improvement.
• Effective Customer and Product Monitoring: Enables the identification of top customers and products by net sales, as well as monitoring product and customer margin erosion over time.
• Anomaly Detection and KPI Calculation: Provides tools for anomaly detection in daily sales data and offers a KPI calculation template for measuring and tracking key performance indicators efficiently.

Key Performance Indicators (KPIs)

• Company Code: Identifier of the company associated with the sales data.
• Month (Bubble): Month during which the sales activities occurred.
• Day (Bubble): Day of the month when the sales transactions took place.
• Quantity Sold: Total quantity of products sold.
• Quantity (Stock): Quantity of products available in stock.
• Ledger Currency Amount: Total amount of sales in the ledger currency.
• Ledger Currency Cost: Total cost of products in the ledger currency.
• Ledger Currency Margin Amt: Margin amount in the ledger currency.
• Net Sales TY: Net sales amount for the current year.
• Net Sales LY: Net sales amount for the previous year.
• Net Sales Variance: Variance in net sales amount between the current and previous year.
• Net Sales Variance %: Percentage variance in net sales amount between the current and previous year.
• Margin TY: Margin amount for the current year.
• Margin LY: Margin amount for the previous year.
• Margin % TY: Margin percentage for the current year.
• Margin % LY: Margin percentage for the previous year.
• Margin Variance: Variance in margin amount between the current and previous year.
• Margin Variance %: Percentage variance in margin amount between the current and previous year.
• # of Invoices TY: Number of invoices generated in the current year.
• # of Customers TY: Total number of customers in the current year.
• # of Products TY: Number of unique products sold in the current year.
• # of Salesrep TY: Number of sales representatives in the current year.
• # of Countries TY: Number of countries where sales were made in the current year.
• # of Invoices LY: Number of invoices generated in the previous year.
• # of Customers LY: Total number of customers in the previous year.
• # of Products LY: Number of unique products sold in the previous year.
• # of Salesrep LY: Number of sales representatives in the previous year.
• # of Countries LY: Number of countries where sales were made in the previous year.
• Quantity TY: Total quantity of products sold in the current year.
• Quantity LY: Total quantity of products sold in the previous year.
• Quantity Variance: Variance in quantity sold between the current and previous year.
• Quantity Variance %: Percentage variance in quantity sold between the current and previous year.
• Ext. Cost TY: Extended cost of products in the current year.
• Ext. Cost LY: Extended cost of products in the previous year.
• Ext. Cost Variance: Variance in extended cost between the current and previous year.
• Ext. Cost Variance %: Percentage variance in extended cost between the current and previous year.
• Net Sales Per Rep TY: Average net sales per sales representative in the current year.
• Net Sales Per Rep LY: Average net sales per sales representative in the previous year.
• Net Sales Per Customer TY: Average net sales per customer in the current year.
• Net Sales Per Customer LY: Average net sales per customer in the previous year.
• Net Sales Per Product TY: Average net sales per product in the current year.
• Net Sales Per Product LY: Average net sales per product in the previous year.
• Net Sales Per Invoice TY: Average net sales per invoice in the current year.
• Net Sales Per Invoice LY: Average net sales per invoice in the previous year.
• Net Sales Per Country TY: Average net sales per country in the current year.
• Net Sales Per Country LY: Average net sales per country in the previous year.
• Net Sales Volatility (STDDEV): Standard deviation of net sales.
• Net Sales Average: Average net sales amount.
• Net Sales Volatility Low: Lowest net sales amount within the volatility range.
• Net Sales Volatility High: Highest net sales amount within the volatility range.

Available Visualisations

View Name	Description
Main Values per Month TY v LY	Provides a comparison of total sales values between current and previous year.