Skip to main content

Sales Invoices (TY vs LY)

The data model includes metrics for sales performance comparison between the current year and the previous year, covering quantities, extended costs, margins, net sales, averages per representative, customer, product, invoice, and country, as well as sales volatility, the number of invoices, customers, products, sales representatives, and countries. Visual representations are provided through various views such as Main Values per Month TY vs LY, Combination Chart, Horizontal Bullet, Bubble, Worksheet, and Key Performance Indicator for effective sales analysis and decision-making.

Benefits of This Data Model​

  • Improved Sales Performance Analysis: The data model allows for in-depth comparison of sales performance metrics between the current year and the previous year, enabling more accurate insights into quantities, extended costs, margins, net sales, and averages across various dimensions such as representative, customer, product, invoice, and country.
  • Enhanced Visualization Capabilities: Through various views like Main Values per Month TY vs LY, Combination Chart, Horizontal Bullet, Bubble, Worksheet, and Key Performance Indicator, users can visually analyze sales data trends, targets, achievements, and critical metrics for effective decision-making.
  • Advanced Sales Monitoring: With measures including Net Sales Volatility, # of Invoices, Customers, Products, Sales Representatives, and Countries, the data model facilitates comprehensive monitoring and tracking of key sales indicators to identify patterns, anomalies, and opportunities.
  • Facilitated Strategic Decision-Making: By providing a structured format for detailed analysis and reporting through dimensions like Year, Quarter, Month, Customer Class ID, and Product Type, the data model supports informed decision-making based on historical sales data and trends.

Key Performance Indicators (KPIs)​

  • Calendar Month (Bubble): Represents the calendar month for the sales data displayed.
  • Calendar Day (Bubble): Indicates the specific calendar day for the sales data presented.
  • Quantity TY: Total quantity of products sold in the current year.
  • Quantity LY: Total quantity of products sold in the previous year.
  • Quantity Variance: The variance in quantity sold between the current year and the previous year.
  • Quantity Variance %: Percentage difference in quantity sold between the current year and the previous year.
  • Ext. Cost TY: Total extended cost of products sold in the current year.
  • Ext. Cost LY: Total extended cost of products sold in the previous year.
  • Ext. Cost Variance: The variance in extended cost between the current year and the previous year.
  • Ext. Cost Variance %: Percentage difference in extended cost between the current year and the previous year.
  • Margin TY: Total margin generated from sales in the current year.
  • Margin LY: Total margin generated from sales in the previous year.
  • Margin %: Profit margin percentage calculated for the sales data.
  • Margin Variance: The variance in margin between the current year and the previous year.
  • Margin Variance %: Percentage difference in margin between the current year and the previous year.
  • Net Sales TY: Total net sales amount for the current year.
  • Net Sales LY: Total net sales amount for the previous year.
  • Net Sales Variance: The variance in net sales between the current year and the previous year.
  • Net Sales Variance %: Percentage difference in net sales between the current year and the previous year.
  • Net Sales Per Rep TY: Average net sales per sales representative for the current year.
  • Net Sales Per Rep LY: Average net sales per sales representative for the previous year.
  • Net Sales Per Customer TY: Average net sales per customer for the current year.
  • Net Sales Per Customer LY: Average net sales per customer for the previous year.
  • Net Sales Per Product TY: Average net sales per product for the current year.
  • Net Sales Per Product LY: Average net sales per product for the previous year.
  • Net Sales Per Invoice TY: Average net sales per invoice for the current year.
  • Net Sales Per Invoice LY: Average net sales per invoice for the previous year.
  • Net Sales Per Country TY: Average net sales per country for the current year.
  • Net Sales Per Country LY: Average net sales per country for the previous year.
  • Net Sales Volatility (STDDEV): Standard deviation in net sales data, reflecting its volatility.
  • Net Sales Average: Average net sales amount.
  • Net Sales Volatility Low: The lower range of net sales volatility.
  • Net Sales Volatility High: The upper range of net sales volatility.
  • # of Invoices TY: Total number of invoices generated in the current year.
  • # of Customers TY: Total number of customers served in the current year.
  • # of Products TY: Total number of unique products sold in the current year.
  • # of Salesrep TY: Total number of sales representatives involved in sales for the current year.
  • # of Country TY: Total number of countries where sales were made in the current year.
  • # of Invoices LY: Total number of invoices generated in the previous year.
  • # of Customers LY: Total number of customers served in the previous year.
  • # of Products LY: Total number of unique products sold in the previous year.
  • # of Salesrep LY: Total number of sales representatives involved in sales for the previous year.
  • # of Country LY: Total number of countries where sales were made in the previous year.