Skip to main content

Options for Reviewing Sales Opportunities in Dynamics 365 (CRM)

Using a customer relationship management (CRM) system is a great way to get a better handle on your sales efforts.  If have have a CRM, one of the best ways to drive adoption among your sales force is to use it as the basis of sales pipeline meetings.

Microsoft Dynamics 365 offers several options for how you can use it to review sales opportunities. At my company InfoStrat, we prefer to log into Dynamics 365 and examine the sales pipeline rather than generate static reports.  That way we can update information on the fly as we discuss each opportunity.

My favorite is to start with the sales funnel graph in the standard Sales Activity dashboard:

The sales funnel shows the estimated dollar value of each opportunity, segmented by the sales stage.

Next, click the center icon in the upper righthand corner of the chart:


Now you can see the chart alongside the underlying opportunity records.


By default, the chart shows all opportunities, but if you click on a segment of the funnel, the records will be filtered so only those from the selected segment are shown:


In our typical sales meeting, we use the funnel starting at the bottom and working our way up to unqualified opportunities.

Some of our clients prefer other approaches.  The most common are to run the Sales Pipeline report or a custom report that is similar.  This report may be exported to PDF and emailed to people who do not use Dynamics 365. You can also change your report criteria at runtime as shown below.



You can also export opportunities to Excel.  One way is to click the Export to Excel option in the funnel graph page:


The other approach is to use Excel templates.  These may be as simple or complex as you would like to make them, and may include graphs.


The resulting Excel workbook will contain your opportunity records:


Finally, some client prefer to use PowerPoint to discuss opportunities at sales meetings or for pipeline reviews.  Although Microsoft doesn't provide a direct export to PowerPoint, they provide tools you can use to automate the creation of the presentation. I will cover this in a future blog post or contact me if you would like to learn more.

Popular posts from this blog

PowerApps Portal: The Successor to Microsoft Dynamics Portal

In case you have been reviewing Microsoft's new pricing for its Dynamics products which was released this month and have been unable to find Dynamics Portal, it has been rebranded as PowerApps Portal and shifted to the PowerApps side of the Microsoft product family.


Rebranding the portal product underscores the importance of app scenarios involving external users such as customers and suppliers.  It also provides a simpler interface than Dynamics 365 for occasional users.

The new portal pricing is based on the number of unique users who log into the portal each month (for authenticated users) and on the number of page views for anonymous users.  "A login provides an external authenticated user access to a single portal for up to 24 hours. Multiple logins during the 24-hour period count as 1 billable login. Internal users can be licensed either by the PowerApps per app or per users plans, or a qualifying Dynamics 365 subscription."

Pricing starts at $200/mo. for 100 dail…

ScreenMeet Remote Support Tool for Dynamics 365 Customer Service

I met Lou Guercia when he was president and CEO of Scribe Software, the leading CRM integration tool.  Scribe was acquired by TIBCO Software in 2018.  I recently reconnected with Lou and learned about ScreenMeet, the company he joined as chief operating officer.   The following is a description of the product provided by ScreenMeet:

ScreenMeet is a cloud-based remote support tool designed to integrate with Dynamics 365 Customer Service. By enabling customer service and IT support organizations to address critical technical issues directly from their CRM or ticketing platform, it streamlines the process and provides a fully browser-based support experience.

You can also use ScreenMeet with other CRM products or even on its own without a CRM.

Here is a short video demo of ScreenMeet with Dynamics integration:


ScreenMeet - Cloud-based Remote Support Integrated with Dynamics 365 Customer Support Once integrated with a Dynamics 365 CS organization, the ScreenMeet widget appears on Case pa…

The DATA Act Driving Grant Management Automation

The Digital Accountability and Transparency Act enacted in May 2014 calls for making spending data available in open, standardized formats to be published online.  It is a continuation of transparency initiatives and lessons learned with experiences such as grants.gov, the 2009 economic stimulus under the Recovery Act and the spending site USASpending.gov.

Government grantees will have significant new administrative responsibilities.  Many organizations that were tracking grants in spreadsheets or documents will have to adopt more sophisticated automated grant management systems such as Microsoft Grants Manager to keep up with reporting rules.

For profit companies will lose some privacy as a result of this law.  Grant recipients will be required to disclose information including officer salaries.

Continued improvements to publishing grant opportunities such as grants.gov may make it easier to find grants. These reforms together are designed to improve the effectiveness of grant prog…