Skip to main content

Sales Invoices

The data model reflects sales invoices with measures such as Order Quantity, Transaction Currency Net Sales, Transaction Currency Ext. Cost, Transaction Currency Margin, Transaction Currency Balance, Home Currency Net Sales, Home Currency Ext. Cost, Home Currency Margin, Home Currency Balance, and Home Currency Margin %. Views include Sales Invoices HC Demo, Sales Invoices By Customers and Products HC, Sales Invoices TC, Sales Invoices HC, Daily Sales Profitability TC, Daily Sales Profitability HC, and Sales by Customers and Products HC, enabling detailed sales analysis and profitability assessment for informed decision-making.

Benefits of this data model​

  • Enhanced Sales Analysis: The data model allows for detailed analysis of sales invoices by customers, products, and other dimensions, enabling a comprehensive view of sales performance.
  • Profitability Assessment: With measures such as Transaction Currency Margin and Home Currency Margin %, the data model supports accurate profitability assessment and monitoring for informed decision-making.
  • Detailed Customer Insights: By including dimensions like Customer Country, State, and City, the data model enables deep customer segmentation and analysis for targeted marketing strategies.
  • Efficient Sales Tracking: The data model categorizes sales invoices based on transaction codes and provides daily sales profitability views, allowing for immediate assessment and tracking of sales performance.
  • Strategic Decision Making: The availability of views like Sales by Customers and Products HC empowers stakeholders to make strategic decisions based on detailed sales performance and profitability analysis.

Key Performance Indicators (KPIs)​

  • Order Quantity: The total quantity of products ordered across all invoices.
  • Transaction Currency Net Sales: Total sales amount in the transaction currency, excluding any discounts or taxes.
  • Transaction Currency Ext. Cost: The total cost of goods sold for all invoices in the transaction currency.
  • Transaction Currency Margin: The difference between net sales and external costs in the transaction currency.
  • Transaction Currency Balance: The overall balance for all transactions in the transaction currency.
  • Home Currency Net Sales: Total sales amount converted to the home currency, excluding any discounts or taxes.
  • Home Currency Ext. Cost: The total cost of goods sold converted to the home currency.
  • Home Currency Margin: The difference between net sales and external costs in the home currency.
  • Home Currency Balance: The overall balance for all transactions in the home currency.
  • Home Currency Margin %: The percentage margin of net sales in the home currency.
  • Document Count: Total count of sales invoices in the dataset.

Available visualizations​

ViewDescription
Sales Invoices TCSales invoices categorized based on various transaction codes for detailed tracking and analysis.
Sales Invoices HCHigh-level overview of sales invoices with a focus on conversion rates and revenue generation.
Sales Invoices By Customersand Products HCDetailed analysis of sales invoices categorized by customers and products for high-conversion insights.
Daily Sales Profitability TCDaily overview of sales profitability based on transaction codes for immediate decision-making.
Daily Sales Profitability HCHigh-level daily assessment of sales profitability for strategic planning and monitoring.
Sales by Customers and Products HCAnalysis of sales performance based on customer and product segments for targeted marketing strategies.
Sales Invoices HC DemoOverview of high-converting sales invoices with a focus on demonstration purposes.