Aller au contenu principal

Current Transactions

The data model includes views for Current Transaction Details and Transaction Type, with measures including Item Quantity, Total Value Discount, Total Value Issue, Total Value Cost, and Profit Value (derived as the difference between Total Value Issue and Total Value Cost). The model allows for analyzing transaction-specific details, transaction types, item quantities, discounts, and the profitability of transactions.

Benefits of This Data Model​

  • Granular Transaction Analysis: The data model allows for in-depth analysis of transaction-specific details, enabling users to drill down into individual transactions to uncover insights.
  • Profitability Insights: By including the Profit Value measure, the data model provides a clear view of the profitability of transactions, helping stakeholders understand which transactions are driving profits or losses.
  • Transaction Type Analysis: The availability of the Transaction Type view enables users to categorize transactions based on different types, facilitating trend analysis and strategic decision-making.
  • Item Quantity Analysis: With the Item Quantity measure, users can assess the volume of items involved in transactions, supporting inventory management and demand forecasting.
  • Discount Evaluation: The Total Value Discount measure offers insights into the impact of discounts on transactions, assisting in evaluating the effectiveness of promotional strategies and pricing decisions.

Key Performance Indicators (KPIs)​

  • Item Quantity: The total quantity of items involved in the current transactions.
  • Total Value Discount: The total value of discounts applied to the transactions.
  • Total Value Issue: The overall value of items issued in the transactions.
  • Total Value Cost: The total cost value incurred in the transactions.
  • Profit Value: The profit generated from the transactions, calculated as the difference between Total Value Issue and Total Value Cost.

Available Visualizations​

View NameDescription
Current Transaction DetailsProvides detailed information about each transaction in the current dataset.
Transaction TypeOffers insights into the different types of transactions recorded in the data model.