View your business data with the Partner Center Analytics app for Microsoft Power BI

Applies to

  • Partner Center

View your business data

Get a visual representation of your business data with the Partner Center Analytics app for Power BI, including:

  • Growth of your customer base, subscriptions, and licenses

  • Usage of Office 365, Microsoft Dynamics, and Microsoft Azure products

  • Daily consumption units for each metered resource in each Azure subscription for the last 60 days

  • Estimated cost (based on latest rate card)

  • Ability to export datasets and create custom reports, including per customer

About the Partner Center Analytics app preview release

  • This app is for direct partners in the Cloud Solution Provider program only. Other partners in CSP (indirect resellers, for example) will not be able to sign in.
  • Any estimated costs are pre-tax billing / invoice data, and are not legally binding. Estimated costs are meant to be used for data insights only.

  • Customer information is based on subscriptions. Any customers that you've recently created accounts for, but who do not yet have subscriptions, are not included in counts.

  • Estimated cost is based on latest rate card, which is based on CSP pricing.

  • Days are calendar days.

Business Insights report

  • Customer tenants: Number of distinct Azure AD tenants of customers that have purchased subscriptions

  • New (last 30 days): New customers purchasing at least one subscription in last 30 days

  • Churn (last 30 days): Customers without any “active”, “in grace” or “disabled” subscriptions

  • New (last 24 hours): New customers purchasing at least one subscription in last 24 hours

  • Estimated monthly cost over last 12 months: Month over month trend of estimated pre-tax invoice dollar amount aggregated monthly over the period of last 12 months

  • Estimated cost by product over last 12 months: Products sold sorted by estimated pre-tax invoice dollar amount aggregated over the period of last 12 months. This will indicate top products bringing most revenue.

  • Customers over last 12 months: Month over month trend of new customers and churn customers aggregated monthly over the period of last 12 months

  • Estimated cost by customer over last 12 months: Customers sorted by estimated pre-tax invoice dollar amount aggregated over the period of last 12 months. This will indicate top customers bringing most revenue.

  • Customer count by product: Products sold sorted by associated customers. This will indicate top products sold to most customers.

Subscription Insights report

  • Subscription status:

    • Active: Subscriptions belonging to either “active” or “in grace” state

    • Suspended: Subscriptions belonging to “disabled” state

    • De-provisioned: Subscriptions belonging to “de-provisioned” or “expired” status

  • Expiry status:

    • Expired: Subscriptions that have already expired (where subscription end date is in past)

    • Expiring after 30 days: Subscriptions that will expire after 30 days (where subscription end date is after next 30 days)

    • Expiring in 30 days: Subscriptions that will expire within next 30 days (where subscription end date is between today and next 30 days)

  • Total subscriptions: Subscriptions in “active,” “in grace” or “disabled” status

  • New (last 30 days): New subscriptions purchased by customers within last 30 days

  • New (last 24 hours): New subscriptions purchased by customers within last 24 hours

  • Expiring in 30 days: Subscriptions that will expire within next 30 days

  • Churn (last 30 days): Subscriptions that have been de-provisioned or Suspended (disabled) within last 30 days

  • Distribution by subscription types: % distribution of total subscriptions by License based and usage based subscription type

  • Active subscription count by product: Products sold sorted by active subscriptions count

  • Subscriptions over last 12 months: Month over month trend of new subscriptions and churn subscriptions aggregated monthly over the period of last 12 months

  • Customer subscription details: Detailed view of the customers, subscriptions and offers

License Insights report:

  • Total licenses: Total number of licenses aggregated across all license based subscriptions

  • New (last 30 days): License addition within last 30 days

  • Churn (last 30 days): License reduction within last 30 days

  • New (last 24 hours): License addition within last 24 hours

  • Licenses over last 90 days: Month over month trend of license additions and reductions aggregated monthly over the period of last 90 days

  • Active license count by product: Products sold sorted by active license count

  • Active license count by customer: Customers sorted by sorted by active license count

  • Customer license event details over last 90 days: Detailed view of the customers, subscriptions and subscription events including event date, event name, quantity and change in quantity.

Licenses Usage report:

  • Licenses assigned by product: Products sold sorted by license assignment count

  • Licenses in use by product: Products sold sorted by license usage count

  • Customer distribution of licenses assigned: % distribution of total customers broken in buckets of 20% range by license assignment %

  • Customer distribution of licenses in use: % distribution of total customers broken in buckets of 20% range by license usage %

  • Licenses assigned by customer: Detailed view of licenses sold and licenses assigned by customers and products

  • Licenses in use by customer: Detailed view of licenses sold and licenses in use by customers and products

Azure Insights report:

  • Usage based customers over last 12 months: Month over month trend of new usage based customers and churned usage based customers aggregated monthly over the period of last 12 months

  • Usage based subscriptions over last 12 months: Month over month trend of new usage based subscriptions and churned usage based subscriptions aggregated monthly over the period of last 12 months

  • Estimated cost of usage by customer over last 60 days: Usage based customers sorted by estimated pre-tax invoice dollar amount aggregated over the period of last 60 days. This will indicate top usage based customers bringing most revenue

  • Estimated cost of usage by category over last 60 days: Meter categories of usage based subscriptions sorted by estimated pre-tax invoice dollar amount aggregated over the period of last 60 days.

  • Estimated cost of usage by subscription over last 60 days: Usage based subscriptions by estimated pre-tax invoice dollar amount aggregated over the period of last 60 days.

  • Customer estimated usage cost by spending budget: Customers sorted by percentage of their current usage spending budget exceeding threshold (100%).

Azure Resource Usage report:

  • Usage of Azure resources by day for selected period: Daily consumption units for each metered resource in each usage based subscription for selected period within the last 60 days.

  • Estimated usage cost of Azure resources for selected period: Estimated cost based on latest rate card for each metered resource in each usage based subscription for selected period within the last 60 days.

See also

Partner Center Analytics for Power BI app overview

Install and preview the Partner Center Analytics app for Microsoft Power BI