An analytical schema is a repository for master and transactional data in Microsoft Fabric Data Warehouse. Use the analytical schema to gain insights into the data.
When you run Cloud Data Integration taskflows, Cloud Data Integration transforms and publishes master data from the staging tables into the dimension and fact tables of the analytical schema in Microsoft Fabric Data Warehouse.
The analytical schema includes the following dimension and fact tables:
•tbl_address_dim
•tbl_calendar_dim
•tbl_customer_dim
•tbl_email_dim
•tbl_esg_score_dnb_dim
•tbl_esg_score_dnb_environmental_reason_dim
•tbl_esg_score_dnb_governance_reason_dim
•tbl_esg_score_dnb_social_reason_dim
•tbl_item_dim
•tbl_location_dim
•tbl_phone_dim
•tbl_supplier_dim
•tbl_sales_txn_fact
•tbl_supplier_order_txn_fact
Based on your use case, you can create or edit the dimension and fact tables.
The following image shows the dimension tables of the Microsoft Fabric analytical schema and their relationships with the Sales fact table:
Note: Some tables contain more fields than shown in the diagram. For details, refer to the analytical schema in Microsoft Fabric Data Warehouse.
The following image shows the dimension tables of the Microsoft Fabric analytical schema and their relationships with the Supplier Order fact table:
Note: Some tables contain more fields than shown in the diagram. For details, refer to the analytical schema in Microsoft Fabric Data Warehouse.
