In this blog, I will demonstrate how to visualize your data with Power BI from the customer relation management solution, Microsoft Dynamics 365 CRM, in less than 10 minutes!
Microsoft has made great strides in the field of SaaS (Software as a Service) applications over the last few years. More popular than ever, Power BI positions itself today as one of the best data visualization solutions on the market.
Although this tutorial is “sales-oriented” using Microsoft Dynamics 365 CRM, note that Microsoft offers the same possibilities with its Customer Service, Marketing and ERP modules.
To be able to follow our tutorial, you will need:
If you do not have the “Sales” Microsoft Dynamics 365 instance, you can install a 30-day trial version here.
Power BI is available in 44 languages. To change the language settings, go to Settings – General – Language and select the language of your choice.
Always trying to make applications easily accessible, Microsoft developed some applications within Power BI. In the left-end side menu, got to Apps and click Get apps:
In the search field, type the application’s name Sales Analytics for Dynamics 365:
To connect the Sales Analytics for Dynamics 365 app to your Microsoft Dynamics 365 CRM, add your Microsoft Dynamics 365 CRM’s URL and enter the month corresponding to the end of your fiscal year:
To be able to connect from Power BI to Microsoft Dynamics 365 CRM, I suggest using the “OAuth2” option:
You can now access the “Sales Analytics for Dynamics 365” application:
For the purpose of this tutorial, I will use data from Microsoft Dynamics 365 trial version so you can replicate the same. Consequently, when you open the application you just installed, you will note that graphs are empty:
With a simple change of filters, I can adjust the context and go on with my task.
Here is an example to complete in one of the application’s tabs. Chose every fiscal period instead of the current period:
You are now able to see graphs:
Microsoft Dynamics 365 CRM offers 10 default tabs, each containing several reports.Here are the ones that, according to me, have the greatest value-add:
Note that you can see more data by simply clicking “Show data”:
The source table of this report is displayed at the bottom of the graph. You can use the same procedure for all your reports, without exception.
Among others, these 3 reports (Leads by Rating, Leads by Source and Leads by Industry) offer and good overview of leads in a Sales/Marketing setting.
These reports are fundamental to the analysis of your data, which you can also configure according to your specific business needs. What is essential in the visualization and analysis of data is to be able to rely on powerful systems that are easy to set up as is Power BI. However, your data must be of good quality for you to draw relevant insights from it.
As promised, you can see that with minimal effort, you can benefit from a relevant analysis of your data. Accessible on any type of devices, you can visualize your reports at any time, using the Power BI mobile application (available on App Store and Google Play) or on a traditional web browser.
A system such as Microsoft Dynamics 365 CRM is the perfect tool to maintain the standard of your business processes and provide full support to your day-to-day operations.