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

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…

Dynamics 365 for Government Contractors (GovCon) Frequently Asked Questions (FAQ)

One of InfoStrat's most popular solutions is Dynamics 365 for Government Contractors (GovCon).



Here are some answers to frequently asked question on this solution:
Can I add new fields to the solution?  -- Yes, the solution is fully customizable and you can add your own new fields to any form, view or report.Does Dynamics 365 for GovCon work on mobile devices?  -- Yes, Microsoft offers mobile apps for all the most popular platforms including iPhone, iPad, and Android phone and tablets.Does Dynamics 365 connect with bid data systems such as Deltek and Onvia?  -- Some information services, such as Onvia, offer integration with Dynamics 365.  Others require third party solutions such as the InfoStrat integration with Deltek GovWin IQ.What do customers typically customize for their unique requirements? -- Not all contractors follow the same steps in the capture process.  Most clients will tailor the business process to add or remove steps in order to match their sales methodology.  Of…

Introducing InfoStrat ProShop Professional Services

InfoStrat has recently announced a new service offering called ProShop to allow its clients access to dedicated support and software development services throughout the year outside of a structured project.  This service complements InfoStrat's specialties of Microsoft Dynamics, SharePoint, ClickDimensions, Scribe, Sitecore, and custom development.

ProShop addresses your information technology goals without hiring a fulltime overhead employee.
For a predictable monthly subscription, you’ll get personalized support. Your costs are fixed, so you can budget without surprises. You’ll have a dedicated consultant who will help you identify issues, upgrades, customizations, training, and goals. Whenever you need help, you know exactly how to get it—your consultant, backed by our team of experts.

While most of our services are either projects staffed by a full team or staff augmentation of certain roles to a project team, clients may need not only ongoing support but ongoing development s…