Skip to main content

Vendor History

The data model includes measures such as Discount Lost Amt, Discount Taken Amt, Freight, Pmt Amount, Purch. Amount, Returns, and Net Purchases. Views like Transaction History, Sales Performance, and Vendor Ranking offer insights into vendor transactions, sales trends, and vendor performance evaluation based on revenue generation. The model enables tracking discounts, freight costs, payments, and net purchase amounts to optimize vendor relationships and purchasing strategies.

Benefits of This Data Model​

  • Enhanced Vendor Performance Tracking: The data model allows for detailed monitoring of vendor transactions through measures such as Discount Lost Amt, Discount Taken Amt, and Returns, enabling a comprehensive evaluation of vendor performance and contribution to revenue.
  • Improved Purchasing Strategy Optimization: By providing insights into discounts, freight costs, payments, and net purchase amounts, the model empowers organizations to optimize vendor relationships and purchasing strategies for better financial outcomes.
  • Efficient Vendor Evaluation: Utilizing dimensions like Vendor Code, Vendor Name, and Vendor Class Name, the model enables accurate ranking of vendors based on performance, facilitating informed decision-making in vendor selection and management.

Key Performance Indicators (KPIs)​

  • Discount Lost Amt: This measure represents the total amount of discounts that were not applied during purchases.
  • Discount Taken Amt: This measure represents the total amount of discounts that were applied during purchases.
  • Freight: This measure represents the cost of freight for all purchases made.
  • Pmt Amount: This measure represents the total payment amount made to vendors.
  • Purch. Amount: This measure represents the total amount spent on purchases.
  • Returns: This measure represents the total amount of returns made.
  • Net Purchases: This measure represents the net amount spent on purchases after accounting for discounts, returns, and freight costs.

Available Visualisations​

View NameDescription
Vendor HistoryDisplays historical vendor data to identify trends and patterns for better decision-making.