PowerPivotPro - Actuals vs Forecast for Subscription Business

More and more companies are pursuing subscription-based business models. This scorecard solution allows a company to quickly view year to date revenue against plan, use different forecasting assumptions to project full year performance, and drill into pipeline detail. This all-in-one performance view can be used by sales managers evaluating their teams, FP&A professionals doing sensitivity analysis, and executives monitoring the company’s performance as a whole.

联系合作伙伴

More and more companies are pursuing subscription-based business models. This scorecard solution allows a company to quickly view year to date revenue against plan, use different forecasting assumptions to project full year performance, and drill into pipeline detail. This is a simplified and anonymized demo version of a real-world customer solution and is hard coded to August 2017.

YTD & Forecast Tab

This tab gives a view of Membership sales through August of the scorecard year and how they compare to the annual plan. The forecast component takes the current pipeline and applies different conversion assumptions to project sales for the rest of the year. The forecast subtracts known expirations plus a variable attrition factor to project year-end results.

  • View year to date performance against plan.
  • Slice by geographic segment (State), sub-segment (City), and division (Membership Type).
  • Set expected value of full year performance by selecting conversion percentage for three different forecasted pipelines (Secure, Likely, Reach), and modifying attrition rate.

Pipeline Details Tab

This tab shows the total Pipeline for the remaining months of the scorecard year. Analysts and managers can quickly see potential performance across several relevant dimensions.

  • Slice by geographic segment (State), sub-segment (City), and division (Membership Type).
  • View and filter-by-selecting across forecast type, product line (Membership Plan), Sales Stage, and Purchase Type.

This all-in-one performance view can be used by sales managers evaluating their teams, FP&A professionals doing forward looking analysis, and executives monitoring the company’s performance as a whole.

想要成为 Power BI 合作伙伴?

认证合作伙伴是团队的重要组成部分! 挖据新的商机、建立人脉并与世界各地的 Power BI 用户分享公司的人才和经验。

注册

需要注册方面的帮助?
请联系 pbiptnr@microsoft.com

Request demo