Select the right analytical option for Microsoft Dynamics 365 Customer Engagement
Your analytics options in Dynamics 365 have grown massively over the past few versions.
With CRM 2011, our options included only the built-in dashboards and charts, export to Excel, or SSRS reporting. Now we can add the Online Excel experience, various ways of exporting data to Excel, editable grids, and of course Power BI, with or without replicating the data to an Azure SQL database. Add that there are three versions of Power BI - free, Pro, and Premium - and if you have really large datasets you can also consider using Azure Analysis Services.
While it is great to have many options, it also becomes more complex to recommend or decide on a specific strategy. Here are some questions you need to ask yourself first: