Sales

The data model encompasses measures such as Invoice Amount TY, Qty Shipped TY, Act Comm Amount TY, Trade Discount Amount TY, Unit Price TY, Freight Amount TY, Retention Percentage TY, Ext Amt TY, Comm Base TY, Calc Comm Amount TY, Unit Cost TY, and Currency Exc Rate TY. These measures provide insights into sales performance, commission amounts, trade discounts, freight costs, unit prices, and currency exchange rates for the current year, facilitating comprehensive analysis of business operations and financial transactions.

Benefits of This Data Model

• Improved Sales Performance Analysis: The data model enables a detailed analysis of sales performance through measures such as Invoice Amount TY, Qty Shipped TY, and Unit Price TY, providing valuable insights for decision-making.
• Enhanced Commission Tracking: With measures like Act Comm Amount TY and Calc Comm Amount TY, the data model allows for accurate tracking and calculation of commissions, contributing to better incentive management.
• Effective Cost Comparison: The comparison view "Invoice Amount VS Unit Cost" facilitates in-depth analysis by comparing invoice amounts to unit costs, assisting in cost control and profitability assessments.
• Comprehensive Financial Insights: By combining measures like Trade Discount Amount TY, Ext Amt TY, and Freight Amount TY with various dimensions, the data model offers a comprehensive view of financial transactions for a thorough understanding of business operations.
• Currency Exchange Rate Monitoring: The inclusion of the Currency Exc Rate TY measure enables tracking and analysis of currency exchange rates, aiding in monitoring international transactions and financial risk management.

Key Performance Indicators (KPIs)

• Invoice Amount TY: Total amount billed for invoices in the current year.
• Qty Shipped TY: Total quantity of products shipped in the current year.
• Act Comm Amount TY: Actual commission amount earned in the current year.
• Trade Discount Amount TY: Total amount of trade discounts applied in the current year.
• Unit Price TY: Average unit price of products sold in the current year.
• Freight Amount TY: Total freight cost incurred in the current year.
• Retention Percentage TY: Percentage of revenue retained after deductions in the current year.
• Ext Amt TY: Extended amount of products sold in the current year.
• Comm Base TY: Commission base amount calculated in the current year.
• Unit Cost TY: Average unit cost of products sold in the current year.
• Calc Comm Amount TY: Calculated commission amount in the current year.
• Currency Exc Rate TY: Exchange rate of currency for the current year.
• Qty Shipped LY: Total quantity of products shipped in the last year.
• Act Comm Amount LY: Actual commission amount earned in the last year.
• Trade Discount Amount LY: Total amount of trade discounts applied in the last year.
• Unit Price LY: Average unit price of products sold in the last year.
• Freight Amount LY: Total freight cost incurred in the last year.
• Ext Amt LY: Extended amount of products sold in the last year.
• Comm Base LY: Commission base amount calculated in the last year.
• Unit Cost LY: Average unit cost of products sold in the last year.
• Calc Comm Amount LY: Calculated commission amount in the last year.
• Currency Exc Rate LY: Exchange rate of currency for the last year.
• Invoice Amount LY: Total amount billed for invoices in the last year.
• Invoice Amount LYTD: Total amount billed for invoices year-to-date in the last year.
• Invoice Amount MTD: Total amount billed for invoices month-to-date in the last year.
• Invoice Amount LMTD: Total amount billed for invoices last month-to-date in the last year.
• Invoice Amount YTD: Total amount billed for invoices year-to-date in the current year.
• Freight Amount LYTD: Total freight cost incurred year-to-date in the last year.
• Freight Amount MTD: Total freight cost incurred month-to-date in the last year.
• Freight Amount LMTD: Total freight cost incurred last month-to-date in the last year.
• Freight Amount YTD: Total freight cost incurred year-to-date in the current year.
• Qty Shipped LYTD: Total quantity of products shipped year-to-date in the last year.
• Qty Shipped MTD: Total quantity of products shipped month-to-date in the last year.
• Qty Shipped LMTD: Total quantity of products shipped last month-to-date in the last year.
• Qty Shipped YTD: Total quantity of products shipped year-to-date in the current year.
• Cost Of Sales TY: Total cost of goods sold in the current year.
• Cost Of Sales LY: Total cost of goods sold in the last year.

Available Visualizations

View Name	Description
Top 5 Sales Person	View showing the top 5 salespersons based on sales performance
Top 10 Customer by Sales	View displaying the top 10 customers ranked by total sales
Invoice Summary	Summary view providing an overview of sales transactions
Invoice Summary	Additional summary view offering insights into sales data
Invoice Amount VS Unit Cost	View comparing invoice amounts to unit costs for analysis
Top 5 Item Sales	View highlighting the top 5 best-selling items by quantity or revenue
KPI	View tracking key performance indicators for business evaluation