Having plentiful choices can sometimes be overwhelming, hence it is the job of a specialist/advisor to use a select tools from a plethora of tools and tailor-fit them to the analytical needs of the customer.
Let's explore key data options available in Dynamics 365 for Finance and Operations, Enterprise edition (AX) for usage in analytics:
- AX database (AXDB): This is the main OLTP transactional database of your Dynamics 365 for Finance and Operations, Enterprise edition in SQL.
- AX data warehouse (AXDW): This is the Entity Store for data warehousing, available out of the box for Dynamics 365 for Finance and Operations, Enterprise edition in SQL. It supports in-memory processing for large-volume scenarios. ...