Saturday, May 30, 2020

Power Platform Analytics for Microsoft Dynamics 365 CE Part 2 - Common Data Service Analytics Part 1

This tab shows all common data service calls related statistics for further analysis. Using this developers can get more idea about following areas.

  •     Performance of Plugins/APIs/workflows
  •     Failure or pass rate of Plugins/APIs/Workflows
  •     Entity usage of dynamics CE
  •     User operations
  •     User access modes
  •     Mail box usage
We will describe each and every components in related section.
In the Home section it will show brief summary about Active Users, API Calls, API Pass Rate and Total Executions. Those data you can easily find out in relevant section with more details.


However first you need to set correct date range you need to analyze. You can set date range and environment as filters like following. This will apply for all other tabs and will show historical data according to the filter settings



Active Users Analytics

In this analytic group will show how many active users are in your system. To get more details about graphs I filtered data to single day.
First graph will show how many users are logged in to the given environment. If you select single day it will show data hourly or it will scale up based on the filters you added (e.g. If you select month it will show active users by day.



Following graph shows different operations performed by user based on time scale. This graph will show exact operation count by time and operation. This graph will help to get idea about mostly performed operations by time.


Following graph will show most active users based on the operations performed by user. This will help administrators to identify usage of CRM and who are the users most active. Also it will help to get idea about what are the operations which perform mostly and adjust CRM performance based on the operations. According to the example we have considerable amount of data reads than creates. We can optimize our read queries with “nolock” after some analysis about entities and data.



Total Operation graph helps to identify peak hours which system execute large number of operations. This will help administrators to change resource allocations plans dynamically. If you select filter criteria to years you can observe time periods which generate much traffic.


Total Page Request graph shows how much page requests generate by system/users in forms/reports/dashboards. At the moment current environment did not generate such request. However in live environments will get data in to this graph as well.


No comments:

Post a Comment