Vendor History

The data model encompasses measures such as Discount Lost Amt, Discount Taken Amt, Freight, Pmt Amount, Purch. Amount, Returns, and Net Purchases, focusing on customer purchasing behavior and financial transactions. It integrates views like Sales_Fact, Customers, Products, Orders, and Employees to facilitate comprehensive analysis of sales data, customer orders, product details, and employee information within the business domain.

Benefits of This Data Model

• Enhanced Customer Profiling: By analyzing measures such as Discount Lost Amount, Freight, and Returns alongside dimensions like Company Name and Vendor Code, the data model allows for a deep understanding of customer purchasing behavior, leading to more accurate customer segmentation and profiling.
• Improved Financial Insights: The integration of measures such as Purch. Amount and Net Purchases with dimensions like Year and Period enables comprehensive financial analysis, providing valuable insights into the company's financial performance over time.
• Vendor Performance Analysis: With dimensions such as Vendor Class Code and Vendor Name coupled with measures like Discount Taken Amount and Pmt Amount, the data model facilitates in-depth evaluation of vendor performance and helps in strategic decision-making regarding vendor relationships.
• Holistic Sales Data Examination: By combining views like Sales_Fact, Customers, and Products with measures such as Discount Lost Amount and Returns, the data model supports a holistic analysis of sales data, customer orders, and product details, enabling better sales forecasting and planning.

Key Performance Indicators (KPIs)

• Discount Lost Amt: This measure represents the amount of discounts that were not utilized or taken advantage of by customers in the purchasing process.
• Distcount Taken Amt: This measure indicates the amount of discounts that were successfully applied and utilized by customers during the purchasing process.
• Freight: This measure refers to the cost incurred for shipping or transportation of goods.
• Pmt Amount: This measure represents the total payment amount made by customers for the purchases.
• Purch. Amount: This measure denotes the total amount of purchases made by customers.
• Returns: This measure signifies the total amount of products returned by customers for refunds or exchanges.
• Net Purchases: This measure indicates the overall net amount of purchases made by customers after accounting for discounts, returns, and other factors.

Available visualizations

View Name	Description
Sales_Fact	Provides sales data for analysis.
Customers	Contains information about customers.
Products	Includes details about products sold.
Orders	Displays information on customer orders.
Employees	Stores data on company employees.