Entity store data is available in Azure Data Lake - expected features in 2020 Release wave 1 plan from April to Sept 2020 in Microsoft Dynamics 365 Supply Chain Management
Entity store data is available in Azure Data Lake - expected features in 2020 Release wave 1 plan from April to Sept 2020 in Microsoft Dynamics 365 Supply Chain Management
Business value
Enable advanced analytics and AI (such as reasoning over data) across Finance and Operations
apps and other data in a customer's own Azure Data Lake. Finance and Operations apps provide
easy access to denormalized transnational data in a near real-time basis.
The same dataset that powers analytical workspaces is now available for your own reports and
data mash-up scenarios.
Feature details
Aggregate measurements are denormalized star schemas defined within Dynamics 365 Finance
and Operations apps. Aggregate measurements enable users to navigate operational data
without having to understand complex data schemas. Aggregate measurements are staged in
Entity store, and the operational data warehouse is included.
With the general availability of Entity store schemas in Azure Data Lake, customers can directly
access denormalized data for reporting and analytics. Aggregate measurements are stored in
Data Lake Storage as Common Data Model folders enabling rich data mash-up and analytical
scenarios. For example, aggregate measurement data can be attached as Power BI reference
data flows with and used for reporting with Power BI. Power users can easily create new data
mashups and reports in Power BI Desktop.
Developers and BI professionals can use tools such as Azure Synapse and Azure Data Factory to
work with data and create enterprise data warehouses.
*This post is locked for comments