Sales Orders
The data model encompasses quantities, costs, prices, and amounts in both transaction currency and home currency for sales orders in the healthcare and all industries sectors. It includes measures such as order quantity, open quantity, unit cost, order cost, unit price, extended price, discount amount, line amount, order amount, and open amount. The model is utilized in the Sales Order Summary views, tailored for healthcare and all industries, providing a comprehensive snapshot of sales order performance.
Benefits of This Data Model
- Enhanced Sales Order Analysis: The data model allows for in-depth analysis of sales orders by various dimensions such as customer, product, order type, and date, providing insights into sales performance across different segments.
- Cross-Industry Comparison: Users can compare sales order metrics and trends across the healthcare sector and other industries, aiding in benchmarking and identifying areas of strength or improvement.
- Geospatial Insights: Leveraging dimensions like customer location and order branch, the data model enables geographical analysis of sales orders, helping businesses understand regional sales patterns and customer behavior.
- Comprehensive Financial Reporting: With measures for both transaction currency and home currency, the data model supports accurate financial reporting, ensuring consistency and transparency in sales order related financial analyses.
Key Performance Indicators (KPIs)
- Order Quantity: The total quantity of products ordered in a sales order.
- Open Quantity: The remaining quantity of products to be fulfilled in an open sales order.
- Transaction Currency Unit Cost: The cost of each unit of product in the transaction currency.
- Transaction Currency Order Cost: The total cost of the order in the transaction currency.
- Transaction Currency Unit Price: The price of each unit of product in the transaction currency.
- Transaction Currency Extended Price: The extended price of the sales order in the transaction currency.
- Transaction Currency Discount Amount: The total discount amount applied to the sales order in the transaction currency.
- Transaction Currency Line Amount: The total amount of each line item in the sales order in the transaction currency.
- Transaction Currency Order Amount: The total amount of the sales order in the transaction currency.
- Transaction Currency Open Amount: The remaining open amount to be paid in the sales order in the transaction currency.
- Home Currency Unit Cost: The cost of each unit of product in the home currency.
- Home Currency Order Cost: The total cost of the order in the home currency.
- Home Currency Unit Price: The price of each unit of product in the home currency.
- Home Currency Extended Price: The extended price of the sales order in the home currency.
- Home Currency Discount Amount: The total discount amount applied to the sales order in the home currency.
- Home Currency Line Amount: The total amount of each line item in the sales order in the home currency.
- Home Currency Order Amount: The total amount of the sales order in the home currency.
- Home Currency Open Amount: The remaining open amount to be paid in the sales order in the home currency.
Available Visualizations
| View Name | Description |
|---|---|
| Sales Order Summary HC | Provides a high-level overview of sales orders trends and metrics for the healthcare industry. |
| Sales Order Summary TC | Offers a consolidated summary of sales orders data, focusing on total sales across all industries. |