EPM Strategy - The Sales Contest

This showcase is an example of a Sales Contest to help each salesperson know where they are in relation to their goals and to each other. It also helps management see the results over the course of time. The results can be filtered by many different criteria, including the Customers, Regions, dates, areas and regions. The Ribbon Chart allows the salespeople and managers to understand how much revenue each salesperson is bringing in relative to each over - and over time. The Enlighten fish visual is a fun way for each salesperson to see how their sales are in relation to their goals (the sharks and fish).

联系合作伙伴 观看视频

This showcase is an example of an organization that has many salespeople and has a sales contest going on to determine who meets their goals.  Each salesperson has their own goals and the organization has overall goals that they want met. 

The first tab of the report has a numerical breakdown by Territory with the key measures and fields that the organization and each salesperson is concerned about in regards to their goals and current sales.  There is a drill down ribbon chart showing each salesperson's sales against each other over time.  The third visual is a Treemap to make for an easy way to see an overall totals comparison.  The slicers are designed to be able to filter the information in any of the main ways that either management or individual salespeople want to view the information.

In this showcase, we are not using role level security.  However, in an actual implementation our suggestion would be to have the security based upon the salesperson's territory or region so that they only see their pertinent information.

The second tab has a few key slicers with the Net Revenue and Goals in text format.  The visual shows the sales (based in Revenue) against the goals.  The dark blue line is the baseline goal for each salesperson to reach as their minimum.  The light blue line is the salesperson's Revenue line.  The red line is the stretch goal.  In this case, anybody hitting the stretch goal OR the salesperson closest to it is the one(s) that get an additional bonus.  This visual can be drilled down based upon as well.

The third tab is the quick and easy tab.  Each salesperson is represented by the shark and their sales goals are the fish.  This is a way for each salesperson to see how close their to their own goals as the shark and fish are the same color for each salesperson.

想成为 Power BI 合作伙伴?

认证合作伙伴是团队的重要组成部分!寻找新的商机、建立联系并与全球 Power BI 用户共享自己公司的人才和经验。