One Dynamics One Platform : Analytics - Delta Lake Synapse Link

Hello the Community !

Hope you had good summer holidays, starting next season articles, it was time for me to write this new article to explain again the convergence of the whole Dynamics Platform : on the Analytics part now !

Dynamics365, PowerBIAurélien ClereAugust 30, 2023BI, Dynamics365 Datalake Comments

Modern Datawarehouse Dynamics365 Finance and Operations

Hello the Community ! New global post on technical architecture for Reporting / BI and Analytics with Dynamics 365 Finance and Operations. Here I will present a new capacity to push data coming from Tables and Entities into an Azure Data Lake Storage in real time as well as how to use it after with Azure Synapse Analytics and PowerBI. How to build a Modern Datawarehouse architecture for your ERP and expose custom views & model for your business users in PowerBI. How to use DirectQuery mode with SqlOnDemand mode (pay as query mode - serverless) + Azure Analysis Services : Let’s jump in !

Dynamics365, PowerBIAurélien ClereAugust 25, 2020Synapse, Azure, Datawarehouse, BI Comment

Dynamics 365 Finance and Operations Reporting : DataLake and PowerBI Dataflow

Hello the community !

New article for you about a Technical Architecture optimized for Dynamics 365 Finance and Operations about Reporting purpose - BI.

Here I will present with Azure Data Lake and PowerBI Dataflow how you can deliver a global Datawarehouse for your ERP D365F&O and also CDS or other data sources ; how you can achieve to propose an easy & comprehensive DATA model for end-users (business users) in order to let them built their own report in PowerBI Desktop….