Skip to main content

Scripts to rerun if upgraded from x3v11 to v12+

The data model encompasses sales analytics with key measures such as Total Sales Amount, Average Order Quantity, Profit Margin, and Revenue by Product Category. The model correlates sales, orders, customers, and products to analyze unique customer count, product category revenue, and order quantity per transaction. It provides a comprehensive view of customer purchase behavior, sales performance, and product category profitability.

Benefits of This Data Model​

  • Improved Sales Performance Analysis: Gain insights into customer purchase behavior and sales performance metrics to make informed decisions and optimize strategies.
  • Enhanced Product Category Profitability: Understand revenue generation and profitability by product category, allowing for targeted marketing efforts and inventory management.
  • Customer Behavior Understanding: Analyze unique customer count and order quantity per transaction to tailor marketing campaigns and improve customer retention.
  • Optimized Inventory Management: Utilize data on average order quantity and product category revenue to streamline inventory levels and meet demand efficiently.

Key Performance Indicators (KPIs)​

  • Total Sales Amount: The sum of sales amount across all transactions.
  • Average Order Quantity: The average quantity of products ordered per transaction.
  • Profit Margin: The ratio of profit to total sales amount.
  • Customer Count: The total number of unique customers making a purchase.
  • Revenue by Product Category: The total revenue generated by each product category.

Available Visualizations​

View NameDescription
OrdersContains information on customer orders and related details.
CustomersProvides details of all customers and their contact information.
ProductsIncludes information on all available products and their attributes.
SalesSummarizes sales data including revenue, quantity sold, and profit margins.