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…

InfoStrat Joins Microsoft CityNext

This month my company InfoStrat announced its participation in Microsoft CityNext, a global initiative empowering cities, businesses and citizens to re-imagine their futures and cultivate vibrant communities. Through the Microsoft CityNext initiative, Microsoft and InfoStrat will help leaders to do “new with less,” by combining the power of technology with innovative ideas to connect  governments, businesses and citizens with city services that increase efficiencies, reduce costs, foster a more sustainable environment and cultivate communities where people thrive.
In a recent study, IDC named Microsoft the most trusted smart-city vendor. "Whether it's traffic congestion, citizen services, energy efficiency or operating costs, our Microsoft CityNext partners are equipped to tackle whatever problem or priority local governments want to address. Microsoft’s IDC smart-city scores are really a credit to our partners, which leverage our trusted cloud platform, powerful data analytic…