Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Power BI, Fabric, SQL, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The Salesforce Analytics for Sales Managers template app includes visuals and insights for analyzing your marketing effort.
The app's out-of-the-box dashboard provides key metrics, such as your sales pipeline, best accounts, and KPI's. You can drill down into the report for more details on each aspect. Fully interactive visuals help you explore your data further.
In this article we will walk through the app using sample data to give you an idea of how you can use the app to gain key insights into your sales data.
Click the following link to get to the app: Salesforce Analytics for Sales Managers template app.
Once you're on the App's AppSource page, click GET IT NOW.
When prompted , click Install. Once the app has installed, you will see it on your Apps page.
Click the icon on your Apps page to open the app. The app opens, showing sample data.
Select the Connect your data link on the banner at the top of the page.
The parameters dialog will appear. There are no required parameters. Click Next.
The authentication method dialog will appear. Recommended values are prepopulated. Don't change these unless you have specific knowledge of different values. Click Sign in and connect.
When prompted, sign into Salesforce.
The report will connect to the data sources and be populated with up-to-date data. During this time you will see sample data and that refresh is in progress.
When you open the app, you'll see the KPI dashboard. The KPI dashboard shows us an overall view of the key metrics from all the dashboards. Click the arrows to get to the individual dashboards.
The Sales Manager dashboard and underlying report focus on a typical sales challenge: providing a total sales analysis over a certain period.
Using the dashboard to look at the sample data, we're going see how to
Now let's look at the various components of the dashboard.
The top two visuals show us the total number of open opportunities we have and the revenue we can expect to generate from them.
The Opportunity Sales Stage visual shows the position of the opportunities in the sales pipeline. Select any stage on the sales pipeline stage to see its impact on the whole sales process. Now we can analyze the revenue that corresponds with that stage.
If you click on any one of the industries in the Share of Industry visual, it shows the share of the industry your sales team is working on. Let's click on "Apparel" for example.
When we click on "Apparel", we see that the account we have in this sector is one of the top ten critical opportunities with respect to revenue. We can conclude that this is an opportunity that deserves our focus on a priority basis, since its expected revenue is among the highest as compared to other accounts.
The Account dashboard lets you oversee how you are performing in all your accounts. It tells you which are your most profitable accounts. Let's analyze the accounts for apparel.
On the dashboard, select “Apparel” on the Account dashboard's Account Share Industry Wise visual.
You'll see the tiles get updated. Notice that there is one industry in apparel, for which we have 1 account.
If we look at the Account Area Wise map visual, you'll see the area where we have the apparel account.
Let’s look at the revenue for the account under apparel. In the Revenue by Account visual you can see that the account for apparel is highlighted, and shows the revenue being generated.
We can also see a comparison of revenue won vs lost. If we hover over a bar, we see the exact revenue won out of the total revenue.
The Lead dashboard lets you see what the sources of your leads are. It tells you which are your most profitable sources of lead.
Look at the Probability of Conversion visual to examine what the probability is that the lead from a source is going to be converted. For example, selecting "External Referral" in the Leads by Source visual shows that the probability of conversion is 90.00%, while its total forecasted amount is 1.65 million dollars.
Similarly, you can also see the distribution of customers in the sales lead by looking at the Sales Lead by Customer Type visual. You can see it for a single lead by hovering over it. So, for "External Referral", you can see that there is one new customer belonging to the “New Business” category.
We can also see the overall number of lead statuses that we have, and in what stage they are.
The Representative dashboard lets you measure the performance of the sales representatives by a number of matrices.
We can see all the industries a sales representative works in, and all the representatives of an industry.
To see the performance of the sales representatives, we selected "Energy" as the industry from the Share of Industry visual. Then, in the Total Opportunities Gained visual, we can see the name of the sales representative and the number of opportunities which belong to the selected industry.
The top three visuals show us the number of leads generated by the sales representatives and the revenue they have generated and lost.
At same time, we can use the Month Wise Performance visual to measure the month-wise performance of the sales representatives.
If you get an "Unable to connect to the remote server" message when trying to connect to your Salesforce account, see this solution on the following forum: Salesforce Connector sign in Error Message: Unable to connect to the remote server
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Power BI, Fabric, SQL, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayTraining
Learning path
Implement finance and operations apps - Training
Plan and design your project methodology to successfully implement finance and operations apps with FastTrack services, data management and more.
Certification
Microsoft Certified: Dynamics 365 Customer Experience Analyst Associate - Certifications
As a Microsoft Dynamics 365 customer experience analyst, you’re responsible for configuring, customizing, and expanding the functionality of Dynamics 365 Sales to create business solutions that support, automate, and accelerate the company's sales process.