Total Contract Value Analysis (Power BI Report)

The Total Contract Value Analysis report provides a detailed analysis of total contract value (TCV), breaking it down into its key contributing components. This report can help you understand what’s driving TCV in your subscription business, and why.

Use the report

Leadership and management teams use the report to identify trends, break down total contract value (TCV) into its key contributing components, and make informed adjustments to strategies.

Subscription managers can use the decomposition tree in Power BI to perform a deep-dive analysis into the drivers of your TCV. This interactive visual allows you to break down the TCV by any available dimension—such as customer, item, contract terms, or billing rhythms in any order you choose.

For example, you might start by breaking down TCV by Contract Type to see which contract models are most valuable. You could then expand a specific type by Billing Rhythm to understand how your revenue is distributed between monthly and annual billing, and finally drill down to the customer level to identify the specific accounts contributing to those figures. This level of granularity helps you identify high-value segments and understand the underlying structure of your contractual commitments.

Key performance indicators

• Total Contract Value

Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.

Data used in the report

The report uses data form the following tables in Business Central:

• Customer
• Item
• Salesperson/Purchaser
• Subscription
• Customer Subscription Contract
• Vendor Subscription Contract
• Subscription Contract Analysis Entries

Related information

Track your business KPIs with Power BI metrics
Setting up the Subscription Billing Power BI app
Subscription Billing controlling
Subscription Billing overview