MB2-713 Certification (Microsoft Dynamics CRM 2016 Sales) – Sales Analysis (Built in Reports)

Sales Analysis is the next topic I intend to review as I prepare for the MB2-713 certification (Microsoft Dynamics CRM 2016 Sales)

I’ve already covered goals in a previous post, in addition to goals you’ll need to be aware of the Excel feature, understand charts and dashboards. Plus, you’ll need to know about PowerBI dashboards. As the exam has a sales focus you’ll be expected to be aware of the built-in reports.

Built in Reports

Microsoft Dynamics CRM 2016 contains multiple out of the box reports. Access to these can be found in the reporting option in the sales area of CRM.

Bespoke reports cover all aspects of CRM but many of them have a sales focus. Below is a list of the sales related out of the box reports. (I have removed marketing and service specific reports.)

Name Description
Account Distribution Identify patterns in top revenue-generating accounts.
Account Overview View a one-page overview of an account.
Account Summary View a chronological summary of an account.
Activities Display a list of activities.
Competitor Win Loss Compare how your sales team performs against competitors.
Invoice View an invoice and its line items.
Invoice Status View your accounts receivable.
Lead Source Effectiveness Compare your lead sources.
Neglected Accounts Identify accounts that have not been contacted recently.
Neglected Leads Identify leads that have not been contacted.
Order View an order and its line items.
Products By Account View products that are used by an account.
Products By Contact View products that are used by a contact.
Progress against goals View progress against goals
Quote View a quote and its line items.
Sales History Understand past sales performance.
Sales Pipeline View anticipated potential sales.

Selecting a report will initially provide a dialog to allow the report content to be filtered. Below is an example of the sales pipeline report;

Clicking run report will then generate a report and display the results. Once the report is displayed you can further filter and group the data. For example, with the sales pipeline report I can filter by sales process, group by date, rating, sales stage (etc) and opt to display estimated revenue or weighted revenue.


Reported can also be exported as XML files, CSV files, PDF, MTHML, Excel, Tiff or Word. Or you could just print it!

You should remember that when running reports, the CRM security model will still apply, each report will only ever contain data that can be accessed using your role. A sales manager (for example) might be able to report on his team. Whilst an individual sales person will remain limited to just their own opportunities / accounts.

Another approach to running reports is to navigate to the entity and select the report from a list view. Below you can see that I have selected the “My Active Accounts” view and I can run the account overview, account summary and products by account on the selected accounts. Or I can run the sales history report against all accounts.

Running the Account Overview report with one account selected initially presents the dialog below.

Once an option is selected the report is generated and displayed as it was when run from the reports option. I selected to run the report account overview on just the record I had selected. My results looked like this.

A third method to access reports exists. Here you can see that I have opened an individual order and I can run the “Order” report directly from the order form.

My test order looked like this ……

In addition to the out of the box reports, users can create additional reports using the report wizard or developers can create reports tailored exactly to the company’s requirements. The creation of custom reports will not be covered in the MB2-713. I believe it should be enough just to know that creating customer reports is available.

Hopefully this post has given you an insight into the out of the box reports available in Dynamics CRM. As part of you prep for the MB2-713 it is worth running some actual reports to become familiar with what reports are available, how they can be run and what export options exist.

In my next post I will continue to look at sales analysis by reviewing how to export data to Excel. J

3 thoughts on “MB2-713 Certification (Microsoft Dynamics CRM 2016 Sales) – Sales Analysis (Built in Reports)

  1. Great post. MB2-713 will be the next certification I will study for.
    I does seem a bit strange that the built in reports are not updated to be in line with the new features in CRM. You mention the Sales Pipeline Report. This does not show the pipeline based on the phases in the Business Process Flow. It is based on the legacy field Sales Stage (as you mention you can filter by). This does give an odd looking report where all opportunities are in the empty sales stage. Sales Stage field is no longer on the opportunity field in CRM Out of the box. You have to add it, customize it so it has stages corresponding to your pipeline phases and then add a workflow that updates the field according to the pipeline phase. Quite a hassle.
    Power BI standard CRM dashboard also makes the pipeline from the old sales stage field, so the pipeline looks empty.


  2. Pingback: MB2-713 Certification (Microsoft Dynamics CRM 2016 Sales) – Revision Guide | Microsoft Dynamics CRM and Unified Service Desk

  3. Pingback: MB2-713 Certification (Microsoft Dynamics CRM 2016 Sales) – Revision Guide - Microsoft Dynamics CRM Community

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s