Project Transactions

The data model includes measures such as cost rate, cost quantity, cost total, and cost WIP value for project transactions. It also incorporates revenue-related measures including revenue rate, revenue quantity, revenue actual, and revenue potential uplift with revenue total. Additionally, the model computes net profit by deducting total costs from total revenue. Views like Revenue Transactions, Profitability, and Cost Transactions are utilized to provide insights into revenue generation, profitability calculations, and cost-related transactions.

Benefits of This Data Model

• Enhanced Profitability Analysis: The data model facilitates detailed profitability analysis by calculating and presenting net profit derived from deducting total costs from revenue, enabling a clear understanding of project profitability.
• Comprehensive Revenue Tracking: Through measures such as revenue rate, quantity, actual, and potential uplift, the model allows for in-depth tracking and analysis of revenue generation across different parameters for informed decision-making.
• Detailed Cost Insights: The inclusion of cost-related measures like cost rate, quantity, total, and WIP value provides a comprehensive view of project costs, aiding in cost analysis and management for improved financial performance.
• Multi-dimensional Reporting: Leveraging a wide range of dimensions such as Company, Project, Cost Type, Financial Class, and more, the model enables multi-dimensional reporting and analysis, offering a holistic view of various aspects impacting the business.
• Informed Decision-making: By utilizing views such as Revenue Transactions, Profitability, and Cost Transactions, the data model empowers stakeholders to make data-driven decisions by providing clear insights into revenue, profitability, and cost-related transactions for effective business planning and strategy formulation.

Key Performance Indicators (KPIs)

• Cost Rate in Base Curr: This measure represents the cost rate in the base currency for project transactions.
• Cost Quantity: This measure indicates the quantity of cost incurred in project transactions.
• Cost Total: Refers to the total cost amount in the base currency for project transactions.
• Cost WIP Value: Represents the work-in-progress (WIP) value of costs in the project transactions.
• Revenue Rate in Base Curr: Indicates the revenue rate in the base currency for project transactions.
• Revenue Quantity: Represents the quantity of revenue generated in project transactions.
• Revenue Actual: Refers to the actual revenue amount generated in project transactions.
• Revenue Potential Uplift: This measure signifies the potential uplift in revenue that could be achieved in project transactions.
• Revenue Total: Represents the total revenue amount in the base currency for project transactions.
• Profit Net: Indicates the net profit derived from subtracting total costs from total revenue in project transactions.

Available Visualizations

View Name	Description
Revenue Transactions	Displays all revenue-generating transactions.
Profitability	Calculates profitability based on revenue and costs.
Cost Transactions	Shows all cost-related transactions.